Master check and Tuning MySQL performance method (1/6)

Source: Internet
Author: User
Tags mysql client mysql tutorial

I have been using the MySQL tutorial this database tutorial software, it works relatively stable, efficient and very high. In the face of serious performance problems, there are generally several possibilities:

1, the index is not well established;
2, the SQL writing is too complex;
3, configuration error;
4, the machine is really not load;

1, the index is not built well

If you see the CPU consumed by MySQL is very large, you can use the MySQL client tool to check.

Execute on Linux

/usr/local/mysql/bin/mysql-hlocalhost-uroot-p

Enter the password, and if there is no password, you can go to the client interface without the-p parameter.

Look at the current operation

Show Full Processlist

Can run a few more times

This command sees the currently executing SQL statement, which tells you the SQL, database name, execution status, client IP, account number used, elapsed time, and so on.

In my cache back end, this most of the time is not see the display of any SQL statements, I think this is more normal. If you see a lot of SQL statements, then this MySQL will certainly have a performance problem

Home 1 2 3 4 5 6 last

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.