Hard disk space used by MYSQL to query database table indexes _ MySQL

The hard disk space occupied by MYSQL to query database table indexes is bitsCN.com.

Query Database usage

Select concat (ROUND (SUM (index_length)/(1024*1024), 2), 'mb ')
AS 'total Index size'
, CONCAT (ROUND (SUM (data_length)/(1024*1024), 2), 'mb') AS 'total Data size'
FROM information_schema.TABLES
Where table_schema like 'edb _ a % ';

Query table occupation

Select concat (table_schema, '.', table_name) AS 'table name ',
CONCAT (ROUND (table_rows/Rows), 'M') AS 'number of Rows ',
CONCAT (ROUND (data_length/(1024*1024*1024), 2), 'g') AS 'data size ',
CONCAT (ROUND (index_length/(1024*1024*1024), 2), 'g') AS 'index size ',
CONCAT (ROUND (data_length + index_length)/(1024*1024*1024), 2), 'g ')
AS 'total' FROM information_schema.TABLES
WHERE table_schema LIKE 'edb _ a % ';

BitsCN.com