View MySQL database size, table size, and last modified time

View database table basic information.

SELECT * FROM INFORMATION_SCHEMA. TABLES where INFORMATION_SCHEMA. TABLES. Table_schema = ' database name ' and INFORMATION_SCHEMA. TABLES. table_name = ' table name ';

View MySQL Database size

SELECT sum (data_length) +sum (index_length) from INFORMATION_SCHEMA. TABLES where table_schema= ' database name ';

The resulting result is in bytes, except 1024 for K, except 1048576 (=1024*1024) for M.

View the last MySQL modification time for a table

Select Table_name,update_time from INFORMATION_SCHEMA. TABLES where table_schema= ' database name ' ORDER BY update_time desc LIMIT 1;

Select Table_name,update_time from INFORMATION_SCHEMA. TABLES where table_schema= ' database name ' and INFORMATION_SCHEMA. TABLES. table_name = ' table name ';

View MySQL database size, table size, and last modified time