Mysql show database size in mb

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 vote374 views1 answer
How to start my sql server on mac
SQL
2 votes374 views1 answer
Query to find table size in oracle 12c
SQL
0 vote363 views1 answer
Oracle db get table sizes
SQL
0 vote372 views1 answer
Sql cmd no truncate
SQL
0 vote379 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
0 vote343 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote365 views1 answer
T sql check active deadlock
SQL
0 vote395 views1 answer
Sql multiple into
SQL
0 vote300 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote369 views2 answers
How covert into int in maria db
SQL