How to obtain the database size in mysql _ MySQL

How to obtain the database size bitsCN.com in mysql

1. view the mysql database size
SELECT sum (DATA_LENGTH) + sum (INDEX_LENGTH)
FROM information_schema.TABLES where TABLE_SCHEMA = 'database name ';
The 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 check the mysql modification time of the table in the database to determine whether the mysql database is no longer in use for a long time.

BitsCN.com