查看mysql数据库容量大小方法
第一种情况：查询所有数据库的总大小
方法如下：
mysql> use information_schema;
mysql> select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES;
+-----------+
| data |
+-----------+
| 3052.76MB |
+-----------+
1 row in set (0.02 sec)
统计一下所有库数据量
每张表数据量=AVG_ROW_LENGTH*TABLE_ROWS+INDEX_LENGTH
SELECT
SUM(AVG_ROW_LENGTH*TABLE_ROWS+INDEX_LENGTH)/1024/1024 AS total_mb
FROM information_schema.TABLES
统计每个库大小：
SELECT
table_schema,SUM(AVG_ROW_LENGTH*TABLE_ROWS+INDEX_LENGTH)/1024/1024 AS total_mb
FROM information_schema.TABLES group by table_schema;
第二种情况：查看指定数据库的大小，比如说：数据库test，方法如下：
mysql> use information_schema;
mysql> select concat(round(sum(DATA_LENGTH/1024/1024),2),'MB') as data from TABLES where table_schema='test';
+----------+
| data |
+----------+
| 142.84MB |
+----------+
1 row in set (0.00 sec)
1.查看所有数据库各容量大小
select
table_schema as '数据库',
sum(table_rows) as '记录数',
sum(truncate(data_length/1024/1024, 2)) as '数据容量(MB)',
sum(truncate(index_length/1024/1024, 2)) as '索引容量(MB)'
from information_schema.tables
group by table_schema
order by sum(data_length) desc, sum(index_length) desc;
2.查看所有数据库各表容量大小
select
table_schema as '数据库',
table_name as '表名',
table_rows as '记录数',
truncate(data_length/1024/1024, 2) as '数据容量(MB)',
truncate(index_length/1024/1024, 2) as '索引容量(MB)'
from information_schema.tables
order by data_length desc, index_length desc;
3.查看指定数据库容量大小
例：查看mysql库容量大小
select
table_schema as '数据库',
sum(table_rows) as '记录数',
sum(truncate(data_length/1024/1024, 2)) as '数据容量(MB)',
sum(truncate(index_length/1024/1024, 2)) as '索引容量(MB)'
from information_schema.tables
where table_schema='mysql';
4.查看指定数据库各表容量大小
例：查看mysql库各表容量大小
select
table_schema as '数据库',
table_name as '表名',
table_rows as '记录数',
truncate(data_length/1024/1024, 2) as '数据容量(MB)',
truncate(index_length/1024/1024, 2) as '索引容量(MB)'
from information_schema.tables
where table_schema='mysql'
order by data_length desc, index_length desc;
https://www.hongxiu.com/booklist/1633788
https://www.hongxiu.com/booklist/1633787
https://www.hongxiu.com/booklist/1633786
https://www.hongxiu.com/booklist/1633785
https://www.hongxiu.com/booklist/1633784
https://www.hongxiu.com/booklist/1633783
https://www.hongxiu.com/booklist/1633782
https://www.hongxiu.com/booklist/1633781
https://www.hongxiu.com/booklist/1633780
https://www.hongxiu.com/booklist/1633779
https://www.hongxiu.com/booklist/1633778
https://www.hongxiu.com/booklist/1633777
https://www.hongxiu.com/booklist/1633776
https://www.hongxiu.com/booklist/1633775
https://www.hongxiu.com/booklist/1633774
https://www.hongxiu.com/booklist/1633773
https://www.hongxiu.com/booklist/1633772
https://www.hongxiu.com/booklist/1633771
https://www.hongxiu.com/booklist/1633770
https://www.hongxiu.com/booklist/1633769
https://www.hongxiu.com/booklist/1633768
https://www.hongxiu.com/booklist/1633767
https://www.hongxiu.com/booklist/1633766
https://www.hongxiu.com/booklist/1633765
https://www.hongxiu.com/booklist/1633764
https://www.hongxiu.com/booklist/1633763
https://www.hongxiu.com/booklist/1633762
https://www.hongxiu.com/booklist/1633761
https://www.hongxiu.com/booklist/1633760
https://www.hongxiu.com/booklist/1633759
https://www.hongxiu.com/booklist/1633758
https://www.hongxiu.com/booklist/1633756
https://www.hongxiu.com/booklist/1633757
https://www.hongxiu.com/booklist/1633755
https://www.hongxiu.com/booklist/1633754
https://www.hongxiu.com/booklist/1633753
https://www.hongxiu.com/booklist/1633752
https://www.hongxiu.com/booklist/1633751
https://www.hongxiu.com/booklist/1633750
https://www.hongxiu.com/booklist/1633749
https://www.hongxiu.com/booklist/1633747
https://www.hongxiu.com/booklist/1633748
https://www.hongxiu.com/booklist/1633746
https://www.hongxiu.com/booklist/1633745
https://www.hongxiu.com/booklist/1633744
https://www.hongxiu.com/booklist/1633743
https://www.hongxiu.com/booklist/1633742
https://www.hongxiu.com/booklist/1633741
https://www.hongxiu.com/booklist/1633740
https://www.hongxiu.com/booklist/1633739
https://www.hongxiu.com/booklist/1633738
https://www.hongxiu.com/booklist/1633737
https://www.hongxiu.com/booklist/1633736
https://www.hongxiu.com/booklist/1633735
https://www.hongxiu.com/booklist/1633734
https://www.hongxiu.com/booklist/1633730
https://www.hongxiu.com/booklist/1633733
https://www.hongxiu.com/booklist/1633732
https://www.hongxiu.com/booklist/1633731
https://www.hongxiu.com/booklist/1633729
https://www.hongxiu.com/booklist/1633724
https://www.hongxiu.com/booklist/1633728
https://www.hongxiu.com/booklist/1633722
https://www.hongxiu.com/booklist/1633726
https://www.hongxiu.com/booklist/1633727
https://www.hongxiu.com/booklist/1633725
https://www.hongxiu.com/booklist/1633723
https://www.hongxiu.com/booklist/1633719
https://www.hongxiu.com/booklist/1633721
https://www.hongxiu.com/booklist/1633720
https://www.hongxiu.com/booklist/1633718
https://www.hongxiu.com/booklist/1633717
https://www.hongxiu.com/booklist/1633716
https://www.hongxiu.com/booklist/1633715
https://www.hongxiu.com/booklist/1633714
https://www.hongxiu.com/booklist/1633713
https://www.hongxiu.com/booklist/1633712
https://www.hongxiu.com/booklist/1633711
https://www.hongxiu.com/booklist/1633710
https://www.hongxiu.com/booklist/1633708
https://www.hongxiu.com/booklist/1633709
https://www.hongxiu.com/booklist/1633707
https://www.hongxiu.com/booklist/1633706
https://www.hongxiu.com/booklist/1633705
https://www.hongxiu.com/booklist/1633704
https://www.hongxiu.com/booklist/1633703
https://www.hongxiu.com/booklist/1633702
https://www.hongxiu.com/booklist/1633701
https://www.hongxiu.com/booklist/1633700
https://www.hongxiu.com/booklist/1633699
https://www.hongxiu.com/booklist/1633698
https://www.hongxiu.com/booklist/1633697
https://www.hongxiu.com/booklist/1633696
https://www.hongxiu.com/booklist/1633695
https://www.hongxiu.com/booklist/1633694
https://www.hongxiu.com/booklist/1633693
https://www.hongxiu.com/booklist/1633691
https://www.hongxiu.com/booklist/1633692
https://www.hongxiu.com/booklist/1633690
https://www.hongxiu.com/booklist/1633689
https://www.hongxiu.com/booklist/1633688
https://www.hongxiu.com/booklist/1633687
https://www.hongxiu.com/booklist/1633683
https://www.hongxiu.com/booklist/1633686
https://www.hongxiu.com/booklist/1633685
https://www.hongxiu.com/booklist/1633684
https://www.hongxiu.com/booklist/1633682
https://www.hongxiu.com/booklist/1633680
https://www.hongxiu.com/booklist/1633681
https://www.hongxiu.com/booklist/1633679
https://www.hongxiu.com/booklist/1633678
https://www.hongxiu.com/booklist/1633677
https://www.hongxiu.com/booklist/1633676
https://www.hongxiu.com/booklist/1633675
https://www.hongxiu.com/booklist/1633674
https://www.hongxiu.com/booklist/1633673
https://www.hongxiu.com/booklist/1633672
https://www.hongxiu.com/booklist/1633671
https://www.hongxiu.com/booklist/1633670
https://www.hongxiu.com/booklist/1633669
https://www.hongxiu.com/booklist/1633668
https://www.hongxiu.com/booklist/1633667
https://www.hongxiu.com/booklist/1633666
https://www.hongxiu.com/booklist/1633665
https://www.hongxiu.com/booklist/1633664
https://www.hongxiu.com/booklist/1633663
https://www.hongxiu.com/booklist/1633661
https://www.hongxiu.com/booklist/1633662
https://www.hongxiu.com/booklist/1633660
https://www.hongxiu.com/booklist/1633659
https://www.hongxiu.com/booklist/1633658
https://www.hongxiu.com/booklist/1633657
https://www.hongxiu.com/booklist/1633652
https://www.hongxiu.com/booklist/1633656
https://www.hongxiu.com/booklist/1633655
https://www.hongxiu.com/booklist/1633654
https://www.hongxiu.com/booklist/1633653
https://www.hongxiu.com/booklist/1633648
https://www.hongxiu.com/booklist/1633651
https://www.hongxiu.com/booklist/1633650
https://www.hongxiu.com/booklist/1633649
https://www.hongxiu.com/booklist/1633645
https://www.hongxiu.com/booklist/1633647
https://www.hongxiu.com/booklist/1633646
https://www.hongxiu.com/booklist/1633644
https://www.hongxiu.com/booklist/1633643
https://www.hongxiu.com/booklist/1633642
https://www.hongxiu.com/booklist/1633641
https://www.hongxiu.com/booklist/1633640
https://www.hongxiu.com/booklist/1633639
https://www.hongxiu.com/booklist/1633638
https://www.hongxiu.com/booklist/1633637
https://www.hongxiu.com/booklist/1633636
https://www.hongxiu.com/booklist/1633635
https://www.hongxiu.com/booklist/1633634
https://www.hongxiu.com/booklist/1633633
https://www.hongxiu.com/booklist/1633632
https://www.hongxiu.com/booklist/1633631
https://www.hongxiu.com/booklist/1633630
https://www.hongxiu.com/booklist/1633629
https://www.hongxiu.com/booklist/1633628
https://www.hongxiu.com/booklist/1633627
https://www.hongxiu.com/booklist/1633626
https://www.hongxiu.com/booklist/1633625
https://www.hongxiu.com/booklist/1633624
https://www.hongxiu.com/booklist/1633623
https://www.hongxiu.com/booklist/1633622
https://www.hongxiu.com/booklist/1633621
https://www.hongxiu.com/booklist/1633618
https://www.hongxiu.com/booklist/1633620
https://www.hongxiu.com/booklist/1633619
https://www.hongxiu.com/booklist/1633617
https://www.hongxiu.com/booklist/1633616
https://www.hongxiu.com/booklist/1633615
https://www.hongxiu.com/booklist/1633614
https://www.hongxiu.com/booklist/1633613
https://www.hongxiu.com/booklist/1633612
https://www.hongxiu.com/booklist/1633611
https://www.hongxiu.com/booklist/1633610
https://www.hongxiu.com/booklist/1633609
https://www.hongxiu.com/booklist/1633608
https://www.hongxiu.com/booklist/1633607
https://www.hongxiu.com/booklist/1633606
https://www.hongxiu.com/booklist/1633605
https://www.hongxiu.com/booklist/1633604
https://www.hongxiu.com/booklist/1633603
https://www.hongxiu.com/booklist/1633602
https://www.hongxiu.com/booklist/1633601
https://www.hongxiu.com/booklist/1633600
https://www.hongxiu.com/booklist/1633599
https://www.hongxiu.com/booklist/1633598
https://www.hongxiu.com/booklist/1633597
https://www.hongxiu.com/booklist/1633595
https://www.hongxiu.com/booklist/1633596
https://www.hongxiu.com/booklist/1633594
https://www.hongxiu.com/booklist/1633593
https://www.hongxiu.com/booklist/1633592
https://www.hongxiu.com/booklist/1633591
https://www.hongxiu.com/booklist/1633590
https://www.hongxiu.com/booklist/1633589
https://www.hongxiu.com/booklist/1633587
https://www.hongxiu.com/booklist/1633588
https://www.hongxiu.com/booklist/1633586
https://www.hongxiu.com/booklist/1633585
https://www.hongxiu.com/booklist/1633584
https://www.hongxiu.com/booklist/1633583
https://www.hongxiu.com/booklist/1633582
https://www.hongxiu.com/booklist/1633581
https://www.hongxiu.com/booklist/1633580
https://www.hongxiu.com/booklist/1633579
https://www.hongxiu.com/booklist/1633578
https://www.hongxiu.com/booklist/1633577
https://www.hongxiu.com/booklist/1633576
https://www.hongxiu.com/booklist/1633575
https://www.hongxiu.com/booklist/1633574
https://www.hongxiu.com/booklist/1633573
https://www.hongxiu.com/booklist/1633572
https://www.hongxiu.com/booklist/1633571
https://www.hongxiu.com/booklist/1633570
https://www.hongxiu.com/booklist/1633569
https://www.hongxiu.com/booklist/1633568
https://www.hongxiu.com/booklist/1633567
https://www.hongxiu.com/booklist/1633565
https://www.hongxiu.com/booklist/1633564
https://www.hongxiu.com/booklist/1633566
https://www.hongxiu.com/booklist/1633563
https://www.hongxiu.com/booklist/1633562
https://www.hongxiu.com/booklist/1633561
https://www.hongxiu.com/booklist/1633560
https://www.hongxiu.com/booklist/1633559
https://www.hongxiu.com/booklist/1633558
https://www.hongxiu.com/booklist/1633557
https://www.hongxiu.com/booklist/1633554
https://www.hongxiu.com/booklist/1633556
https://www.hongxiu.com/booklist/1633555
https://www.hongxiu.com/booklist/1633553
https://www.hongxiu.com/booklist/1633552
https://www.hongxiu.com/booklist/1633551
https://www.hongxiu.com/booklist/1633550
https://www.hongxiu.com/booklist/1633549
https://www.hongxiu.com/booklist/1633546
https://www.hongxiu.com/booklist/1633548
https://www.hongxiu.com/booklist/1633547
https://www.hongxiu.com/booklist/1633545
https://www.hongxiu.com/booklist/1633544
https://www.hongxiu.com/booklist/1633543
https://www.hongxiu.com/booklist/1633542
https://www.hongxiu.com/booklist/1633541
https://www.hongxiu.com/booklist/1633540
https://www.hongxiu.com/booklist/1633539
https://www.hongxiu.com/booklist/1633538
https://www.hongxiu.com/booklist/1633537
https://www.hongxiu.com/booklist/1633536
https://www.hongxiu.com/booklist/1633535
https://www.hongxiu.com/booklist/1633534
https://www.hongxiu.com/booklist/1633533
https://www.hongxiu.com/booklist/1633532
https://www.hongxiu.com/booklist/1633531
https://www.hongxiu.com/booklist/1633530
https://www.hongxiu.com/booklist/1633529
https://www.hongxiu.com/booklist/1633528
https://www.hongxiu.com/booklist/1633527
https://www.hongxiu.com/booklist/1633526
https://www.hongxiu.com/booklist/1633525
https://www.hongxiu.com/booklist/1633524
https://www.hongxiu.com/booklist/1633522
https://www.hongxiu.com/booklist/1633523
https://www.hongxiu.com/booklist/1633521
https://www.hongxiu.com/booklist/1633520
https://www.hongxiu.com/booklist/1633516
https://www.hongxiu.com/booklist/1633509
https://www.hongxiu.com/booklist/1633519
https://www.hongxiu.com/booklist/1633515
https://www.hongxiu.com/booklist/1633518
https://www.hongxiu.com/booklist/1633514
https://www.hongxiu.com/booklist/1633517
https://www.hongxiu.com/booklist/1633512
https://www.hongxiu.com/booklist/1633513
https://www.hongxiu.com/booklist/1633511
https://www.hongxiu.com/booklist/1633510
https://www.hongxiu.com/booklist/1633508
https://www.hongxiu.com/booklist/1633507
https://www.hongxiu.com/booklist/1633506
https://www.hongxiu.com/booklist/1633505
https://www.hongxiu.com/booklist/1633504
https://www.hongxiu.com/booklist/1633503
https://www.hongxiu.com/booklist/1633502
https://www.hongxiu.com/booklist/1633501
https://www.hongxiu.com/booklist/1633500
https://www.hongxiu.com/booklist/1633499
https://www.hongxiu.com/booklist/1633498
https://www.hongxiu.com/booklist/1633497
https://www.hongxiu.com/booklist/1633496
https://www.hongxiu.com/booklist/1633495
https://www.hongxiu.com/booklist/1633494
https://www.hongxiu.com/booklist/1633493
https://www.hongxiu.com/booklist/1633492
https://www.hongxiu.com/booklist/1633491
https://www.hongxiu.com/booklist/1633488
https://www.hongxiu.com/booklist/1633489
https://www.hongxiu.com/booklist/1633490
https://www.hongxiu.com/booklist/1633487
https://www.hongxiu.com/booklist/1633486
https://www.hongxiu.com/booklist/1633484
https://www.hongxiu.com/booklist/1633485
https://www.hongxiu.com/booklist/1633480
https://www.hongxiu.com/booklist/1633482
https://www.hongxiu.com/booklist/1633483
https://www.hongxiu.com/booklist/1633481
https://www.hongxiu.com/booklist/1633477
https://www.hongxiu.com/booklist/1633479
https://www.hongxiu.com/booklist/1633478