How to check the database table capacity through MySQL-Mysql Tutorial-php.cn

How to check the database table capacity through MySQL

jacklove

Release： 2018-06-09 09:15:25

Original

2083 people have browsed it

This article introduces the MySQL command statement to check the capacity of the database table, and provides complete query statements and examples for everyone to learn and use.

1. Check the capacity of all databases

select table_schema as &#39;数据库&#39;,sum(table_rows) as &#39;记录数&#39;,sum(truncate(data_length/1024/1024, 2)) as &#39;数据容量(MB)&#39;,sum(truncate(index_length/1024/1024, 2)) as &#39;索引容量(MB)&#39;from information_schema.tablesgroup by table_schemaorder by sum(data_length) desc, sum(index_length) desc;

Copy after login

2. Check the capacity of each table in all databases

select table_schema as &#39;数据库&#39;,
table_name as &#39;表名&#39;,
table_rows as &#39;记录数&#39;,truncate(data_length/1024/1024, 2) as &#39;数据容量(MB)&#39;,truncate(index_length/1024/1024, 2) as &#39;索引容量(MB)&#39;from information_schema.tablesorder by data_length desc, index_length desc;

Copy after login

3. Check the capacity of the specified database

Example : Check the capacity of the mysql library

select table_schema as &#39;数据库&#39;,sum(table_rows) as &#39;记录数&#39;,sum(truncate(data_length/1024/1024, 2)) as &#39;数据容量(MB)&#39;,sum(truncate(index_length/1024/1024, 2)) as &#39;索引容量(MB)&#39;from information_schema.tableswhere table_schema=&#39;mysql&#39;;

Copy after login

How to check the database table capacity through MySQL

4. Check the capacity of each table in the specified database

Example: Check the capacity of each table of the mysql library

select table_schema as &#39;数据库&#39;,
table_name as &#39;表名&#39;,
table_rows as &#39;记录数&#39;,truncate(data_length/1024/1024, 2) as &#39;数据容量(MB)&#39;,truncate(index_length/1024/1024, 2) as &#39;索引容量(MB)&#39;from information_schema.tableswhere table_schema=&#39;mysql&#39;order by data_length desc, index_length desc;

Copy after login

How to check the database table capacity through MySQL

This article explains how to check the database table capacity through MySQL. For more related content, please pay attention to the php Chinese website.

Related recommendations:

Explanation on how to use php str_getcsv to parse a string into an array

Optimize the client Call the server interface to reduce the request data capacity

mysql order by rand() efficiency optimization method

The above is the detailed content of How to check the database table capacity through MySQL. For more information, please follow other related articles on the PHP Chinese website!