搜索
-
查看Mysql数据库有多大
日期:2011-11-29 | 分类:Mysql数据库
版权声明:转载时请以超链接形式标明文章原始出处和作者信息及本声明
http://www.ff-bb.cn/logs/177591920.html
方法一:SELECT table_schema AS 'DBname',
Round( Sum( data_length + index_length ) / 1024 / 1024, 3 ) AS 'Db Size (MB)',
Round( Sum( data_free ) / 1024 / 1024, 3 ) AS 'Free Space (MB)'
FROM information_schema.tables GROUP BY table_schema ;方法二:
./mysql -uroot -p'passwd' -D dbname -e "show table status\G"| egrep "(Index|Data)_length" | awk 'BEGIN { rsum = 0 } { rsum += $2 } END { print rsum/1024/1024 "MB" }'
收藏到:Del.icio.us







