Tema:
Comparto el link a una noticia aparecida en Maestros del Web sobre MySQLTuner una herramienta que luego de ejecutarla nos presenta recomendaciones para optimizar la configuración de nuestro Servidor de BD MySQL.
El enlace a la noticia es el siguiente:
El resultado que me dió en un servidor de prueba es el siguiente:
[root@test procesos]# wget http://mysqltuner.com/mysqltuner.pl
--11:11:01-- http://mysqltuner.com/mysqltuner.pl
Resolving mysqltuner.com... 209.20.89.226
Connecting to mysqltuner.com|209.20.89.226|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 38688 (38K) [text/plain]
Saving to: `mysqltuner.pl'
100%[================================>] 38,688 42.4K/s in 0.9s
11:11:03 (42.4 KB/s) - `mysqltuner.pl' saved [38688/38688]
[root@test procesos]# chmod 700 mysqltuner.pl
[root@test procesos]# ./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
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password:
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.27-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: 71M (Tables: 22)
[--] Data in InnoDB tables: 291M (Tables: 12)
[OK] Total fragmented tables: 0
-------- Performance Metrics -------------------------------------------------
[--] Up for: 1m 8s (16 q [0.235 qps], 11 conn, TX: 15K, RX: 1K)
[--] Reads / Writes: 100% / 0%
[--] Total buffers: 44.0M global + 2.7M per thread (100 max threads)
[OK] Maximum possible memory usage: 312.7M (15% of installed RAM)
[OK] Slow queries: 0% (0/16)
[OK] Highest usage of available connections: 5% (5/100)
[!!] Key buffer size / total MyISAM indexes: 8.0M/226.4M
[!!] Key buffer hit rate: 70.3% (64 cached / 19 reads)
[!!] Query cache efficiency: 0.0% (0 cached / 6 selects)
[OK] Query cache prunes per day: 0
[OK] Temporary tables created on disk: 0% (0 on disk / 2 total)
[!!] Thread cache is disabled
[OK] Table cache hit rate: 64% (11 open / 17 opened)
[OK] Open file limit used: 2% (23/1K)
[OK] Table locks acquired immediately: 100% (19 immediate / 19 locks)
[!!] Connections aborted: 18%
[!!] InnoDB data size / buffer pool: 291.9M/8.0M
-------- Recommendations -----------------------------------------------------
General recommendations:
MySQL started within last 24 hours - recommendations may be inaccurate
Set thread_cache_size to 4 as a starting value
Your applications are not closing MySQL connections properly
Variables to adjust:
key_buffer_size (> 226.4M)
query_cache_limit (> 1M, or use smaller result sets)
thread_cache_size (start at 4)
innodb_buffer_pool_size (>= 291M)
Igual voy a tener que esperar un poco más para correr nuevamente el test ya que este servidor no lleva ni 24 h arriba, sin embargo si me ha dado la pista para comunicarle al desarrollador de la aplicación web no esta cerrando bien las conexiones.
Comentarios
Para los DBA de verdad
Para los DBA de verdad y no los aficionados como yo pueden checkar:
Hasta cuando seremos los pacíficos dueños de tanto absurdo.
User Linux: 446419
"Transporta un puñado de tierra todos los días y construirás una montaña" - Confucio
floss.iknaxio.net