Follow the step-by-step learning method of MySQL optimization using the heat-resistance protocol.

Source: Internet
Author: User

In the second set

1. Show status like 'com % 'is equivalent to show status session like 'com %' for a hundred years -- display the current console status

Show global status like 'com % '-- displays the number of times the database has been started and queried.

Show session status like 'com _ select ';

Show status like 'uptime' -- how long it has been started
Show status like 'connections' -- number of connections

Slow_queries slow Query Count (default value: 10)

For the MyISAM database, it must be cleaned regularly.
Optimize table name. Otherwise, the deletion record is not cleared.
Order by null disable sorting
Use join instead of subquery
In finance, you can use a certain number of points to place decimal data. Do not use float for a period of time because float will lose data. Such as float (10, 5 ),
In the date type, numeric values are used instead of datastmp.

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: 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.