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 vote363 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote328 views1 answer
Psql select * from table
SQL
0 vote329 views1 answer
Find invalid datetime field
SQL
0 vote331 views1 answer
Mssql now diff 90 day
SQL
0 vote332 views1 answer
Sql dmv to capture updates
SQL
0 vote326 views1 answer
How to use select union and loop
SQL
0 vote362 views1 answer
Oracle list datafiles
SQL
0 vote328 views1 answer
Oracle create package specification
SQL
1 vote355 views2 answers
Oracle list service names
SQL
0 vote322 views1 answer
Optimize sql query
SQL