Answers for "mysql get the largest table size"

find largest table in mysql database

SELECT table_schema as "Database", table_name AS "Table", 
ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)" 
FROM information_schema.TABLES 
WHERE (data_length + index_length) > 1000000 
ORDER BY table_schema, (data_length + index_length) DESC

Posted by: Guest on October-20-2020

Code answers related to "mysql get the largest table size"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql get the largest table size"

Code answers related to "mysql get the largest table size"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql get the largest table size"

Code answers related to "mysql get the largest table size"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us