Mysql check 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 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 vote265 views3 answers
Drop multiple columns in sql
SQL
6 votes301 views2 answers
Mysql 1 day ago
SQL
1 vote284 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote229 views1 answer
Postgresql add leading zeros
SQL
1 vote296 views1 answer
Sqlite update from another table
SQL
1 vote336 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote295 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
1 vote284 views1 answer
Oracle turn off constraint
SQL
6 votes303 views3 answers
How to delete table sqlite
SQL
0 vote272 views1 answer
Mariadb used space
SQL