Shulou(Shulou.com)06/01 Report--

Let me tell you a little bit about the direction of high-performance mysql database optimization. Have you learned about similar topics before? If you are interested, let's take a look at this article. I believe it will be of some help to you after reading the optimization direction of high-performance mysql database.

The direction of database optimization: query optimization, index optimization and database table structure optimization should go hand in hand

1. Steps

(1) check whether unnecessary data is requested like the database.

Check whether the query queries unwanted records and qualify them with limit. Always take out all the columns

Always fetching out all the columns prevents the optimizer from completing optimizations such as index override scanning, and also sets the

The CVM brings additional IO, memory and CPU consumption.

Always take out all of them and list the following two classic cases:

Multiple tables are associated to fetch all columns:

Select from tablea innerjoin tableb on tablea.id=tableb.aid

You can change it to:

Select column1,column2,column3,... From tablea innerjoin tableb

On tablea.id=tableb.aid

Or:

Select tablea. From tablea innerjoin tableb on tablea.id=tableb.aid

A single table finds all the columns:

Select * from tablea

Change to:

Select column1,column2,column3,...from tablea

(2) check whether the query

What do you think of this article on the direction of high-performance mysql database optimization, and whether it has gained anything? If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.