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 vote338 views2 answers
How to delete the rows with null values in mysql
SQL
1 vote332 views1 answer
Postgresql last element of array
SQL
5 votes351 views1 answer
Mysql created at yesterdau
SQL
1 vote336 views1 answer
Postgres select as csv
SQL
0 vote337 views1 answer
Report in database
SQL
0 vote337 views1 answer
Get employees if not contains in sql
SQL
0 vote341 views1 answer
T sql cursor tr
SQL
0 vote324 views1 answer
T sql return on letters only
SQL
0 vote371 views1 answer
Mysql change default collation
SQL
0 vote334 views1 answer
Mysql docker image arjun
SQL