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 | 211 | 1140126977616 | 5403445344 | 71453429520 | 1410869328 | 73097599344 | 1065618508944 | 8 | 70656 | 8832.0000 | 121 | 121344 | 1002.8430 | |
innodb/innodb_data_file | 1632 | 838141667616 | 513567120 | 255830954544 | 151229512896 | 17960580528 | 668951574192 | 1193 | 24657920 | 20668.8349 | 268 | 18694144 | 69754.2687 | |
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 | 137 | 42815009424 | 312518184 | 20904791424 | 708793536 | 47762880 | 42058453008 | 31 | 720 | 23.2258 | 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 |
|