SELECT * FROM `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_data_file | 1705 | 1.48 s | 870.22 us | 198.94 ms | 235.00 ms | 39.67 ms | 1.21 s | 1192 | 23.50 MiB | 20.19 KiB | 283 | 17.77 MiB | 64.28 KiB | |
innodb/innodb_log_file | 201 | 1.17 s | 5.82 ms | 43.97 ms | 2.07 ms | 18.43 ms | 1.15 s | 8 | 69.00 KiB | 8.62 KiB | 107 | 105.00 KiB | 1005 bytes | |
innodb/innodb_temp_file | 90 | 348.24 ms | 3.87 ms | 25.23 ms | 0 ps | 2.38 ms | 345.86 ms | 0 | 0 bytes | 0 bytes | 30 | 1.09 MiB | 37.33 KiB | |
sql/binlog | 205 | 128.39 ms | 626.30 us | 17.68 ms | 1.23 ms | 688.14 us | 126.48 ms | 45 | 776 bytes | 17 bytes | 9 | 1.65 KiB | 188 bytes | |
sql/ERRMSG | 75 | 101.80 ms | 1.36 ms | 38.78 ms | 30.52 ms | 0 ps | 71.28 ms | 45 | 4.40 MiB | 100.01 KiB | 0 | 0 bytes | 0 bytes | |
sql/binlog_index | 38 | 42.91 ms | 1.13 ms | 21.02 ms | 2.85 ms | 0 ps | 40.07 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | |
sql/casetest | 15 | 908.95 us | 60.60 us | 838.62 us | 0 ps | 0 ps | 908.95 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
myisam/kfile | 12 | 830.30 us | 69.19 us | 693.18 us | 29.05 us | 55.47 us | 745.78 us | 2 | 321 bytes | 160 bytes | 5 | 297 bytes | 59 bytes | |
mysys/cnf | 5 | 547.24 us | 109.45 us | 531.72 us | 533.02 us | 0 ps | 14.22 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | |
mysys/charset | 3 | 263.48 us | 87.83 us | 248.46 us | 248.46 us | 0 ps | 15.02 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | |
sql/SDI | 3 | 194.93 us | 64.98 us | 179.40 us | 0 ps | 12.67 us | 182.25 us | 0 | 0 bytes | 0 bytes | 1 | 3.44 KiB | 3.44 KiB | |
myisam/dfile | 12 | 144.21 us | 12.02 us | 38.31 us | 0 ps | 0 ps | 144.21 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
sql/misc | 6 | 66.92 us | 11.15 us | 13.60 us | 0 ps | 0 ps | 66.92 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
sql/pid | 3 | 47.88 us | 15.96 us | 37.83 us | 0 ps | 7.30 us | 40.58 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes |
|