Re: mysqldump insert very slow
> 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).
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.