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 | 242 | 1239449542260 | 5121692100 | 105733402580 | 826736400 | 33892498300 | 1204730307560 | 8 | 70656 | 8832.0000 | 140 | 153600 | 1097.1429 | |
innodb/innodb_data_file | 2026 | 698678015180 | 344855630 | 75049755890 | 160463671320 | 15182226830 | 523032117030 | 1459 | 29409280 | 20157.1487 | 302 | 19775488 | 65481.7483 | |
innodb/innodb_temp_file | 149 | 448455544610 | 3009768505 | 31832580160 | 0 | 19517009380 | 428938535230 | 0 | 0 | 0.0000 | 81 | 2506752 | 30947.5556 | |
sql/binlog | 119 | 44161992420 | 371109180 | 14779454920 | 4254817210 | 194003320 | 39713171890 | 29 | 35565 | 1226.3793 | 4 | 615 | 153.7500 | |
sql/ERRMSG | 20 | 7365738600 | 368286930 | 1180110720 | 4663042290 | 0 | 2702696310 | 12 | 1218859 | 101571.5833 | 0 | 0 | 0.0000 | |
sql/binlog_index | 23 | 2418022710 | 105131330 | 1829566360 | 2053546480 | 0 | 364476230 | 5 | 224 | 44.8000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 825128910 | 55008435 | 731180050 | 0 | 0 | 825128910 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 296839220 | 98946230 | 283796980 | 283796980 | 0 | 13042240 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 226169550 | 45233910 | 203949830 | 204824330 | 0 | 21345220 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 25406080 | 8468605 | 21804200 | 0 | 2745930 | 22660150 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 | |
sql/misc | 1 | 5530020 | 5530020 | 5530020 | 0 | 0 | 5530020 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|