Mysql-Tuning

MySQL Tuning (for dummies)

Download the mysql tuning script from http://mysqltuner.com(approve sites)

Run the script: perl mysqltuner.pl

Change the parameters in /etc/mysql/my.cnf per the recommendations at the end of the script analysis.

This will possibly help you begin to understand some of the inner working of MySQL. This will by no means replace a DBA, but it will point you in the right direction as far as what variables need to be adjusted to better your performance.

Courtesy of Francisco Barcenas(fbc<at>webaso.net)

just little adds from Cali:

personnaly i'm using the MySQL Performance Tuning Primer Script available at this url: http://www.day32.com/MySQL/ you've just run it after about one week of use of your server to be realistik in front of your SQL server settings.

Edit - History - Print - Recent Changes - Search

Page last modified on January 10, 2010, at 05:16 PM EST