14/07/2014, 04:08
|
| | Fecha de Ingreso: mayo-2012
Mensajes: 5
Antigüedad: 12 años, 7 meses Puntos: 0 | |
Respuesta: Optimizacion servidor muchos prestashop y wordpress Añado el reporte de la ejecución del script mysqltuner.p
[OK] Currently running supported MySQL version 5.1.73
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +CSV +InnoDB +MRG_MYISAM
[--] Data in MyISAM tables: 849M (Tables: 4420)
[--] Data in InnoDB tables: 479M (Tables: 8971)
[--] Data in MEMORY tables: 0B (Tables: 38)
[!!] Total fragmented tables: 260
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 35s (303 q [8.657 qps], 23 conn, TX: 1M, RX: 49K)
[--] Reads / Writes: 95% / 5%
[--] Total buffers: 2.5G global + 3.0G per thread (151 max threads)
[!!] Maximum possible memory usage: 459.5G (9756% of installed RAM)
[OK] Slow queries: 0% (0/303)
[OK] Highest usage of available connections: 8% (13/151)
[OK] Key buffer size / total MyISAM indexes: 32.0M/630.1M
[OK] Key buffer hit rate: 97.6% (4K cached / 116 reads)
[OK] Query cache efficiency: 29.8% (77 cached / 258 selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 22 sorts)
[OK] Temporary tables created on disk: 0% (0 on disk / 23 total)
[!!] Thread cache hit rate: 43% (13 created / 23 connections)
[OK] Table cache hit rate: 95% (153 open / 160 opened)
[OK] Open file limit used: 0% (122/20K)
[OK] Table locks acquired immediately: 100% (313 immediate / 313 locks)
[!!] Connections aborted: 17%
[!!] InnoDB buffer pool / data size: 8.0M/479.2M
[OK] InnoDB log waits: 0
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Reduce your overall MySQL memory footprint for system stability
Enable the slow query log to troubleshoot bad queries
Your applications are not closing MySQL connections properly
Variables to adjust:
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
thread_cache_size (> 16)
innodb_buffer_pool_size (>= 479M)
Muchas gracias. |