MySQL performance tuning primer script description

Source: Internet
Author: User
Tags mysql optimization tool

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/

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.