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 | 767 | 4.25 s | 5.54 ms | 113.22 ms | 1.60 ms | 192.34 ms | 4.06 s | 8 | 69.00 KiB | 8.62 KiB | 457 | 402.50 KiB | 902 bytes | |
innodb/innodb_data_file | 2613 | 2.14 s | 818.08 us | 241.35 ms | 219.20 ms | 43.45 ms | 1.87 s | 1423 | 27.11 MiB | 19.51 KiB | 872 | 35.80 MiB | 42.04 KiB | |
innodb/innodb_temp_file | 117 | 550.54 ms | 4.71 ms | 27.98 ms | 0 ps | 3.79 ms | 546.76 ms | 0 | 0 bytes | 0 bytes | 48 | 1.94 MiB | 41.33 KiB | |
sql/binlog | 287 | 103.38 ms | 360.21 us | 17.27 ms | 1.62 ms | 868.92 us | 100.89 ms | 66 | 860 bytes | 13 bytes | 8 | 1.33 KiB | 171 bytes | |
sql/binlog_index | 38 | 59.07 ms | 1.55 ms | 41.43 ms | 686.17 us | 0 ps | 58.38 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | |
sql/ERRMSG | 90 | 58.18 ms | 646.48 us | 5.97 ms | 31.76 ms | 0 ps | 26.43 ms | 54 | 5.26 MiB | 99.84 KiB | 0 | 0 bytes | 0 bytes | |
csv/data | 6 | 2.00 ms | 332.78 us | 1.94 ms | 33.25 us | 0 ps | 1.96 ms | 1 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
sql/misc | 3 | 1.77 ms | 589.00 us | 1.74 ms | 0 ps | 0 ps | 1.77 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
sql/casetest | 15 | 1.11 ms | 74.11 us | 1.05 ms | 0 ps | 0 ps | 1.11 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
mysys/cnf | 5 | 1.06 ms | 211.75 us | 1.04 ms | 1.04 ms | 0 ps | 16.85 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | |
csv/metadata | 8 | 792.77 us | 99.10 us | 385.66 us | 614.71 us | 0 ps | 178.07 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | |
mysys/charset | 3 | 319.57 us | 106.52 us | 305.06 us | 305.06 us | 0 ps | 14.51 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | |
sql/pid | 3 | 20.33 us | 6.78 us | 16.43 us | 0 ps | 2.84 us | 17.48 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes |
|