请教一下 MySQL里怎么看某个库的大小？

yueliangdao0608

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 = 'YouTableName';

[ 本帖最后由 yueliangdao0608 于 2008-7-9 17:36 编辑 ]

yueliangdao0608

忘了加information_schema库名了。已经修改

yueliangdao0608

你替换成你的库名就可以了。

yueliangdao0608

Yeah,the version must be higher than 5.