Re: Performance increased after mysqldump restoration ?
Posted by:
Rick James
Date: April 25, 2009 04:16PM
MyISAM or InnoDB?
Have you run ANALYZE TABLE?
What does SHOW TABLE STATUS say about "free space"?
Do some tables have a lot of delete & insert traffic?
What are the SELECTs like? That is, do they fetch rows in key order or random?
How big is RAM? What are the cache settings?
In other words, there are a lot of things that _might_ factor into the answer. Dumping (via mysqldump) and reloading the data does some things:
* Fragmentation in a table is removed -- but to different degrees based on some of the above question.
* Cache allocation can make a big difference -- perhaps the two machines are not configured the same.
* etc.
Subject
Written By
Posted
Re: Performance increased after mysqldump restoration ?
April 25, 2009 04:16PM
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.