MySQL Performance Tuning Tips

Tips on how to improve the performance of your MySQL Server.

Also see: Basic MySQL Performance Monitoring

MySQLTuner can identify the fragmented table count. To defragment all the tables on the MySQL database server

sudo mysqlcheck --optimize -A -uroot -p

MySQLTuner will also provide suggested adjustments to my.cnf.

One thought on “MySQL Performance Tuning Tips

  1. Pingback: Installing MySQL on Snow Leopard | Coding and Server Syntax Examples

Leave a Reply

Your email address will not be published. Required fields are marked *

This Blog will give regular Commentators DoFollow Status. Implemented from IT Blögg