作用：
统计mysql数据库中myisam表的总大小，总数据大小，索引大小。
- SELECT 'Total MyISAM Size' AS title, \
- ROUND(SUM((data_length+index_length)/1024/1024)) AS total_mb, \
- ROUND(SUM(data_length/1024/1024)) AS data_mb, \
- ROUND(SUM(index_length/1024/1024)) AS index_mb \
- FROM INFORMATION_SCHEMA.TABLES WHERE engine='MyISAM';
阅读(844) | 评论(0) | 转发(0) |
