SELECT * FROM `x$io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_log_file | 298 | 1594978044528 | 5352275280 | 71453429520 | 1410869328 | 87790702560 | 1505776472640 | 8 | 70656 | 8832.0000 | 178 | 172032 | 966.4719 | |
innodb/innodb_data_file | 1880 | 1102661122992 | 586521672 | 255830954544 | 162465811728 | 29424255168 | 910771056096 | 1223 | 25149440 | 20563.7285 | 467 | 25083904 | 53712.8565 | |
innodb/innodb_temp_file | 143 | 785006078736 | 5489552904 | 75693267408 | 0 | 3654177120 | 781351901616 | 0 | 0 | 0.0000 | 62 | 3047424 | 49152.0000 | |
sql/binlog_index | 38 | 57239191152 | 1506294504 | 39792057888 | 311414928 | 0 | 56927776224 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/binlog | 141 | 42834657888 | 303791664 | 20904791424 | 711335328 | 47762880 | 42075559680 | 32 | 724 | 22.6250 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 25 | 17317913184 | 692716464 | 2801338320 | 10026147648 | 0 | 7291765536 | 15 | 1531208 | 102080.5333 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1169087568 | 77939136 | 1106025888 | 0 | 0 | 1169087568 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 611903952 | 122380632 | 590283408 | 591536352 | 0 | 20367600 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 2 | 335714544 | 167857272 | 329804640 | 0 | 0 | 335714544 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 278368992 | 92789664 | 249423504 | 249423504 | 0 | 28945488 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 174374112 | 43593528 | 117786240 | 117786240 | 0 | 56587872 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 21898800 | 7299600 | 16901280 | 0 | 3917232 | 17981568 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 12691536 | 12691536 | 12691536 | 0 | 0 | 12691536 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|