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 | 2451 | 14326464399984 | 5845150608 | 107173599456 | 1177684992 | 379231079040 | 13946055635952 | 8 | 70656 | 8832.0000 | 1500 | 1925632 | 1283.7547 | |
innodb/innodb_data_file | 5317 | 10408446264480 | 1957578744 | 232773667632 | 248759628480 | 130441732608 | 10029244903392 | 1533 | 30228480 | 19718.5127 | 2744 | 96223232 | 35066.7755 | |
innodb/innodb_temp_file | 287 | 1108311670224 | 3861713064 | 176545611792 | 0 | 226189450080 | 882122220144 | 0 | 0 | 0.0000 | 199 | 5750784 | 28898.4121 | |
sql/binlog | 523 | 880968818400 | 1684452792 | 33258571104 | 2687099184 | 4182045648 | 874099673568 | 100 | 996 | 9.9600 | 58 | 17912 | 308.8276 | |
sql/binlog_index | 38 | 51532765680 | 1356125232 | 34473055056 | 1782996864 | 0 | 49749768816 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 31705056768 | 528417384 | 3240814896 | 18494062224 | 0 | 13210994544 | 36 | 3693658 | 102601.6111 | 0 | 0 | 0.0000 | |
sql/io_cache | 408 | 9565905360 | 23445840 | 1518172656 | 2022282768 | 4230676032 | 3312946560 | 204 | 9905848 | 48558.0784 | 164 | 9905848 | 60401.5122 | |
csv/metadata | 8 | 2134113168 | 266764080 | 1088562816 | 1553068704 | 0 | 581044464 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 1959514656 | 244939200 | 1674848208 | 1915306272 | 0 | 44208384 | 4 | 904 | 226.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 848983872 | 56598696 | 786492432 | 0 | 0 | 848983872 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 743253456 | 148650480 | 719409504 | 721411680 | 0 | 21841776 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/data | 7 | 491201040 | 70171464 | 351799536 | 351799536 | 0 | 139401504 | 1 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 15 | 310887984 | 20725848 | 35631024 | 0 | 0 | 310887984 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 295823616 | 98607696 | 275089584 | 275089584 | 0 | 20734032 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 4 | 21192864 | 5298216 | 9114864 | 0 | 0 | 21192864 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 12876864 | 4292112 | 10220496 | 0 | 1995312 | 10881552 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|