Necesito ayuda para optimizar mi servidor

[kepardox]

Datacenter1:

Ya pasaron más de 48 horas desde los últimos toques. A continuación traigo los resultados.

./mysqltuner.pl

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

-------- Performance Metrics -------------------------------------------------
[--] Up for: 2d 2h 44m 3s (10M q [59.243 qps], 468K conn, TX: 1B, RX: 1B)
[--] Reads / Writes: 88% / 12%
[--] Total buffers: 122.0M global + 36.4M per thread (500 max threads)
[!!] Allocating > 2GB RAM on 32-bit systems can cause system instability
[!!] Maximum possible memory usage: 17.9G (226% of installed RAM)
[OK] Slow queries: 0% (2/10M)
[OK] Highest usage of available connections: 4% (23/500)
[OK] Key buffer size / total MyISAM indexes: 32.0M/14.2M
[OK] Key buffer hit rate: 99.9% (909M cached / 1M reads)
[OK] Query cache efficiency: 82.2% (7M cached / 9M selects)
[!!] Query cache prunes per day: 30181
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 387K sorts)
[!!] Temporary tables created on disk: 49% (213K on disk / 429K total)
[OK] Thread cache hit rate: 99% (23 created / 468K connections)
[OK] Table cache hit rate: 34% (88 open / 256 opened)
[OK] Open file limit used: 3% (141/4K)
[OK] Table locks acquired immediately: 99% (1M immediate / 1M locks)
[OK] InnoDB data size / buffer pool: 112.0K/8.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
query_cache_size (> 64M)
tmp_table_size (> 64M)
max_heap_table_size (> 16M)