MySQL 5.7 使用sys.format_bytes()特性查询库，表大小

MySQL 5.7 使用sys.format_bytes()特性查询

-- MySQL version 5.7.31
SELECT VERSION();

-- 查询所有库所有表的大小
SELECT TABLE_SCHEMA AS 'database_name', table_name, sys.format_bytes(data_length)
FROM information_schema.`TABLES`;

-- 查询指定库所有表的大小，例如：mysql
SELECT TABLE_SCHEMA, table_name, sys.format_bytes(data_length)
FROM information_schema.`TABLES`
WHERE TABLE_SCHEMA IN ('mysql');

-- 查询指定库的大小，例如：mysql
SELECT TABLE_SCHEMA AS 'database_name', sys.format_bytes(SUM(data_length))
FROM information_schema.`TABLES`
WHERE TABLE_SCHEMA IN ('mysql');

-- 查询每个库的大小
SELECT TABLE_SCHEMA AS 'database_name', sys.format_bytes(SUM(data_length))
FROM information_schema.`TABLES`
GROUP BY TABLE_SCHEMA;