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 | 1722 | 9.06 s | 5.26 ms | 889.89 ms | 1.32 ms | 1.23 s | 7.83 s | 8 | 69.00 KiB | 8.62 KiB | 1184 | 2.20 MiB | 1.91 KiB | |
innodb/innodb_data_file | 2911 | 3.13 s | 1.07 ms | 494.58 ms | 250.64 ms | 51.90 ms | 2.82 s | 1359 | 26.11 MiB | 19.67 KiB | 998 | 39.64 MiB | 40.67 KiB | |
sql/binlog | 429 | 540.67 ms | 1.26 ms | 22.41 ms | 972.38 us | 1.62 ms | 538.08 ms | 85 | 936 bytes | 11 bytes | 41 | 8.38 KiB | 209 bytes | |
innodb/innodb_temp_file | 102 | 461.72 ms | 4.53 ms | 42.43 ms | 0 ps | 2.73 ms | 458.99 ms | 0 | 0 bytes | 0 bytes | 39 | 1.42 MiB | 37.33 KiB | |
sql/binlog_index | 38 | 47.86 ms | 1.26 ms | 28.47 ms | 541.71 us | 0 ps | 47.32 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | |
sql/ERRMSG | 80 | 44.66 ms | 558.31 us | 5.07 ms | 22.48 ms | 0 ps | 22.19 ms | 48 | 4.69 MiB | 99.95 KiB | 0 | 0 bytes | 0 bytes | |
sql/casetest | 15 | 1.25 ms | 83.60 us | 1.20 ms | 0 ps | 0 ps | 1.25 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
csv/metadata | 8 | 1.19 ms | 148.71 us | 503.36 us | 717.60 us | 0 ps | 472.07 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | |
myisam/kfile | 4 | 1.18 ms | 296.14 us | 1.12 ms | 0 ps | 0 ps | 1.18 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
mysys/cnf | 5 | 810.54 us | 162.11 us | 787.42 us | 789.14 us | 0 ps | 21.40 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | |
mysys/charset | 3 | 311.03 us | 103.68 us | 297.57 us | 297.57 us | 0 ps | 13.46 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | |
csv/data | 4 | 258.98 us | 64.74 us | 189.92 us | 0 ps | 0 ps | 258.98 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
myisam/dfile | 4 | 250.30 us | 62.57 us | 223.82 us | 0 ps | 0 ps | 250.30 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
sql/misc | 5 | 91.23 us | 18.25 us | 49.07 us | 0 ps | 0 ps | 91.23 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
sql/pid | 3 | 45.71 us | 15.24 us | 35.33 us | 0 ps | 7.57 us | 38.14 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes |
|