Sort the number of rows from a table in a MySQL database from large to small

As the company's business grows, the work requires a table of tables in a database, in order to do a more granular, in the database, all the tables, by the number of rows from to the small sort:

Implementation method:

mysql> use INFORMATION_SCHEMA;

Reading table information for completion of table and column names

Can turn off this feature to get a quicker startup with-a

Database changed

Mysql> Select Table_name,table_rows from Tables ORDER BY table_rows desc limit 30;

+----------------------+------------+

| table_name | Table_rows |

+----------------------+------------+

|  Log | 144359031 |

|   Base_log | 49708134 |

|   base_log_201708 | 15838445 |

|   log_201706 | 11768358 |

|    Customer_log | 9625275 |

|    log_201708 | 7856959 |

|    base_log_201707 | 6270253 |

|    Debug_log | 5708789 |

|    Allocate_log | 5612445 |

|    Web_api_log | 5078173 |

|    log_201707 | 4353787 |

|    Communication_log | 3069630 |

|    base_log_201706 | 2751581 |

|    log_201709 | 2028525 |

|    Sms_log | 1074787 |

|     Service_log | 977777 |

|     Fjs_behavior_log | 819606 |

|     Ocdc_customer | 811990 |

|     base_log_201709 | 733253 |

|     5kcrm_fenpei_log | 524252 |

|     Customer_sale | 517155 |

|     Sys_crmdata_log | 500943 |

|     5kcrm_log | 471193 |

|     Phone_log | 470699 |

|     5kcrm_r_customer_log | 453022 |

|     Realestate_needs | 434770 |

|     Service_customer_log | 428040 |

|     Mail | 342659 |

|     Users | 331449 |

|     Phone_areas | 328089 |

+----------------------+------------+

$ rows in Set (0.97 sec)

This article from "Lotus Pond Jun Tao 51cto Blog" blog, declined reprint!

Sort the number of rows from a table in a MySQL database from large to small