LinVx

MySQLTuner es un script escrito en Perl que le ayudará con su configuración de MySQL y hacer recomendaciones para un mayor rendimiento y estabilidad. En unos segundos, mostrará las estadísticas acerca de su instalación de MySQL y las áreas en las que se puede mejorar.
Nos bajamos el script y lo ejecutamos:

LinVx:~# perl mysqltuner.pl

 >>  MySQLTuner 1.0.0 - Major Hayden 
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.77-1-log
[OK] Operating on 32-bit architecture with less than 2GB RAM

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 3M (Tables: 126)
[!!] Total fragmented tables: 3

-------- Performance Metrics -------------------------------------------------
[--] Up for: 1d 9h 53m 48s (72K q [0.591 qps], 1K conn, TX: 58M, RX: 9M)
[--] Reads / Writes: 71% / 29%
[--] Total buffers: 250.0M global + 7.4M per thread (50 max threads)
[OK] Maximum possible memory usage: 621.9M (54% of installed RAM)
[OK] Slow queries: 0% (0/72K)
[OK] Highest usage of available connections: 6% (3/50)
[OK] Key buffer size / total MyISAM indexes: 128.0M/1.1M
[OK] Key buffer hit rate: 97.5% (87K cached / 2K reads)
[OK] Query cache efficiency: 88.6% (56K cached / 63K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 1K sorts)
[OK] Temporary tables created on disk: 17% (289 on disk / 1K total)
[OK] Thread cache hit rate: 99% (3 created / 1K connections)
[OK] Table cache hit rate: 25% (143 open / 561 opened)
[OK] Open file limit used: 4% (289/6K)
[OK] Table locks acquired immediately: 100% (12K immediate / 12K locks)

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance

Vemos que nos pide que optimicemos las tablas, lo podemos hacer con este comando:

mysqlcheck -o -A

Los parámetros de mysqlcheck son -o (optimizar) y -A (all databases).