Mysql查询数据库表大小

最新推荐文章于 2024-07-22 03:04:41 发布

aisinilehehe

最新推荐文章于 2024-07-22 03:04:41 发布

阅读量250

点赞数

分类专栏： MySQL 文章标签： MySQL

本文链接：https://blog.csdn.net/liu911025/article/details/102812679

版权

MySQL 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

查询数据库及索引大小

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";

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

SELECT TABLE_NAME,DATA_LENGTH+INDEX_LENGTH,TABLE_ROWS,concat(round((DATA_LENGTH+INDEX_LENGTH)/1024/1024,2), 'MB') as data

FROM information_schema.tables WHERE TABLE_SCHEMA='yxq' ORDER BY DATA_LENGTH+INDEX_LENGTH desc;