Get database size mysql

SELECT table_schema "DB Name",
        ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" 
FROM information_schema.tables 
GROUP BY table_schema;

Source: stackoverflow.com

Mysql check db size

SELECT table_schema "DB Name",
        ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" 
FROM information_schema.tables 
GROUP BY table_schema;

Source: stackoverflow.com

Similar codes

0 vote230 views2 answers
Postgres default user
SQL
15 votes221 views2 answers
How to know the username of postgresql
SQL
8 votes223 views1 answer
Insert a select statement into a table
SQL
1 vote235 views1 answer
Sql pick random row
SQL
0 vote229 views2 answers
Oracle create tablespace autoextend
SQL
0 vote229 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
5 votes220 views2 answers
Mysql drop table cascade
SQL
1 vote239 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote237 views1 answer
Mysql date format unix timestamp
SQL
0 vote245 views1 answer
No query unable to fetch row sqlite
SQL