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/