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 | 327 | 1727805153888 | 5283807672 | 30156720000 | 1321052832 | 50885002080 | 1675599098976 | 8 | 70656 | 8832.0000 | 191 | 190464 | 997.1937 | |
innodb/innodb_data_file | 1847 | 1487830951200 | 805538976 | 219973344624 | 156476642256 | 21593472384 | 1309760836560 | 1215 | 25018368 | 20591.2494 | 403 | 22822912 | 56632.5360 | |
innodb/innodb_temp_file | 132 | 584744619360 | 4429883304 | 161485579728 | 0 | 225799500960 | 358945118400 | 0 | 0 | 0.0000 | 69 | 1982464 | 28731.3623 | |
sql/binlog | 105 | 95673139584 | 911172504 | 19425226656 | 743879664 | 1007793072 | 93921466848 | 21 | 680 | 32.3810 | 7 | 1157 | 165.2857 | |
sql/binlog_index | 38 | 40752147216 | 1072424760 | 25096424496 | 447914016 | 0 | 40304233200 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 40 | 30312511680 | 757812792 | 5326824624 | 14088249120 | 0 | 16224262560 | 24 | 2466229 | 102759.5417 | 0 | 0 | 0.0000 | |
sql/io_cache | 25 | 13289987040 | 531599376 | 12234967008 | 74056752 | 854028384 | 12361901904 | 9 | 655716 | 72857.3333 | 11 | 655716 | 59610.5455 | |
mysys/cnf | 5 | 3181322496 | 636264288 | 3158828112 | 3160475472 | 0 | 20847024 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 738570096 | 49237848 | 660728112 | 0 | 0 | 738570096 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/metadata | 4 | 618157584 | 154539264 | 530931456 | 530931456 | 0 | 87226128 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 363381216 | 121126896 | 333838032 | 333838032 | 0 | 29543184 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 3 | 18936720 | 6312240 | 11892144 | 0 | 0 | 18936720 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 2 | 16325760 | 8162880 | 9885216 | 0 | 0 | 16325760 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13612368 | 4537368 | 9385200 | 0 | 3596208 | 10016160 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|