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: optimize
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”
MySQLTuner result and Tuning Primer result
My server eat up of high CPU resource. I’ve figure out by using [root@server ~]# /usr/bin/watch -n 5 ‘mysqladmin proc stat’ and found out that these results. | 214024 | phpwind | localhost | phpwind | Query | 318 | Copying to tmp table | SELECT pt.tid,pt.fid,pt.subject,pa.attachurl FROM pw_threads pt ,pw_attachs pa,pw_forums pf where p Continue reading “MySQLTuner result and Tuning Primer result”
Update server with custombuild in DirectAdmin 1.36.0
Update server with custombuild in DirectAdmin from 1.35.1 to 1.36.0 cd /usr/local/directadmin/customebuild ./build clean ./build options ./build versions ./build update_versions
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