MYSQL PERFORMANCE TUNING PRIMER and MySQLTuner 1.1.1

Currently viewing the tag: "mysql"

How to create MySQL database in Directadmin

By juzhax On November 18, 2011 · 1 Comment · In Notes

How to create MySQL database in Directadmin
You have to login to your admin page from your browser, I use justin.my as example in this tutorial.
Some people search for:create databasemysql create databasedirectadmin mysqlwordpress and directAdminmysql manager cant find direct adminmysqlhow to create mysql database in directadminhow to create a blog in direct adminfind mysql port in [...]

Continue Reading →

Forbidden – You don’t have permission to access /wp-admin/post.php on this server.

By juzhax On February 22, 2011 · 1 Comment · In Linux, Notes

Forbidden – You don’t have permission to access /wp-admin/post.php on this server.
Why I cannot post my post to my WordPress ?
This is because the server installed mod_security.
Some people search for:You dont have permission to access /wp-admin/install php on this serverYou don\t have permission to access /wp-admin/post php on this serverYou don\t have permission to access [...]

Continue Reading →

Table does not support optimize, doing recreate + analyze instead

By juzhax On September 12, 2010 · 1 Comment · In Linux

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 [...]

Continue Reading →

Optimize only fragmented tables in MySQL

By juzhax On September 12, 2010 · 2 Comments · In Linux

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 [...]

Continue Reading →

[Solved]Locked table in MySQL

By juzhax On September 2, 2010 · Leave a Comment · In Linux

InnoDB Supports transactions, row-level locking, and foreign keys
MyISAM Default engine as of MySQL 3.23 with great performance

Some people search for:find locked table mysqlmysql table lock solvedPhpWind 8 0

Continue Reading →

How to view MySql running resources

By juzhax On August 28, 2010 · 1 Comment · In Linux

If your server’s mysql always in high resources or down, I suggest you use this command to trace out which database that eat up your MySql resource

/usr/bin/mysqladmin proc stat
/usr/bin/watch -n 5 ‘mysqladmin proc stat’

Every 5.0s: mysqladmin proc stat [...]

Continue Reading →

Update server with custombuild in DirectAdmin 1.36.0

By juzhax On July 15, 2010 · Leave a Comment · In Linux, Notes

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 [...]

Continue Reading →

MYSQL PERFORMANCE TUNING PRIMER and MySQLTuner 1.1.1

By juzhax On April 22, 2010 · 1 Comment · In Linux

[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 [...]

Continue Reading →