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 vote316 views1 answer
Selecting Data in SQL - Select Data
SQL
2 votes329 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
0 vote308 views1 answer
Sqlite update only if greater
SQL
0 vote297 views1 answer
Mysql error codeigniter
SQL
18 votes320 views4 answers
Uninstall mysql on ubuntu
SQL
1 vote327 views1 answer
Oracle create_program
SQL
0 vote324 views1 answer
How to get data from 2 database
SQL
0 vote323 views1 answer
Every Derived yable must have its own alias
SQL
0 vote263 views1 answer
Check if has alpha characters sql
SQL
0 vote311 views1 answer
Dump multiple tables mysql
SQL