SELECT table_schema "数据库名称",
sum((data_length+index_length)/1024/1024/1024) AS "数据库大小(GB)"
FROM information_schema.tables
group by table_schema;
SELECT table_schema "数据库名称",
sum((data_length+index_length)/1024/1024/1024) AS "数据库大小(GB)"
FROM information_schema.tables
group by table_schema;
本文标题:MYSQL查看数据库磁盘占用命令
本文链接:https://www.haomeiwen.com/subject/ijvkodtx.html
网友评论