MySQL 查看基本信息、库和表大小，最后修改时间

1. 查看数据库表基本信息。
   select * from information_schema.TABLES where information_schema.TABLES.TABLE_SCHEMA = '数据库名' and information_schema.TABLES.TABLE_NAME = '表名';

2. 查看所有mysql数据库大小
   select TABLE_SCHEMA, concat(truncate(sum(data_length)/1024/1024,2),' MB') as data_size,
   concat(truncate(sum(index_length)/1024/1024,2),'MB') as index_size
   from information_schema.tables
   group by TABLE_SCHEMA
   order by data_length desc;

3. 查看某个库每个表的大小
   select TABLE_NAME, concat(truncate(data_length/1024/1024,2),' MB') as data_size,
   concat(truncate(index_length/1024/1024,2),' MB') as index_size
   from information_schema.tables where TABLE_SCHEMA = '库名'
   group by TABLE_NAME
   order by data_length desc;

4. 查看库最后修改时间
   select TABLE_NAME,UPDATE_TIME from information_schema.TABLES where TABLE_SCHEMA='数据库名' order by UPDATE_TIME desc limit 1;

5. 查看表最后修改时间
   select TABLE_NAME,UPDATE_TIME from information_schema.TABLES where TABLE_SCHEMA='数据库名' and information_schema.TABLES.TABLE_NAME = '表名';

本作品采用《CC 协议》，转载必须注明作者和本文链接