查询数据库占用磁盘大小

SELECT table_schema "DB Name",
Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
FROM information_schema.tables
GROUP BY table_schema;

 

 

ref: stackoverflow

posted @ 2014-05-15 08:42  star4knight  阅读(156)  评论(0编辑  收藏  举报