Installation


Upgrades


DTC-Xen Installation


DTC-Xen / Dom0 Howtos

DTC-Xen / DomU Howtos

FAQ


DTC Howtos


Manuals


Features


Roadmap


Devel docs


Wiki - i18n


Wiki - Meta


Mysql-Tuning

MySQL Tuning (for dummies)

Download the mysql tuning script from http://mysqltuner.com

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.

Debian Lenny ('stable' at the time of writing) has a package mysqltuner, which produces hints on optimizing my.cnf based on mysql running statistics.

Editing this page means accepting its license.

Page last modified on May 11, 2010, at 07:29 AM EST