Mysql list tables by size

Mysql list bigger table

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: tableplus.com

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

Mysql list tables by size

/*replace your_database_name with your db name, and then run this:*/
SELECT TABLE_NAME, table_rows, data_length, index_length, 
round(((data_length + index_length) / 1024 / 1024),2) "Size in MB"
FROM information_schema.TABLES WHERE table_schema = "your_database_name"
ORDER BY (data_length + index_length) DESC;

Source: stackoverflow.com

Similar codes

28 votes109 views6 answers
Mysql change user password
SQL
28 votes119 views6 answers
Foreign key
SQL
0 vote177 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote106 views1 answer
Get all employees if name ends with in sql
SQL
13 votes117 views2 answers
Sql online compiler
SQL
12 votes115 views1 answer
How to change the value of a table in sql
SQL
24 votes111 views6 answers
Sql change table name
SQL
0 vote121 views2 answers
How to type a blank discord messgae
SQL
0 vote116 views1 answer
T sql return on letters only
SQL
24 votes109 views5 answers
Sql server insert into select
SQL