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

This article mainly shows you "mysql how to check the size of table fragments", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "mysql how to check the size of table fragments" this article.

View table fragment size

(1) View the fragment size of a table

Mysql > SHOW TABLE STATUS LIKE 'table name'; 1

The value of the 'Data_free' column in the result is the fragment size.

(2) list all tables that have been fragmented

Mysql > select table_schema db, table_name, data_free, engine from information_schema.tables where table_schema notin ('information_schema',' mysql') and data_free > 0

1 2 3 recommendations

The defragmentation operation will temporarily lock the table. The larger the amount of data, the longer the time. You can make a script that is executed regularly during the access trough. For example, check the DATA_FREE field in the early hours of every Wednesday morning, and clean it up if it is greater than the warning value you think.

The above is all the contents of the article "how to check the size of table fragments in mysql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.