Mysql db size

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 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

8 votes341 views1 answer
Oracle search source code
SQL
0 vote339 views1 answer
How to create a table in sql stack overflow
SQL
1 vote365 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote286 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote343 views1 answer
Sql server manager close connection
SQL
10 votes349 views2 answers
Linux command line import mysql database
SQL
2 votes343 views3 answers
3 days back in sql server
SQL
0 vote329 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote344 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
1 vote340 views1 answer
Mysql show table character set
SQL