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’;
Some people search for:Table does [...]
- Like this:
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 did try [...]
- Like this:
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 |
| [...]
- Like this:
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
Some people search for:directadmin update phpdirectadmin update phpmyadmindirectadmin updateupdate phpmyadmin directadmindirectadmin phpmyadmin updatedirectadmin /build versionsdirectadmin update mysqldirectadmin update pcre to latest versionhow to update phpmyadmin directadmindirectadmin innodbhow to update directadminhow update phpmyadmin directadminhow to directadmin custombuild 1 2phpmyadmin directadmin updatedirectadmin phpmyadmin [...]
- Like this:
[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
Some people search for:MYSQL PERFORMANCE TUNING PRIMERmysqltuner windowsConfigured Max Per-thread Buffersmysqltuner vstuning primermysqlwindowstuner-primer shmysql tuner windowsmysql tuning primer windowsmysqltuner for windowsmysqltuner tmp_table_sizemysqltuner 1 [...]
- Like this:
Search
Translate






