Count the size and total number of tables of each mysql database.

Measure the size of each database and the total number of tables in the mysql database. The unit for calculating the total size of the real data and index data in each database is MB. The unit for calculating the actual data is MB, the size of the index data is MB, which includes the total number of tables and the current date. In descending order of the size of each database. SQL code SELECT table_schema, \ SUM (data_length + index_length)/1024/1024 AS total_mb, \ SUM (data_length)/1024/1024 AS data_mb, \ SUM (index_length)/1024/1024 AS index_mb, \ COUNT (*) AS tables, \ CURDATE () AS today \ FROM information_schema.tables \ group by table_schema \ order by 2 DESC;