Answers for "mysql table size too big"

big table in mysql

SELECT 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  AND table_schema = "magento" 
ORDER BY (data_length + index_length) DESC;

Posted by: Guest on October-20-2020

Code answers related to "mysql table size too big"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql table size too big"

Code answers related to "mysql table size too big"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql table size too big"

Code answers related to "mysql table size too big"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us