Mysql查询数据库表大小

ゝ一世哀愁。 2023-06-11 09:25 217阅读 0赞

查询数据库及索引大小

  1. select concat(round(sum(DATA_LENGTH/1024/1024),3),"MB") as data_size, concat(round(sum(MAX_DATA_LENGTH/1024/1024),3),"MB") as max_data_size,concat(round(sum(INDEX_LENGTH/1024/1024),3),"MB") as index_size,concat(round(sum(DATA_FREE/1024/1024),3),"MB") as data_free from tables where table_schema="yxq";

20191030094139515.png

查询指定数据库各表所占内存

  1. SELECT TABLE_NAME,DATA_LENGTH+INDEX_LENGTH,TABLE_ROWS,concat(round((DATA_LENGTH+INDEX_LENGTH)/1024/1024,2), 'MB') as data
  3. FROM information_schema.tables WHERE TABLE_SCHEMA='yxq' ORDER BY DATA_LENGTH+INDEX_LENGTH desc;

20191030094324511.png

发表评论

表情：
评论列表 （有 0 条评论，217人围观）

还没有评论，来说两句吧...

相关阅读