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 vote278 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote263 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote280 views1 answer
How to to get current date in sql
SQL
0 vote309 views1 answer
Mysql backup query
SQL
2 votes339 views1 answer
Tcl in sql
SQL
0 vote279 views1 answer
How to input data as id in database sql c#
SQL
1 vote590 views1 answer
Athena query timestamp greater than
SQL
5 votes289 views2 answers
Oracle list columns
SQL
0 vote295 views1 answer
Connect by query in oracle
SQL
0 vote279 views1 answer
Mysql return column names when table is empty
SQL