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 | 376 | 1.98 s | 5.26 ms | 46.71 ms | 1.49 ms | 39.26 ms | 1.94 s | 8 | 69.00 KiB | 8.62 KiB | 212 | 201.00 KiB | 971 bytes | |
innodb/innodb_data_file | 2584 | 1.63 s | 631.17 us | 73.97 ms | 237.79 ms | 17.29 ms | 1.38 s | 1584 | 30.61 MiB | 19.79 KiB | 586 | 26.89 MiB | 46.99 KiB | |
innodb/innodb_temp_file | 438 | 766.35 ms | 1.75 ms | 36.86 ms | 0 ps | 5.31 ms | 761.04 ms | 0 | 0 bytes | 0 bytes | 349 | 7.89 MiB | 23.15 KiB | |
sql/binlog | 423 | 71.47 ms | 168.96 us | 22.49 ms | 5.39 ms | 913.62 us | 65.16 ms | 106 | 50.71 KiB | 490 bytes | 5 | 743 bytes | 149 bytes | |
sql/io_cache | 368 | 46.52 ms | 126.41 us | 20.44 ms | 1.51 ms | 5.01 ms | 40.01 ms | 164 | 8.65 MiB | 54.00 KiB | 154 | 8.65 MiB | 57.51 KiB | |
sql/ERRMSG | 70 | 34.27 ms | 489.63 us | 3.92 ms | 17.79 ms | 0 ps | 16.49 ms | 42 | 4.10 MiB | 99.97 KiB | 0 | 0 bytes | 0 bytes | |
sql/binlog_index | 23 | 2.66 ms | 115.58 us | 1.61 ms | 1.92 ms | 0 ps | 736.99 us | 5 | 224 bytes | 45 bytes | 0 | 0 bytes | 0 bytes | |
mysys/cnf | 5 | 1.20 ms | 240.27 us | 1.18 ms | 1.19 ms | 0 ps | 16.33 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | |
sql/casetest | 15 | 888.02 us | 59.20 us | 831.64 us | 0 ps | 0 ps | 888.02 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
mysys/charset | 3 | 182.86 us | 60.95 us | 174.34 us | 174.34 us | 0 ps | 8.52 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | |
sql/pid | 3 | 44.90 us | 14.97 us | 35.30 us | 0 ps | 7.14 us | 37.76 us | 0 | 0 bytes | 0 bytes | 1 | 5 bytes | 5 bytes | |
sql/misc | 2 | 16.75 us | 8.38 us | 8.87 us | 0 ps | 0 ps | 16.75 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes |
|