SELECT table_schema "Database Name", create_time, ROUND(SUM(data_length+index_length)/1024/1024, 0)
"Database Size (MB)",ROUND(SUM(data_length+index_length)/1024/1024/1024)
"Database Size (GB)" FROM information_schema.TABLES GROUP BY table_schema;
"Database Size (MB)",ROUND(SUM(data_length+
"Database Size (GB)" FROM information_schema.TABLES GROUP BY table_schema;
No comments:
Post a Comment