Show size database mysql

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

Show size database 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

Similar codes

0 vote113 views1 answer
Cast for print sql
SQL
2 votes124 views1 answer
Orcale index size
SQL
11 votes130 views5 answers
Sql server reset identity
SQL
0 vote123 views1 answer
Sql server roles and users
SQL
0 vote120 views1 answer
Plsql check how much space all databases are consuming
SQL
8 votes127 views1 answer
Show mysql user table
SQL
0 vote76 views1 answer
Print sum of values sql
SQL
1 vote93 views1 answer
Import in mysql without a software
SQL
0 vote78 views1 answer
Mysql date + 1 day
SQL
8 votes147 views6 answers
Insert command in sql
SQL