Mysql Optimization - table_open_cahce, query_cache

view story

http://serverfault.com – I have already optimize many times my Mysql server but now I want to have your advices. mysqltuner: -------- General Statistics -------------------------------------------------- [--] Skipped version check for MySQLTuner script [OK] Currently running supported MySQL version 5.1.52-log [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 26G (Tables: 36) [--] Data in InnoDB tables: 221M (Tables: 35) [!!] Total fragmented tables: 41 ---- (HowTos)