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 vote357 views2 answers
Suse stop MySQL
SQL
11 votes363 views6 answers
Mysql else if
SQL
2 votes343 views1 answer
How to make multiple keys as primary in bdms
SQL
8 votes355 views1 answer
Racle create auto increment column
SQL
0 vote371 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote336 views1 answer
Mssql view column data type
SQL
0 vote334 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
3 votes346 views2 answers
How to load files in mysql
SQL
0 vote327 views1 answer
Original Query
SQL
0 vote365 views1 answer
Rename constraint postgresql
SQL