MySQL performance tuning primer script description

MySQL performance tuning primer script is a simple and easy-to-use mysql optimization tool. In fact, it is a shell script.

Download:

$ Wget http://www.day32.com/MySQL/tuning-primer.sh

Run

$ Sh tuning-primer.sh all

After running the command, you will be asked about the mysql user name, password, and preferably mysql. You will also be asked whether to automatically generate the. my. cnf configuration file in the home directory. Here, your mysql user name and password are generally N.

It mainly queries the variables settings and status in mysql and provides the mysql running status and suggestions based on the current system conditions, including the following checks:

Slow query

Binlog binary log

Max connections

Threads thread count

Key buffer size keyword buffer

Query cache

Sort operations sorting

Join operations multi-table join

Tmp tables temporary table

Number of open files

Table cache

Table locking

Table scans table Scan

Innodb status

Total memory used memory usage

 

This article comes from:Http://srsman.com/2009/03/mysql-performance-tuning-primer-script/