How to obtain the database size in mysql

1. check the mysql database size SELECTsum (DATA_LENGTH) + sum (INDEX_LENGTH) FROMinformation_schema.TABLESwhereTABLE_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: selectTABLE_NAME, UPD

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) is M. 2. view the last mysql modification time of the table. select TABLE_NAME, UPD

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, and 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.