MYSQL table 용량 쿼리
1. table 용량 체크 쿼리
|
1 2 3 4 |
use xinet go select top 10 table_name = convert(varchar(30), min(o.name)) , table_size = convert(int, ltrim(str(sum(reserved) * 8.192 / 1024., 15, 0))), UNIT = 'MB' from sysindexes i inner join sysobjects o on (o.id = i.id) where i.indid in (0, 1, 255) and o.xtype = 'U' group by i.id order by 2 desc |