optimize table – Justin.my

Table does not support optimize, doing recreate + analyze instead

Justin SooPublished September 12, 2010Last updated December 1, 20101 minute read

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’;

MYSQL PERFORMANCE TUNING PRIMER and MySQLTuner 1.1.1

Justin SooPublished April 22, 2010Last updated December 1, 20106 minutes read

[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