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)