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 vote133 views1 answer
Group by sql not ordering issues
SQL
0 vote160 views1 answer
Leftjoin in sql
SQL
1 vote147 views1 answer
Does insert into overwrite sql
SQL
0 vote140 views1 answer
Mariadb errno 121
SQL
0 vote138 views1 answer
Create table with primary key and foreign key in sql server
SQL
23 votes161 views4 answers
Uninstall postgresql ubuntu
SQL
12 votes153 views5 answers
Sql primary key
SQL
0 vote140 views1 answer
Mysql add to number
SQL
3 votes156 views1 answer
Oracle undo tablespace schema
SQL
0 vote175 views1 answer
Plpgsql create function
SQL