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

This article introduces you how to mysql statistics and table size, the content is very detailed, interested friends can refer to, I hope you can help.

View the size of the tables in a database and display them upside down.

SELECT TABLE_NAME, (DATA_LENGTH+INDEX_LENGTH) / 1024 as tt,TABLE_ROWS FROM TABLES WHERE TABLE_SCHEMA='test' and TABLE_ROWS > 0 order by tt desc; so much about how to share the statistics and table size in mysql. I hope the above content can be helpful to you and learn more. If you think the article is good, you can share it for more people to see.

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.