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_log_file | 515 | 2.89 s | 5.62 ms | 64.93 ms | 1.76 ms | 76.06 ms | 2.81 s | 8 | 69.00 KiB | 8.62 KiB | 297 | 246.50 KiB | 850 bytes | |
innodb/innodb_data_file | 2570 | 2.86 s | 1.11 ms | 849.86 ms | 265.57 ms | 43.51 ms | 2.56 s | 1504 | 28.38 MiB | 19.32 KiB | 726 | 31.39 MiB | 44.28 KiB | |
innodb/innodb_temp_file | 145 | 778.69 ms | 5.37 ms | 51.84 ms | 0 ps | 4.51 ms | 774.17 ms | 0 | 0 bytes | 0 bytes | 68 | 2.75 MiB | 41.41 KiB | |
sql/binlog | 665 | 75.25 ms | 113.15 us | 19.67 ms | 1.46 ms | 2.32 ms | 71.46 ms | 162 | 1.21 KiB | 8 bytes | 5 | 836 bytes | 167 bytes | |
sql/binlog_index | 38 | 52.90 ms | 1.39 ms | 28.80 ms | 2.06 ms | 0 ps | 50.84 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | |
sql/ERRMSG | 35 | 26.49 ms | 756.94 us | 3.57 ms | 13.78 ms | 0 ps | 12.72 ms | 21 | 2.05 MiB | 99.81 KiB | 0 | 0 bytes | 0 bytes | |
csv/metadata | 8 | 4.50 ms | 562.87 us | 2.35 ms | 1.76 ms | 0 ps | 2.74 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | |
myisam/dfile | 81 | 1.66 ms | 20.54 us | 1.62 ms | 1.64 ms | 0 ps | 27.97 us | 50 | 2.90 KiB | 59 bytes | 0 | 0 bytes | 0 bytes | |
sql/casetest | 15 | 1.24 ms | 82.45 us | 1.17 ms | 0 ps | 0 ps | 1.24 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
myisam/kfile | 4 | 702.83 us | 175.71 us | 680.56 us | 682.63 us | 0 ps | 20.20 us | 2 | 442 bytes | 221 bytes | 0 | 0 bytes | 0 bytes | |
mysys/cnf | 5 | 584.48 us | 116.90 us | 566.14 us | 567.58 us | 0 ps | 16.90 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | |
mysys/charset | 3 | 273.90 us | 91.30 us | 261.00 us | 261.00 us | 0 ps | 12.89 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | |
csv/data | 4 | 110.21 us | 27.55 us | 43.80 us | 0 ps | 0 ps | 110.21 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
sql/pid | 3 | 42.41 us | 14.14 us | 33.65 us | 0 ps | 6.39 us | 36.03 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | |
sql/misc | 1 | 8.58 us | 8.58 us | 8.58 us | 0 ps | 0 ps | 8.58 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes |
|