Código PHP:
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.67-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: 124M (Tables: 731)
[--] Data in MEMORY tables: 1M (Tables: 4)
[!!] Total fragmented tables: 18
-------- Performance Metrics -------------------------------------------------
[--] Up for: 27m 49s (276K q [165.756 qps], 36K conn, TX: 235M, RX: 57M)
[--] Reads / Writes: 73% / 27%
[--] Total buffers: 410.0M global + 11.1M per thread (300 max threads)
[!!] Allocating > 2GB RAM on 32-bit systems can cause system instability
[!!] Maximum possible memory usage: 3.7G (124% of installed RAM)
[OK] Slow queries: 5% (15K/276K)
[OK] Highest usage of available connections: 10% (31/300)
[OK] Key buffer size / total MyISAM indexes: 256.0M/35.2M
[OK] Key buffer hit rate: 100.0% (4M cached / 1K reads)
[OK] Query cache efficiency: 61.6% (100K cached / 162K selects)
[OK] Query cache prunes per day: 0
[!!] Sorts requiring temporary tables: 17% (1K temp sorts / 10K sorts)
[OK] Temporary tables created on disk: 7% (2K on disk / 37K total)
[OK] Thread cache hit rate: 99% (31 created / 36K connections)
[OK] Table cache hit rate: 99% (777 open / 784 opened)
[OK] Open file limit used: 64% (1K/2K)
[OK] Table locks acquired immediately: 98% (144K immediate / 146K locks)
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Variables to adjust:
*** MySQLs maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
sort_buffer_size (> 4M)
read_rnd_buffer_size (> 4M)
yo solo tengo instalados 3gb, pero me aparece que el maximo permitido es 3.7, en que parte puedo modifcar o editar ese valor de 3.7gb y en cuanto me recomiendan dejarlo. espero me puedan ayudar. saludos
