Ver Mensaje Individual
  #1 (permalink)  
Antiguo 23/08/2009, 14:53
Chismopoly
 
Fecha de Ingreso: junio-2008
Mensajes: 105
Antigüedad: 16 años, 5 meses
Puntos: 1
Análisis de MySQLTuner script

Bueno aquí le dejo el resultado de el script MySQLTuner. bien lo que esta pasando es que no entiendo la mayoría de cosas para poder optimizar my.cnf si alguien me puede ayudar gracias


Código:
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.45-log
[!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive +BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 72M (Tables: 70)
[!!] BDB is enabled but isn't being used
[!!] Total fragmented tables: 1

-------- Performance Metrics -------------------------------------------------
[--] Up for: 19h 2m 11s (2M q [35.312 qps], 120K conn, TX: 2B, RX: 324M)
[--] Reads / Writes: 97% / 3%
[--] Total buffers: 274.0M global + 80.4M per thread (2000 max threads)
[!!] Allocating > 2GB RAM on 32-bit systems can cause system instability
[!!] Maximum possible memory usage: 157.4G (3987% of installed RAM)
[OK] Slow queries: 2% (50K/2M)
[OK] Highest usage of available connections: 1% (21/2000)
[OK] Key buffer size / total MyISAM indexes: 184.0M/34.7M
[OK] Key buffer hit rate: 99.8% (893M cached / 1M reads)
[OK] Query cache efficiency: 64.2% (1M cached / 2M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 290K sorts)
[!!] Temporary tables created on disk: 45% (129K on disk / 284K total)
[OK] Thread cache hit rate: 99% (21 created / 120K connections)
[!!] Table cache hit rate: 0% (39 open / 14K opened)
[OK] Open file limit used: 0% (69/10K)
[OK] Table locks acquired immediately: 99% (1M immediate / 1M locks)

-------- Recommendations -----------------------------------------------------
General recommendations:
    Add skip-bdb to MySQL configuration to disable BDB
    Run OPTIMIZE TABLE to defragment tables for better performance
    MySQL started within last 24 hours - recommendations may be inaccurate
    When making adjustments, make tmp_table_size/max_heap_table_size equal
    Reduce your SELECT DISTINCT queries without LIMIT clauses
    Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    tmp_table_size (> 32M)
    max_heap_table_size (> 16M)
    table_cache (> 2024)