MYSQL PERFORMANCE TUNING PRIMER and MySQLTuner 1.1.1

Currently viewing the tag: "database"

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 →

[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 →

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 →