SELECT sum(TABLE_ROWS),sum(DATA_LENGTH),sum(INDEX_LENGTH),sum(DATA_LENGTH)+sum(INDEX_LENGTH) FROM information_schema.TABLES where TABLE_SCHEMA='table_name';
Mysql查看数据库总行数 占用硬盘容量
最新推荐文章于 2024-03-12 14:11:06 发布
SELECT sum(TABLE_ROWS),sum(DATA_LENGTH),sum(INDEX_LENGTH),sum(DATA_LENGTH)+sum(INDEX_LENGTH) FROM information_schema.TABLES where TABLE_SCHEMA='table_name';