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

0 vote191 views1 answer
How to install mysql without admin rights
SQL
1 vote200 views1 answer
Mysql show long running queries
SQL
0 vote189 views1 answer
Call function in query sql server
SQL
5 votes192 views1 answer
Postgresql functions
SQL
20 votes186 views2 answers
Counting in sql
SQL
3 votes204 views1 answer
Define REGEXP?
SQL
11 votes193 views2 answers
Insert current date sql
SQL
0 vote182 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote193 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
1 vote193 views1 answer
Sql headers delphi
SQL