查看数据文件夹所在目录:
show global variables like 'datadir%';
查看记录总数及所占内存:
table_schema为数据库名
table_rows为表的总记录数
data_length为记录所占内存长度,单位为MB
index_length为索引所占内存长度,单位为MB
select table_schema,
sum(table_rows) table_rows,
sum(truncate(data_length / 1024 / 1024, 2)) data_length,
sum(truncate(index_length / 1024 / 1024, 2)) index_length
from information_schema.tables
group by table_schema
order by sum(data_length) desc, sum(index_length) desc;