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

1 vote152 views2 answers
End mysql command
SQL
2 votes228 views1 answer
Sql ends with string
SQL
0 vote134 views1 answer
Const pool = mysql.createpool()
SQL
0 vote147 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote126 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
16 votes130 views6 answers
Install sqlite3 python
SQL
14 votes140 views1 answer
Excel is not a database
SQL
0 vote125 views1 answer
Wordpress database query change url
SQL
0 vote132 views1 answer
Oracle webcenter content search enginer
SQL
0 vote126 views1 answer
Sql last 7 days
SQL