mysql 查看数据库索引和数据大小

最新推荐文章于 2024-01-07 15:45:48 发布

annan211

最新推荐文章于 2024-01-07 15:45:48 发布

阅读量152

点赞数

分类专栏： mysql 文章标签： mysql 索引大小数据大小

本文链接：https://blog.csdn.net/annan211/article/details/84738764

版权

mysql 专栏收录该内容

48 篇文章 0 订阅

订阅专栏

查看数据概况

 select * from information_schema.TABLES 
  where information_schema.TABLES.TABLE_SCHEMA='business_shop2'
  and information_schema.TABLES.TABLE_NAME='ls_prod'

请尊重知识，请尊重原创更多资料参考请见 http://www.cezuwang.com/listFilm?page=1&areaId=906&filmTypeId=1
查看索引大小

 select CONCAT(ROUND(SUM(t.index_length)/(1024*1024), 2), ' MB') AS 'Total Index Size' from (
 select index_length from information_schema.TABLES 
  where information_schema.TABLES.TABLE_SCHEMA='business_shop2'
  and information_schema.TABLES.TABLE_NAME='ls_prod' ) as t

查看数据大小

   select CONCAT(ROUND(SUM(t.data_length)/(1024*1024), 2), ' MB') AS 'Total data Size' from (
 select data_length from information_schema.TABLES 
  where information_schema.TABLES.TABLE_SCHEMA='business_shop2'
  and information_schema.TABLES.TABLE_NAME='ls_prod' ) as t

请尊重知识，请尊重原创更多资料参考请见 http://www.cezuwang.com/listFilm?page=1&areaId=906&filmTypeId=1