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 vote406 views1 answer
Insert into using contant values and source table columns with sql
SQL
6 votes329 views1 answer
SQL insert all columns
SQL
0 vote364 views1 answer
Delete first row in sql
SQL
25 votes369 views3 answers
How to use a database to see tables mysql
SQL
0 vote366 views1 answer
How to list function in psql
SQL
0 vote372 views1 answer
Selecting Multiple Columns in SQL
SQL
1 vote364 views1 answer
Sql dcl
SQL
0 vote379 views1 answer
T-sql delete view if exists
SQL
0 vote330 views1 answer
How to connect to mysql in ef 6
SQL
13 votes322 views3 answers
Uninstall mysql centos 7
SQL