MySQL Forums
Forum List  »  Backup

Re: mysqldump insert very slow
Posted by: Rick James
Date: June 20, 2012 07:44PM

> They both are set to 1GB (the system has 4GB of total memory).
Too high. You may be "swapping".

If you are using InnoDB only, then buffer_pool = 1400M, key_buffer = 50M

What were the args on mysqldump? One of them specifies batched INSERTs vs one row per INSERT.

> FOREIGN_KEY_CHECKS=0
So, the FK checks are turned off during the load. (Good.)

> manually switch them off (SET statement on they mysql console) and insert the dump
Your action was overridden by the dump.

Please show us
SHOW CREATE TABLE
SHOW TABLE STATUS
for the largest table(s).

Options: ReplyQuote


Subject
Views
Written By
Posted
3692
June 19, 2012 09:21AM
Re: mysqldump insert very slow
1821
June 20, 2012 07:44PM
2281
June 21, 2012 07:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.