如何查詢mysql資料庫中哪些表的資料量最大

標籤：mysql 資料量最大

1.mysql的information_schema下有儲存資料庫基本資料的資料字典表，可以通過查詢tables表來獲得所需要的表相關資訊。 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;

如何查詢mysql資料庫中哪些表的資料量最大