mysql list bigger table

Solutions on MaxInterview for mysql list bigger table by the best coders in the world

Search
showing results for - "mysql list bigger table"
Joshua
14 May 2020
1SELECT
2	table_schema AS `Database`,
3	table_name AS `Table`,
4	round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB`
5FROM
6	information_schema.TABLES
7ORDER BY
8	(data_length + index_length)
9	DESC;
10
source
similar questions
big table in mysqlmysql get table sizemysql db sizemysql terminal list tableget all db sizes in mysql servermysql show attributes of a tablemysql check db sizemysql show table partitionsshow table info mysqlshow table status command in mysqlmysql show table infolist mysql table and index sizeprint all records of table in mysqlmysql show table character setmysql check all tablesmysql show table structuredescribe table mysqlshow table mysqlreturn size of tables in mysqlfind largest table in mysql databaseshow size database mysqlmaximum number of tables in mysqlget database size mysqlheavy table in mysqlshow table structure mysql consolemysql show table fieldshow to check which table has data in mysql
queries leading to this page
mysql list tables and sizesmysql tables sizemysql find why table is largehow to get table size in mysql and view it on htmlfind largest database tables mysqlget table size in mb mysqllist each database table size mysqllist of table size mysqlshow biggest tables in db mysqldisplay the size for all tables mysql command linemysql list tables sizemysql list tables sizesmysql list bigger table