return size of tables in mysql

Solutions on MaxInterview for return size of tables in mysql by the best coders in the world

Search
showing results for - "return size of tables in mysql"
Finn
12 Oct 2016
1SELECT 
2     table_schema as `Database`, 
3     table_name AS `Table`, 
4     round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
5FROM information_schema.TABLES 
6ORDER BY (data_length + index_length) DESC;
7
source
similar questions
show size database mysqlmaximum number of tables in mysqlmysql get table sizeprint all records of table in mysqlmysql db sizeget database size mysqlmysql count all table rowsfind largest table in mysql databasesyntax for changing column size in mysqlmysql check db sizemysql get primary keys of tablehow to query all tables mysql at the same timemysql list bigger tableshow table info mysqlhow to check which table has data in mysqlmysql show table partitionshow to get mysql db sizemysql repair a tablemysql show table structuremysql terminal list tabledisplay total number of tables in mysqllist mysql table and index sizemysql show indexes on tableshow table status command in mysqlmysql get all tables row countcount of tables in database mysqlbig table in mysqlheavy table in mysql
queries leading to this page
mysql get table sizelist each database table size mysqlmysql get size of tablemysql tables sizemysql determine table sizeget table size mysql datagripreturn size of tables in mysql