Hola,
Quisiera saber si alguien me puede decir que hacer con este MySQL para optimizar su configuracion. Os paso lo que me cuenta el MySQLTunner:
Código:
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.46-log
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 13G (Tables: 4224)
[!!] Total fragmented tables: 60
-------- Performance Metrics -------------------------------------------------
[--] Up for: 5h 7m 23s (25M q [1K qps], 192K conn, TX: 19B, RX: 11B)
[--] Reads / Writes: 84% / 16%
[--] Total buffers: 24.0M global + 2.7M per thread (500 max threads)
[OK] Maximum possible memory usage: 1.4G (11% of installed RAM)
[OK] Slow queries: 0% (1/25M)
[OK] Highest usage of available connections: 10% (53/500)
[!!] Key buffer size / total MyISAM indexes: 8.0M/4.1G
[!!] Key buffer hit rate: 92.3% (499M cached / 38M reads)
[!!] Query cache is disabled
[OK] Sorts requiring temporary tables: 0% (322 temp sorts / 552K sorts)
[!!] Joins performed without indexes: 5042
[OK] Temporary tables created on disk: 0% (4K on disk / 448K total)
[!!] Thread cache is disabled
[!!] Table cache hit rate: 0% (64 open / 1M opened)
[OK] Open file limit used: 4% (112/2K)
[OK] Table locks acquired immediately: 99% (42M immediate / 42M locks)
Lo de los JOIN sin indices ya lo sabia y estoy trabajando en ello.
Tengo 12GB de RAM.