SELECT * FROM `x$io_global_by_wait_by_bytes`
|
event_name | total | total_latency | min_latency | avg_latency | max_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | total_requested | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_data_file | 6602 | 12189835798800 | 0 | 1846385112 | 233296477920 | 1581 | 31014912 | 19617.2751 | 3644 | 124829696 | 34256.2283 | 155844608 | |
sql/io_cache | 1770 | 193243260144 | 0 | 109176936 | 86838969888 | 832 | 40455656 | 48624.5865 | 698 | 40446908 | 57946.8596 | 80902564 | |
innodb/innodb_temp_file | 990 | 1761806991120 | 0 | 1779602880 | 232762062720 | 0 | 0 | 0.0000 | 868 | 18939904 | 21820.1659 | 18939904 | |
sql/ERRMSG | 70 | 37972019184 | 2923008 | 542457168 | 3769126944 | 42 | 4297629 | 102324.5000 | 0 | 0 | 0.0000 | 4297629 | |
innodb/innodb_log_file | 3930 | 20625244367376 | 250272 | 5248153680 | 105948853824 | 8 | 70656 | 8832.0000 | 2419 | 3120128 | 1289.8421 | 3190784 | |
myisam/dfile | 5299 | 13155226656 | 0 | 2482392 | 3564073920 | 1269 | 94499 | 74.4673 | 3340 | 490780 | 146.9401 | 585279 | |
sql/binlog | 925 | 1355064018000 | 0 | 1464933888 | 41573934336 | 169 | 1419 | 8.3964 | 153 | 518715 | 3390.2941 | 520134 | |
sql/SDI | 24 | 861870240 | 0 | 35911128 | 155739408 | 0 | 0 | 0.0000 | 7 | 32069 | 4581.2857 | 32069 | |
mysys/charset | 3 | 273181920 | 3851232 | 91060464 | 252586224 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/kfile | 108 | 3439469088 | 0 | 31846848 | 594682176 | 20 | 3735 | 186.7500 | 48 | 2840 | 59.1667 | 6575 | |
sql/binlog_index | 38 | 42034233120 | 0 | 1106163960 | 22641224496 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 564948384 | 669504 | 70618416 | 287829696 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 419504448 | 208032 | 83900784 | 397463088 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13537392 | 631488 | 4512288 | 10782288 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
csv/data | 8 | 953889552 | 0 | 119236128 | 344532672 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 29 | 689628720 | 0 | 23780064 | 269687088 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/casetest | 15 | 869730048 | 0 | 57981792 | 788290272 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|