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 | 120 | 606208925520 | 5051740848 | 37623363360 | 991046496 | 3748113600 | 601469765424 | 8 | 70656 | 8832.0000 | 63 | 76800 | 1219.0476 | |
innodb/innodb_data_file | 1648 | 519805521840 | 315415848 | 166257791568 | 112737940128 | 16773581616 | 390294000096 | 1251 | 26001408 | 20784.4988 | 186 | 15941632 | 85707.6989 | |
innodb/innodb_temp_file | 224 | 375140925984 | 1674736272 | 20502223104 | 0 | 3137080848 | 372003845136 | 0 | 0 | 0.0000 | 160 | 3538944 | 22118.4000 | |
sql/binlog | 91 | 31505473824 | 346213824 | 15048525888 | 4609815936 | 30351552 | 26865306336 | 24 | 41227 | 1717.7917 | 3 | 156 | 52.0000 | |
sql/ERRMSG | 25 | 10285108944 | 411404136 | 3005070816 | 7446008592 | 0 | 2839100352 | 15 | 1524485 | 101632.3333 | 0 | 0 | 0.0000 | |
sql/io_cache | 52 | 6841533072 | 131567832 | 4219855200 | 153650640 | 1616220672 | 5071661760 | 18 | 1315556 | 73086.4444 | 24 | 1315556 | 54814.8333 | |
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/pid | 3 | 19885008 | 6628248 | 16137264 | 0 | 2752464 | 17132544 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 | |
sql/misc | 1 | 6208752 | 6208752 | 6208752 | 0 | 0 | 6208752 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|