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

Editor to share with you how long it usually takes to update the mysql index. I hope you will gain a lot after reading this article. Let's discuss it together.

The establishment of MySQL index is very important for the efficient operation of MySQL, and the index can greatly improve the retrieval speed of MySQL.

For example, if the properly designed MySQL that uses the index is a Lamborghini, then the MySQL without the design and use of the index is a human tricycle.

Indexes are divided into single-column indexes and combined indexes. A single-column index, that is, an index contains only a single column, and a table can have multiple single-column indexes, but this is not a combined index. A composite index, that is, an index contains multiple columns.

When creating an index, you need to make sure that the index is the condition that is applied to the SQL query statement (usually as a condition of the WHERE clause).

In fact, an index is also a table that holds the primary key and index fields and points to the records of the entity table.

It took 7 minutes for 32 cores, more than 30 gigabytes of memory, and 10 million of entries to build nonclustered indexes in time.

It is estimated that it will take more than 70 minutes for 100 million data.

The clustered index takes longer. This requires index sorting and building a branch index compound B-tree.

In general, massive data is not as good as newly established tables, indexes, and then batch-by-batch import of data.

Poor machines, 100 million data indexing is basically a crash or zombie state.

Can only wait slowly, not for a day, on the above method.

Indexes have a great relationship with types. Generally, fixed-length fields are simpler than variable-length fields, with less IO consumption and time saving. the longer the composite index is, the more complex it is, followed by a table with multiple indexes. This situation will lead to a variety of storage index structures, which will take more time.

How many data pages, how many files, and how many slots per page in the table will affect the time.

After reading this article, I believe you have a certain understanding of how long it will take to update the mysql index. If you want to know more about it, welcome to follow the industry information channel. Thank you for your reading!

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.