Everytime you do optimize MySQL, by using mysqlcheck -A -o or using ./mysql_optimize from here. You may see the output Table does not support optimize, doing recreate + analyze instead. It is because the table that you are using is InnoDB. You can optimize the InnoDB tables by using this. ALTER TABLE table.name ENGINE=’InnoDB’;
Tag Archives: defrag
Optimize only fragmented tables in MySQL
Normally I use myqlcheck -A –optimize to optimize my MySQL database tables. But this will load your whole database and use more time than optimize only fragment tables. I always use the MySQLTuner 1.1.1 – Major Hayden to check and optimize my database, and I found a lot of fragmented tables in my database. I Continue reading “Optimize only fragmented tables in MySQL”
MYSQL PERFORMANCE TUNING PRIMER and MySQLTuner 1.1.1
[root@server src]# ./tuning-primer.sh — MYSQL PERFORMANCE TUNING PRIMER — – By: Matthew Montgomery – MySQL Version 5.0.88-community-log i686 Uptime = 22 days 18 hrs 12 min 36 sec Avg. qps = 14 Total Questions = 28279137 Threads Connected = 4