SELECT (sum(DATA_LENGTH)+sum(INDEX_LENGTH))/1048576 AS size_M FROM information_schema.TABLES where TABLE_SCHEMA='db_name'
查询数据库文件大小M/G
最新推荐文章于 2023-10-19 13:42:13 发布
SELECT (sum(DATA_LENGTH)+sum(INDEX_LENGTH))/1048576 AS size_M FROM information_schema.TABLES where TABLE_SCHEMA='db_name'