<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Hola, estoy corriendo el mysqltuner como user root, osea sobre todas las DB's.. tengo solo 3 db's y una que es la que es la de producción.<br>---------------como user root ---------------<br>-------- General Statistics --------------------------------------------------<br>[--] Skipped version check for MySQLTuner script<br>[OK] Currently running supported MySQL version 5.0.51a-24+lenny3-log<br>[OK] Operating on 64-bit architecture<br><br>-------- Storage Engine Statistics -------------------------------------------<br>[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster <br>[--] Data in MyISAM tables: 2G (Tables: 94)<br>[--] Data in InnoDB tables: 50M (Tables: 15)<br>[!!] Total fragmented tables: 5<br><br>-------- Performance Metrics -------------------------------------------------<br>[--] Up for: 10h 1m 22s (559K q [15.511 qps], 32K conn, TX:
330M, RX: 38M)<br>[--] Reads / Writes: 56% / 44%<br>[--] Total buffers: 74.0M global + 2.6M per thread (550 max threads)<br>[OK] Maximum possible memory usage: 1.5G (38% of installed RAM)<br>[!!] Slow queries: 17% (96K/559K)<br>[OK] Highest usage of available connections: 2% (11/550)<br>[OK] Key buffer size / total MyISAM indexes: 16.0M/2.6G<br>[OK] Key buffer hit rate: 99.9% (378M cached / 543K reads)<br>[OK] Query cache efficiency: 41.6% (141K cached / 339K selects)<br>[OK] Query cache prunes per day: 0<br>[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 65K sorts)<br>[!!] Temporary tables created on disk: 36% (32K on disk / 88K total)<br>[OK] Thread cache hit rate: 99% (22 created / 32K connections)<br>[!!] Table cache hit rate: 4% (64 open / 1K opened)<br>[OK] Open file limit used: 3% (83/2K)<br>[OK] Table locks acquired immediately: 99% (390K immediate / 390K locks)<br>[!!] InnoDB data size / buffer pool: 50.6M/8.0M<br><br>--------
Recommendations -----------------------------------------------------<br>General recommendations:<br> Run OPTIMIZE TABLE to defragment tables for better performance<br> MySQL started within last 24 hours - recommendations may be inaccurate<br> When making adjustments, make tmp_table_size/max_heap_table_size equal<br> Reduce your SELECT DISTINCT queries without LIMIT clauses<br> Increase table_cache gradually to avoid file descriptor limits<br>Variables to adjust:<br> tmp_table_size (> 32M)<br> max_heap_table_size (> 16M)<br> table_cache (> 64)<br> innodb_buffer_pool_size (>= 50M)<br>--------------------------------------------------------<br><br>El sever tiene 4GB de memoria.... <br>estas variables las maneja en memoria ? en el disco ?<br> tmp_table_size (>
32M)<br>
max_heap_table_size (> 16M)<br>
table_cache (> 64)<br>
innodb_buffer_pool_size (>= 50M)<br>....<br>le asigno el doble de lo que me recomienda o lo mínimo ?.. tambíen podría ir probando.. pero quizá haya algún patrón <br><br>Gracias!.<br></td></tr></table><br>