mysqlGet largest tables list
SELECT table_name, round(((data_length + index_length) / 1024 / 1024), 2) 'Size, MB'
FROM information_schema.TABLES
ORDER BY data_length + index_length DESC LIMIT 25;ctrl + ctable_namename of table | round(((data_length + index_length) / 1024 / 1024), 2)calculates total table size in MB |
information_schema.TABLESsystem table with all tables meta data | ORDER BY data_length + index_lengthshow largest tables at the top |
LIMIT 25show 25 largest tables (change to your needs) | |
More of Mysql
- Disable ONLY_FULL_GROUP_BY mode
- Insert/update multiple rows in single query
- How to find my.cnf config file
- Truncate all tables in a specific database
- How to find duplicate varchar/text column values in table
- What is the MEDIUMTEXT column max size (length) in Mysql
- What is the LONGTEXT column max size (length) in Mysql
- Skip certain tables while doing dump
- What is the TINYINT column max value and size in Mysql
See more codes...