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

1 vote195 views1 answer
Flask sqlalchemy default value
SQL
0 vote240 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote281 views1 answer
Do you know sql
SQL
9 votes181 views3 answers
Where in sql
SQL
1 vote200 views1 answer
Oracle enable job
SQL
1 vote224 views1 answer
Sql select table header
SQL
3 votes203 views2 answers
Df to sql pandas sql achemy
SQL
2 votes199 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
1 vote189 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
2 votes186 views1 answer
Oracle number to percentage
SQL