MySQL Performance Optimization Part II

 

You can speed up index scans if you periodically perform a void ALTER TABLE operation, which causes MySQL to rebuild the table:

ALTER TABLE tbl_name ENGINE=INNODB;

or 

ALTER TABLE tbl_name ENGINE=MYISAM;

Another way to perform a defragmentation operation is to use mysqldump to dump the table to a text file, drop the table, and reload it from the dump file.

Please feel free to use the comments form below if you have any questions or need more explanation on anything.

Tags

mysql, performance, optimization, optimize,

Popular Searches

linux, php, mysql, ubuntu, mysql mysql, tools, install mysql, gearman, source code, java

more>>

Comments (write a comment):

0 comments so far. Be the first one to leave a comment on this article.

 

Comment
 

 
| Members | Support Us | Using this site means you accept its terms | Contact Us | Site Map |