Shulou(Shulou.com)05/31 Report--

This article mainly introduces "what is the mysql optimization method". In the daily operation, I believe many people have doubts about what the mysql optimization method is. The editor consulted all kinds of data and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubts about "what is the mysql optimization method?" Next, please follow the editor to study!

Mysql data reaches quantity level

First of all, you can consider the business level optimization, that is, vertical table.

Vertical subtable is a table with a large amount of data, which can be divided into multiple tables according to the properties of a field or the frequency of use.

If there are multiple business types, each business type is put into a different table, table1,table2,table3.

If you don't need to use all the data in your daily business, you can break down the table by time, such as the monthly table. Only one month's record is kept in each table.

two。 Architectural optimization, that is, horizontal sub-table.

Horizontal sub-table is to put data rows into multiple separate tables according to the values of one or more columns of data, which does not make business sense here.

For example, according to the id sub-table, the data with 0-9 at the end is inserted into 10 tables.

You may have to ask, this looks no different from the vertical table just mentioned. However, the difference of whether it has business significance or not is broken down according to the value of the field.

In fact, horizontal score is the most popular way to achieve it, which is achieved through horizontal sub-library. That is, the 10 tables just mentioned are distributed on 10 mysql databases. In this way, high performance can be achieved by integrating multiple low-configuration hosts.

If you want to insert fast, there are fewer indexes, and if the query is fast, build the appropriate index, nothing special.

At this point, the study of "what is the mysql optimization method" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.