Necesito ayuda para optimizar mi servidor

[kepardox]

El servidor está funcionando muy bien, el consumo de RAM disminuyó muchísimo, y el server load se mantiene estable.


A continuación los resultados de lo que me mysqltuner:

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.81-community
[!!] 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: 51M (Tables: 66)
[--] Data in InnoDB tables: 112K (Tables: 7)
[!!] Total fragmented tables: 20

-------- Performance Metrics -------------------------------------------------
[--] Up for: 5d 21h 21m 17s (31M q [62.874 qps], 1M conn, TX: 1B, RX: 3B)
[--] Reads / Writes: 89% / 11%
[--] Total buffers: 134.0M global + 2.7M per thread (700 max threads)
[OK] Maximum possible memory usage: 2.0G (24% of installed RAM)
[OK] Slow queries: 0% (0/31M)
[OK] Highest usage of available connections: 4% (31/700)
[OK] Key buffer size / total MyISAM indexes: 8.0M/12.0M
[OK] Key buffer hit rate: 99.9% (3B cached / 3M reads)
[OK] Query cache efficiency: 81.9% (22M cached / 27M selects)
[!!] Query cache prunes per day: 13018
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 1M sorts)
[!!] Temporary tables created on disk: 47% (727K on disk / 1M total)
[!!] Thread cache is disabled
[OK] Table cache hit rate: 20% (64 open / 308 opened)
[OK] Open file limit used: 3% (106/3K)
[OK] Table locks acquired immediately: 99% (5M immediate / 5M locks)
[OK] InnoDB data size / buffer pool: 112.0K/8.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
Enable the slow query log to troubleshoot bad queries
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Set thread_cache_size to 4 as a starting value
Variables to adjust:
query_cache_size (> 100M)
tmp_table_size (> 32M)
max_heap_table_size (> 16M)
thread_cache_size (start at 4)