Cita:
Iniciado por skamasle 
NO tienes que esperar 24 horas, con reiniciar mysql es suficiente, se recomienda esperar 24 / 48 horas para pasar el mysqltunner y similares por que se recompila más información, pero los valores se aplican de inmediato.
Tremendo fallo de novato, cuando puse el my.cnf no me di cuenta que estaba modificando todo despues de [mysqld_safe] por lo que no conseguia que funcionara nada de lo que estaba intentando mejorar. ahora ya e consultado en phpmyadmin y
Variable_name Value
query_cache_size 100663296
>> 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
[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: 51s (406 q [7.961 qps], 25 conn, TX: 481K, RX: 139K)
[--] Reads / Writes: 89% / 11%
[--] Total buffers: 1.6G global + 12.2M per thread (400 max threads)
[!!] Maximum possible memory usage: 6.4G (319% of installed RAM)
[OK] Slow queries: 0% (0/406)
[OK] Highest usage of available connections: 1% (4/400)
[OK] Key buffer size / total MyISAM indexes: 512.0M/3.5M
[!!] Key buffer hit rate: 60.0% (10 cached / 4 reads)
[OK] Query cache efficiency: 43.5% (130 cached / 299 selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 50 sorts)
[!!] Temporary tables created on disk: 27% (20 on disk / 72 total)
[OK] Thread cache hit rate: 84% (4 created / 25 connections)
[OK] Table cache hit rate: 93% (107 open / 114 opened)
[OK] Open file limit used: 0% (22/2K)
[OK] Table locks acquired immediately: 100% (364 immediate / 364 locks)
[OK] InnoDB data size / buffer pool: 479.3M/1.0G
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Reduce your overall MySQL memory footprint for system stability
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
Variables to adjust:
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
tmp_table_size (> 128M)
max_heap_table_size (> 16M)
Despues de estos avisos:
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
He bajado a 64m query_cache_size (lo tenia en 96m)
Variable_name Value
query_cache_size 67108864
por cierto el MySQLTuner me esta pidiendo que siga ampliando query_cache_limit voy por 24m ¿tengo que seguir subiendo?¿hasta cuanto?
Tengo 2Gb de memoria RAM y 2Gb en disco ¿que tamaño de cache pondrías?
Muchas gracias por tu paciencia