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 vote106 views1 answer
Import all databases mysql
SQL
0 vote122 views1 answer
How to check which table has data in mysql
SQL
0 vote113 views1 answer
Wp_query raw sql
SQL
0 vote107 views1 answer
Multiple left join mysql
SQL
17 votes139 views2 answers
T_sql contains
SQL
0 vote121 views1 answer
Including parameters in OPENQUERY
SQL
12 votes105 views1 answer
How to change the value of a table in sql
SQL
1 vote127 views1 answer
Mysql login console
SQL
25 votes125 views6 answers
How to change column name in mysql
SQL
0 vote118 views1 answer
Sql add calculated column
SQL