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

This article mainly explains "MySQL how to view table size", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let Xiaobian take you to learn "MySQL how to view table size"!

select table_name,table_size

from

(select table_name,(data_length+index_length)/1024/1024/1024 table_size

from

information_schema.tables ) t1

order by table_size

desc limit 10;

At this point, I believe that everyone has a deeper understanding of "MySQL how to view table size", so let's actually operate it! Here is the website, more related content can enter the relevant channels for inquiry, pay attention to us, continue to learn!

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.