01 November 2015

MySQL查看表大小

方法一:

在MySQL的data目录下查看,前提是my.cnf中配置了innodb_file_per_table

方法二:

在MySQL查询中执行以下操作:

select table_name,concat(round(data_length/1000/1000/1000,2),'GB') as data_length_GB 
from information_schema.tables ORDER BY data_length_GB;

Tags:
0 comments