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

View the usage of each library

Select

Table_schema as' database'

Sum (table_rows) as' number of records'

Sum (truncate (data_length/1024/1024, 2)) as' data capacity (MB)'

Sum (truncate (index_length/1024/1024, 2)) as' Index capacity (MB)'

From information_schema.tables

Group by table_schema

Order by sum (data_length) desc, sum (index_length) desc

View the usage of each table

Select

Table_schema as' database'

Table_name as' table name'

Table_rows as' number of records'

Truncate (data_length/1024/1024, 2) as' data capacity (MB)'

Truncate (index_length/1024/1024, 2) as' Index capacity (MB)'

From information_schema.tables

Order by data_length desc, index_length desc

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.