How to view index page fragments in Mysql

This article introduces you how to view the index page fragments in Mysql, the content is very detailed, interested friends can refer to, hope to be helpful to you.

Query index page fragments:

SHOW TABLE STATUS LIKE 'table name'; / / fragmentation occurs when the Data_free column value is greater than 0 (as long as the data is deleted, as long as the index is established)

Optimization table:

OPTIMIZE TABLE table name

Index conditions (or):

Large amount of table data (if the amount of data is small, the effect of indexing is not obvious, but a waste of physical space, increasing the difficulty of maintaining the table, etc.)

Primary key column / foreign key column (accelerated join) / commonly used search column

View the code:

Show variables like 'character_set%'

Set the coding of the returned result:

SET character_set_results= utf-8

On how to view the index page fragments in Mysql to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.