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 | 853 | 4236820832112 | 4966964376 | 55941856608 | 991046496 | 92427140784 | 4143402644832 | 8 | 70656 | 8832.0000 | 501 | 429568 | 857.4212 | |
innodb/innodb_data_file | 2899 | 2190745464336 | 755689968 | 166257791568 | 136021513584 | 37095176976 | 2017628773776 | 1431 | 28950528 | 20230.9769 | 1063 | 43335680 | 40767.3377 | |
innodb/innodb_temp_file | 571 | 718783125984 | 1258814568 | 31644407520 | 0 | 7541481552 | 711241644432 | 0 | 0 | 0.0000 | 486 | 10256384 | 21103.6708 | |
sql/binlog | 271 | 192604851648 | 710718888 | 19623857088 | 7319157648 | 6142958448 | 179142735552 | 64 | 41387 | 646.6719 | 13 | 2961 | 227.7692 | |
sql/io_cache | 362 | 56261386896 | 155418120 | 20209811952 | 1016968128 | 6048848784 | 49195569984 | 148 | 8921296 | 60279.0270 | 154 | 8921296 | 57930.4935 | |
sql/ERRMSG | 60 | 24675963840 | 411266064 | 3005070816 | 16086820992 | 0 | 8589142848 | 36 | 3683667 | 102324.0833 | 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 | 9 | 107116944 | 11901648 | 14464032 | 0 | 0 | 107116944 | 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 |
|