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 vote211 views1 answer
Sql check for null and empty string
SQL
0 vote207 views2 answers
Postgres having
SQL
0 vote187 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote203 views2 answers
Nested query
SQL
2 votes196 views1 answer
Get first n letter of department name in sql
SQL
0 vote205 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
5 votes213 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
-2 votes196 views3 answers
Oracle tablespace usage
SQL
36 votes207 views6 answers
Rename table sql
SQL
0 vote248 views1 answer
Sql select without column name
SQL