MySQL Forums
Forum List  »  Data Recovery

MySQL dump recovery takes too slow
Posted by: Reigner Yrastorza
Date: June 11, 2008 06:59AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL dump recovery takes too slow
5069
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.