Tras muchas modificaciones al final consegui tener el MySQLTuner asi:
>> MySQLTuner 1.2.0 - Major Hayden <
[email protected]>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.61-log
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 3M (Tables: 280)
[--] Data in InnoDB tables: 479M (Tables: 2477)
[--] Data in MEMORY tables: 0B (Tables: 119)
[!!] Total fragmented tables: 2482
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 1h 40m 27s (60K q [10.054 qps], 1K conn, TX: 89M, RX: 27M)
[--] Reads / Writes: 86% / 14%
[--] Total buffers: 555.0M global + 14.2M per thread (40 max threads)
[OK] Maximum possible memory usage: 1.1G (54% of installed RAM)
[OK] Slow queries: 0% (1/60K)
[OK] Highest usage of available connections: 10% (4/40)
[OK] Key buffer size / total MyISAM indexes: 6.0M/3.5M
[OK] Key buffer hit rate: 99.1% (7K cached / 63 reads)
[OK] Query cache efficiency: 84.1% (44K cached / 53K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 2K sorts)
[OK] Temporary tables created on disk: 18% (669 on disk / 3K total)
[OK] Thread cache hit rate: 99% (4 created / 1K connections)
[OK] Table cache hit rate: 23% (2K open / 8K opened)
[OK] Open file limit used: 6% (284/4K)
[OK] Table locks acquired immediately: 100% (18K immediate / 18K locks)
[OK] InnoDB data size / buffer pool: 479.3M/500.0M
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Tambien he bajado la memoria cache del ACP a 256mb ya que solo utilizaba 20mb de los 500 que le reserve.
Asi ha quedado el my.cnf
[mysqld]
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
innodb_buffer_pool_size=500m
innodb_additional_mem_pool_size=500K
innodb_log_buffer_size=500K
innodb_thread_concurrency=2
### query-cache settings ###
query_cache_type=1
query_cache_size=16m
query_cache_limit=256m
log_slow_queries = 1
slow_query_log_file=/var/log/mysql.slow-queries.log
# key_buffer_size is important for MyISAM tables.
key_buffer_size=8M
key_buffer=6M
join_buffer_size=4M
thread_cache_size=8
table_cache=2048
max_allowed_packet=6M
sort_buffer_size=4m
read_buffer_size=4m
read_rnd_buffer_size=2m
myisam_sort_buffer_size=6m
tmp_table_size=256m
max_connections=40
wait_timeout=300
max_heap_table_size=32m
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
innodb_buffer_pool_size=2M
innodb_additional_mem_pool_size=500K
innodb_log_buffer_size=500K
innodb_thread_concurrency=2
Si algien ve algo que me pueda mejorar, lo agradeceria, por que aunque me dice que la memoria maxima usada seria del 1.1Gb sigo teniendo alertas por exceso de memoria. 1.8Gb sobre 2gb.