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 | 2403 | 2268222436128 | 0 | 943912728 | 233296477920 | 1315 | 26656768 | 20271.3065 | 746 | 33210368 | 44517.9196 | 59867136 | |
sql/io_cache | 662 | 104424532608 | 0 | 157740792 | 86838969888 | 266 | 15074548 | 56671.2331 | 276 | 15074548 | 54617.9275 | 30149096 | |
innodb/innodb_temp_file | 494 | 937142587392 | 0 | 1897049616 | 232762062720 | 0 | 0 | 0.0000 | 419 | 8503296 | 20294.2625 | 8503296 | |
sql/ERRMSG | 40 | 22552149312 | 2923008 | 563803680 | 3769126944 | 24 | 2464976 | 102707.3333 | 0 | 0 | 0.0000 | 2464976 | |
sql/binlog | 250 | 377375527584 | 0 | 1509502104 | 41573934336 | 35 | 736 | 21.0286 | 82 | 491752 | 5996.9756 | 492488 | |
myisam/dfile | 3353 | 2893970112 | 255024 | 863016 | 22671264 | 0 | 0 | 0.0000 | 3338 | 490724 | 147.0114 | 490724 | |
innodb/innodb_log_file | 627 | 3507156628800 | 250272 | 5593551216 | 105948853824 | 8 | 70656 | 8832.0000 | 361 | 316416 | 876.4986 | 387072 | |
mysys/charset | 3 | 273181920 | 3851232 | 91060464 | 252586224 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/SDI | 6 | 127043136 | 2683824 | 21173856 | 49788288 | 0 | 0 | 0.0000 | 2 | 14641 | 7320.5000 | 14641 | |
myisam/kfile | 51 | 2296979520 | 313632 | 45038664 | 594682176 | 10 | 1938 | 193.8000 | 25 | 1627 | 65.0800 | 3565 | |
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 | 4 | 625429200 | 0 | 156357168 | 344532672 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 8 | 365405040 | 0 | 45675432 | 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 |
|