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 | 6956 | 12657049274496 | 0 | 1819587264 | 233296477920 | 1588 | 31129600 | 19603.0227 | 3944 | 134430720 | 34084.8682 | 165560320 | |
sql/io_cache | 1894 | 194858637072 | 0 | 102881856 | 86838969888 | 900 | 43259976 | 48066.6400 | 744 | 43251228 | 58133.3710 | 86511204 | |
innodb/innodb_temp_file | 993 | 1775713535376 | 0 | 1788230928 | 232762062720 | 0 | 0 | 0.0000 | 870 | 19038208 | 21882.9977 | 19038208 | |
sql/ERRMSG | 70 | 37972019184 | 2923008 | 542457168 | 3769126944 | 42 | 4297629 | 102324.5000 | 0 | 0 | 0.0000 | 4297629 | |
innodb/innodb_log_file | 4145 | 21630308777088 | 250272 | 5218409592 | 105948853824 | 8 | 70656 | 8832.0000 | 2553 | 3249664 | 1272.8805 | 3320320 | |
myisam/dfile | 5301 | 13163459232 | 0 | 2483184 | 3564073920 | 1269 | 94499 | 74.4673 | 3340 | 490780 | 146.9401 | 585279 | |
sql/binlog | 943 | 1368489528384 | 0 | 1451208264 | 41573934336 | 173 | 1435 | 8.2948 | 154 | 519090 | 3370.7143 | 520525 | |
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 |
|