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 | 2423 | 2674971401030 | 0 | 1103991325 | 295936092580 | 1468 | 29163520 | 19866.1580 | 604 | 28655616 | 47443.0728 | 57819136 | |
sql/io_cache | 207 | 97275684840 | 0 | 469930595 | 85376596010 | 95 | 4926905 | 51862.1579 | 82 | 4926905 | 60084.2073 | 9853810 | |
sql/ERRMSG | 45 | 25273885280 | 2699820 | 561641795 | 3965526780 | 27 | 2757038 | 102112.5185 | 0 | 0 | 0.0000 | 2757038 | |
innodb/innodb_temp_file | 124 | 882034532470 | 0 | 7113181675 | 51015287270 | 0 | 0 | 0.0000 | 53 | 2244608 | 42351.0943 | 2244608 | |
innodb/innodb_log_file | 496 | 2871779379270 | 225250 | 5789877675 | 48137213960 | 8 | 70656 | 8832.0000 | 284 | 231936 | 816.6761 | 302592 | |
mysys/charset | 3 | 262836010 | 2227060 | 87611915 | 250396380 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 135 | 84446533990 | 0 | 625529850 | 31792159710 | 30 | 716 | 23.8667 | 4 | 397 | 99.2500 | 1113 | |
sql/binlog_index | 38 | 84942130630 | 0 | 2235318990 | 48800717780 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 2424083260 | 246980 | 484816440 | 2401921310 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 16087090 | 761080 | 5362275 | 12895960 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1347009840 | 0 | 89800550 | 1171908440 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 2225497030 | 0 | 1112748515 | 2219937330 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|