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”
Tag Archives: Tuning Primer
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