How to query which tables in the MySQL database have the largest amount of data

Under the information_schema of 1.mysql, there is a data dictionary table that stores the basic information of the database, which can be queried by querying the tables table to obtain the required table-related information. mysql> show databases;

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M00/87/D2/wKiom1fiNPnzxLkrAAAeFr9AE7s847.png-wh_500x0-wm_3 -wmp_4-s_568716826.png "title=" Qq20160921151845.png "alt=" Wkiom1finpnzxlkraaaefr9ae7s847.png-wh_50 "/>

2. Use Information_schema;

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M01/87/D2/wKiom1fiNUfDTC7cAAAOErCoWpQ067.png-wh_500x0-wm_3 -wmp_4-s_977562445.png "title=" Qq20160921152006.png "alt=" Wkiom1finufdtc7caaaoercowpq067.png-wh_50 "/>

3. Show tables;

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/87/CE/wKioL1fiNW_ROVVcAAAkg2MMGy0913.png-wh_500x0-wm_3 -wmp_4-s_3139218807.png "title=" Qq20160921152055.png "alt=" Wkiol1finw_rovvcaaakg2mmgy0913.png-wh_50 "/>

4. DESC tables;

650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M02/87/D2/wKiom1fiNZ7hjrbxAAAqmSqILJg015.png-wh_500x0-wm_3 -wmp_4-s_1781070491.png "title=" Qq20160921152141.png "alt=" Wkiom1finz7hjrbxaaaqmsqiljg015.png-wh_50 "/>

5 Select Table_name,table_rows from tables ORDER BY table_rows desc Limi 10;

How to query which tables in the MySQL database have the largest amount of data