Blog Archives

Table does not support optimize, doing recreate + analyze instead

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.

Read More …




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,

Read More …




MySQLTuner result and Tuning Primer result

My server eat up of high CPU resource. I’ve figure out by using

[[email protected] ~]# /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 |
| 214028 | _wp | localhost | _wp | Query | 315 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts WHERE 1=1 AND YEAR(wp_pos
ts.post_date)=’2010′ |
| 214029 | phpwind | localhost | phpwind | Query | 318 | Locked | UPDATE LOW_PRIORITY pw_threads SET hits=hits+1 WHERE tid= ‘6424’
|
| 214030 | phpwind | localhost | phpwind | Query | 315 | 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 |
| 214031 | phpwind | localhost | phpwind | Query | 307 | Locked | UPDATE LOW_PRIORITY pw_threads SET hits=hits+1 WHERE tid= ‘92850’
|
| 214035 | phpwind | localhost | phpwind | Query | 296 | Locked | UPDATE LOW_PRIORITY pw_threads SET hits=hits+1 WHERE tid= ‘69204’
|

I’m thinking the problem is cause by Copying to tmp table.

Read More …




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

Read More …




MYSQL PERFORMANCE TUNING PRIMER and MySQLTuner 1.1.1

[[email protected] 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

Read More …




Translate

Buy me a Caffè Latte

Thank you for the Caffè Latte

2013/02/15 saw art
2013/01/25 Parul Patel
2012/11/20 Barbara Nicholas $10
2012/10/08 Amy Stockman $5
2012/07/15 siewho chang $ 50
2012/06/08 Susan Hampton $10
2012/05/11 Chris Grima $10