Return size of tables in mysql

SELECT 
     table_schema as `Database`, 
     table_name AS `Table`, 
     round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
FROM information_schema.TABLES 
ORDER BY (data_length + index_length) DESC;

Source: stackoverflow.com

Similar codes

0 vote112 views1 answer
Finish transaction sql
SQL
16 votes184 views3 answers
Order by sql query
SQL
0 vote159 views1 answer
Adding generated time in row mysql workbench
SQL
3 votes156 views1 answer
Sql multi column index performance
SQL
0 vote183 views1 answer
Postgres list users and roles
SQL
0 vote182 views1 answer
How to check foreign key constraint in sql
SQL
0 vote154 views1 answer
Sql select most frequent value in column
SQL
1 vote147 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
0 vote145 views1 answer
Mariadb number format
SQL
11 votes164 views2 answers
How to import mysql database command line
SQL