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 | 666 | 3290058524016 | 4940027664 | 55941856608 | 991046496 | 74261860464 | 3214805617056 | 8 | 70656 | 8832.0000 | 390 | 327680 | 840.2051 | |
innodb/innodb_data_file | 2585 | 1646578879968 | 636974184 | 166257791568 | 135086385984 | 30954675312 | 1480537818672 | 1427 | 28884992 | 20241.7603 | 809 | 35405824 | 43764.9246 | |
innodb/innodb_temp_file | 380 | 648837996576 | 1707468312 | 31644407520 | 0 | 5688995136 | 643149001440 | 0 | 0 | 0.0000 | 300 | 6881280 | 22937.6000 | |
sql/binlog | 205 | 110879379072 | 540875016 | 19205654160 | 6887191344 | 5553180336 | 98439007392 | 50 | 41331 | 826.6200 | 8 | 1523 | 190.3750 | |
sql/io_cache | 362 | 56261386896 | 155418120 | 20209811952 | 1016968128 | 6048848784 | 49195569984 | 148 | 8921296 | 60279.0270 | 154 | 8921296 | 57930.4935 | |
sql/ERRMSG | 55 | 22748184096 | 413603256 | 3005070816 | 15248655840 | 0 | 7499528256 | 33 | 3378381 | 102375.1818 | 0 | 0 | 0.0000 | |
sql/binlog_index | 23 | 2590743936 | 112640880 | 1499027376 | 908326320 | 0 | 1682417616 | 5 | 160 | 32.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 1382973504 | 92198040 | 1247282784 | 0 | 0 | 1382973504 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 293971920 | 58794384 | 265769328 | 267234528 | 0 | 26737392 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 256581072 | 85527024 | 221153856 | 221153856 | 0 | 35427216 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 5 | 52722912 | 10544424 | 13053216 | 0 | 0 | 52722912 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 19885008 | 6628248 | 16137264 | 0 | 2752464 | 17132544 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 |
|