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 | 154 | 1499517924960 | 9737129160 | 717030866640 | 1614269712 | 8093295936 | 1489810359312 | 8 | 70656 | 8832.0000 | 82 | 94208 | 1148.8780 | |
innodb/innodb_data_file | 1571 | 748066514976 | 476172048 | 211144270656 | 241278833136 | 14889324384 | 491898357456 | 1204 | 24838144 | 20629.6877 | 203 | 16564224 | 81597.1626 | |
innodb/innodb_temp_file | 93 | 375588665232 | 4038587784 | 27111724992 | 0 | 2185437408 | 373403227824 | 0 | 0 | 0.0000 | 32 | 1245184 | 38912.0000 | |
sql/binlog | 61 | 55551174096 | 910674864 | 31939194144 | 3690890544 | 58033008 | 51802250544 | 12 | 644 | 53.6667 | 3 | 156 | 52.0000 | |
sql/binlog_index | 38 | 45109199520 | 1187084184 | 23757075936 | 2394029088 | 0 | 42715170432 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 25 | 9974589504 | 398983464 | 1315595952 | 7372289232 | 0 | 2602300272 | 15 | 1535694 | 102379.6000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1724188224 | 344837592 | 1706480688 | 1707686640 | 0 | 16501584 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/io_cache | 48 | 1638731952 | 34140216 | 292758048 | 147382752 | 833463312 | 657885888 | 17 | 1206270 | 70957.0588 | 21 | 1206270 | 57441.4286 | |
sql/casetest | 15 | 937508352 | 62500416 | 864433680 | 0 | 0 | 937508352 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 283031760 | 94343832 | 273067872 | 273067872 | 0 | 9963888 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 52974768 | 17658168 | 35296800 | 0 | 14873232 | 38101536 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
sql/misc | 1 | 4963200 | 4963200 | 4963200 | 0 | 0 | 4963200 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|