MySQL dump recovery takes too slow
Hi,
When recovering a 1GB database through mysql dump takes too slow? May I know what are the likely causes of it?
- It took 28hours just to restore a 1GB database (tested it with MyISAM and Innodb)
My.cnf -
query_cache_size=256M
key_buffer_size=256M
table_cache=256
innodb_buffer_pool_size = 256M
innodb_additional_mem_pool_size = 20M
Server specs -
2GB RAM
ec2 server small instance
I am using MySQL dump to recover 1GB db, may I know what are the likely causes that it is taking too slow?
Thanks in Advance.
Regards,
Reigner Yrastorza
Subject
Views
Written By
Posted
MySQL dump recovery takes too slow
5134
June 11, 2008 06:59AM
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.