Installing backup

[GameBlonD]

I am trying to excute l2jdb.sql to my linux server , running for 5 hours and still not finish  is this suppose to be so many hours?

 

I run this command:

 

mysql -u user -p data_base_name_here < l2jdb.sql

 

From ps -A i see one process    7 ?        05:28:58 migration/1 .

 

Thanks.

 

[dpbBryan]

Perhaps you should check your query logs to see whats going on.

[Diabaths]

why dont make one ssh connection from your local navicat!!!!

to easy to handle your server

[xdem]

it depends on the computer, my laptop executes the same sql scripts in 3 minutes while my desktop some hours.... however you shall not care about the time it takes since your sql backup is very big.... so just let it finish

[dpbBryan]

it depends on the computer, my laptop executes the same sql scripts in 3 minutes while my desktop some hours.... however you shall not care about the time it takes since your sql backup is very big.... so just let it finish

 

I'm not trying to be a prick but is it your job to shitpost useless advice to get your post count up or something? What kinda -beep-ing dumb advice is that. You shouldn't ever have a query that takes 5 hours to finish, especially if it's just inserting data based on their key values back into the database. If you're having performance problems refer to the logs inside your mysql directory. A query log is generated by default I think of SQL queries that take longer than 15 minutes to execute so you can see for example what its trying to do.

 

 

[xdem]

I'm not trying to be a prick but is it your job to shitpost useless advice to get your post count up or something? What kinda -beep-ing dumb advice is that. You shouldn't ever have a query that takes 5 hours to finish, especially if it's just inserting data based on their key values back into the database. If you're having performance problems refer to the logs inside your mysql directory. A query log is generated by default I think of SQL queries that take longer than 15 minutes to execute.

my advise whas simple, patience... :/

[dpbBryan]

my advise what simple, patience... :/

 

No your advice is retarded and misguiding.

http://stackoverflow.com/questions/12152012/why-how-do-my-sql-queries-get-faster-with-use

 

1.300.000 entries based on a WHERE condition making the query more complicated.

Time: 3 seconds cached to 5 minutes uncached.

 

Sure seems like hell of a lot less than 300 minutes in comparison. GameBlonD don't accept this guys answer. There could potentionally be something wrong with your mysql instance setup or configuration. If you follow this guys advice you could be running a faulty installation without knowing. Get to the real issues of problems, don't half ass it.

[xdem]

No your advice is retarded and misguiding.

http://stackoverflow.com/questions/12152012/why-how-do-my-sql-queries-get-faster-with-use

 

1.300.000 entries based on a WHERE condition making the query more complicated.

Time: 3 seconds to 5 minutes.

 

Sure seems like hell of a lot less than 300 minutes in comparison. GameBlonD don't accept this guys answer. There could potentionally be something wrong with your mysql instance setup or configuration. If you follow this guys advice you could be running a faulty installation without knowing. Get to the real issues of problems, don't half ass it.

 

nope, its just how the cpu priorizes that execution, nothing will be abnormal after installation even if it takes 2 days...

[dpbBryan]

nope, its just how the cpu priorizes that execution, nothing will be abnormal after installation even if it takes 2 days...

 

You're post doesn't even make sense.

 

This guy is using linux which makes me believe he probably either had to build the binaries himself or grabbed pre-built binaries from the repositories. In that case, a portion of his configuration had to be done by him and not an automatic launcher. Theres potentionally something here he could have gotten wrong.

 

Theres no way he should ever accept the answer 'wait'. Unless this guy had about 20 billion players the relationships between these tables are far from complex, and are simply meant to store persistent data when not in use by the gameserver. There is absolutely no reason what so ever a backup installation should take 5 hours. I work with ERP systems which have millions upon millions of entries regarding different business stuff. The most I've seen one of these take is about 8 hours (given that it's a dedicated database server, but still).

 

[xdem]

You're post doesn't even make sense.

 

This guy is using linux which makes me believe he probably either had to build the binaries himself or grabbed pre-built binaries from the repositories. In that case, a portion of his configuration had to be done by him and not an automatic launcher. Theres potentionally something here he could have gotten wrong.

 

Theres no way he should ever accept the answer 'wait'. Unless this guy had about 20 billion players the relationships between these tables are far from complex, and are simply meant to store persistent data when not in use by the gameserver. There is absolutely no reason what so ever a backup installation should take 5 hours. I work with ERP systems which have millions upon millions of entries regarding different business stuff. The most I've seen one of these take is about 8 hours (given that it's a dedicated database server, but still).

 

ok mr obvius, im not expert on these things but I tried to say to that guy that the execution will not have any problem... I know from personal experience that the first time your CPU encounters a specific execution it will get decreased over time as more executions take place thereafter...

 

Its obvius that the first execution takes time, and he has to be patient.... Depending on the staff stored on that sql the time will increase even more, cause its the first execution.

 

Do you think he has a super computer? he has a home desktop they are not ment to be super fast with executions of 1kk lines. just common sense

[dpbBryan]

ok mr obvius, im not expert on these things but I tried to say to that guy that the execution will not have any problem... I know from personal experience that the first time your CPU encounters a specific execution it will get decreased over time as more executions take place thereafter...

 

Its obvius that the first execution takes time, and he has to be patient.... Depending on the staff stored on that sql the time will increase even more, cause its the first execution.

 

Do you think he has a super computer? he has a home desktop they are not ment to be super fast with executions of 1kk lines. just common sense

 

It's called caching. For example when you do a SELECT from your database that entry that you just searched for is placed into your RAM so that if you search for the entry a second time it will be found quicker. And yes, as you saw in that link's example that I posted each time his selection query speed improved. However this doesn't apply here. Do you remember the first time you installed your Lineage 2 database? There are a lot of rows there but it doesn't take 5 hours to install the entire thing. It's also never taken me more than a few moments to reinstall an SQL backup and I mostly develop from home on my own computers, which aren't fancy either.

 

He doesn't need a super computer, people have been installing mysql on computers with 64MB and even 128MB ram. It's all dependent on the complexity of your data.

 

If you're not an expert on these things fine but don't give somebody such a sad excuse for an answer. You should be giving advice to users to consider all possibilities of things other than "just accept your issue." You don't learn things by just accepting whats put infront of you, you learn things by seeing mistakes you've made or poking around the details of technical things. Also since this forum's underlying premise is pretty much software development and programming.

[xdem]

It's called caching. For example when you do a SELECT from your database that entry that you just searched for is placed into your RAM so that if you search for the entry a second time it will be found quicker. And yes, as you saw in that link's example that I posted each time his selection query speed improved. However this doesn't apply here. Do you remember the first time you installed your Lineage 2 database? There are a lot of rows there but it doesn't take 5 hours to install the entire thing. It's also never taken me more than a few moments to reinstall an SQL backup and I mostly develop from home on my own computers, which aren't fancy either.

 

He doesn't need a super computer, people have been installing mysql on computers with 64MB and even 128MB ram. It's all dependent on the complexity of your data.

 

If you're not an expert on these things fine but don't give somebody such a sad excuse for an answer. You should be giving advice to users to consider all possibilities of things other than "just accept your issue." You don't learn things by just accepting whats put infront of you, you learn things by seeing mistakes you've made or poking around the details of technical things. Also since this forum's underlying premise is pretty much software development and programming.

 

Lol, this guy makes manual install of a backup sql not empty tables, you think that a pool of 500 players or even more gets executed in 60 seconds?

[dpbBryan]

Lol, this guy makes manual install of a backup sql not empty tables, you think that a pool of 500 players or even more gets executed in 60 seconds?

 

Best: 0,031 seconds

Worst; 0,140 seconds

 

900 fresh uncached inserts, finished in rougly +/- 30 seconds to 126 (2 min) seconds (900 entries * ~0,031 seconds [0,14]):

3600 fresh uncached inserts, finished in roughly +/- 111 seconds to 504 (8,4 min) seconds (3600 entries * ~0,031 seconds [0,14]):

 

By my estimations on my dual core AMD from 20 years ago 500 players should be done in about +/- 15,5 to 70 seconds. That seems a lot less than 18.000 doesn't it?

 

 

[xdem]

900 fresh uncached inserts, finished in rougly +/- 30 seconds ( 900 entries * ~0.031 seconds):

3600 fresh uncached inserts, finished in roughly +/-2 minutes (3600 entries * ~0.031 seconds):

 

By my estimations on my dual core AMD from 20 years ago 500 players should be done in about +/- 15.5 seconds.

 

 

 

w/e u still didnt respond to his problem

[dpbBryan]

w/e u still didnt respond to his problem

 

Perhaps you should check your query logs to see whats going on.

 

Yes I did, I told him to check his query log. Infact it's the second post here. When MySQL executes a really long query it begins to write what it's doing inside a log file so you can understand what's wrong with your query.

[GameBlonD]

Guys seems like linux command was wrong i run the 3 sql files that i wanted with this command .\ accounts.sql

From mysql  it finds the location auto and execute it.