find largest table in mysql database

Solutions on MaxInterview for find largest table in mysql database by the best coders in the world

Search
showing results for - "find largest table in mysql database"
Matthias
20 May 2020
1SELECT table_schema as "Database", table_name AS "Table", 
2ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)" 
3FROM information_schema.TABLES 
4WHERE (data_length + index_length) > 1000000 
5ORDER BY table_schema, (data_length + index_length) DESC
similar questions
show size database mysqlmaximum number of tables in mysqlmysql get table sizeprint all records of table in mysqlreturn size of tables in mysqlmysql db sizeget database size mysqlmax length found in mysqlmysql check db sizemysql find most common valuehow to get first 10 records of a table in mysqltop 10 rows in mysqlhow to query all tables mysql at the same timemysql list bigger tablemysql query to select the highest valuehow to get mysql db sizemysql select smaller of two valuesmysql tables max countmysql find the row ites of the hoghest value at on columnget all db sizes in mysql servermysql top percentmysql find max value rowmysql get longest string in columnmysql show indexes on tablebig table in mysqlheavy table in mysql
queries leading to this page
find largest database tables mysqltop tables in database mysql querymysql get large tablesshow table have big record mysqlfind largest table in mysql databaseselect largest tables mysqlmysql get the largest table sizeshow biggest tables in db mysqlmysql display tables from biggest to lowestmydql find biggest tablesmysql search largest valuemysql find largest tablesmysql find biggest tablesfind largest table in mysql database