SQL statement view MySQL database size

1. 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.

2. View the last MySQL modification time of the table
Select Table_name,update_time from information_schema.tables where table_schema= ' database name ';
You can determine whether the MySQL database has been unused for long periods by looking at the MySQL modification time of the tables in the database.

SQL statement view MySQL database size