iTechTag ^beta..

查看MYSQL表占用空间状态

阅读次数:49 | 订阅者:IceskYsl | 来源:IceskYsl@1sters! | 文章作者: iceskysl | 发表时间: 2008-08-19

比如需要查询库占用的空间和索引占用的空间：

查整个库的状态：
select concat(truncate(sum(data_length)/1024/1024,2),'MB') as data_size,
concat(truncate(sum(max_data_length)/1024/1024,2),'MB') as max_data_size,
concat(truncate(sum(data_free)/1024/1024,2),'MB') as data_free,
concat(truncate(sum(index_length)/1024/1024,2),'MB') as index_size
from information_schema.tables where TABLE_SCHEMA = 'databasename';

查单表：
select concat(truncate(sum(data_length)/1024/1024,2),'MB') as data_size,
concat(truncate(sum(max_data_length)/1024/1024,2),'MB') as max_data_size,
concat(truncate(sum(data_free)/1024/1024,2),'MB') as data_free,
concat(truncate(sum(index_length)/1024/1024,2),'MB') as index_size
from information_schema.tables where TABLE_NAME = 'tablename';阅读全文

技能云友情提示您: 如果您对本文观点感兴趣,欢迎到原文出处讨论，谢谢！