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

5 votes200 views2 answers
Get columns number sql
SQL
1 vote186 views2 answers
How to enable error squiggles in vs code
SQL
-1 vote192 views3 answers
How to restart mysql in linux
SQL
3 votes190 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote180 views1 answer
Update having mysql
SQL
0 vote183 views1 answer
One table with another
SQL
15 votes175 views4 answers
Mysql where value is null
SQL
0 vote211 views1 answer
Mysql best varchar length size
SQL
1 vote271 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
0 vote209 views1 answer
Sqlite version check
SQL