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 | 1539 | 6.00 s | 3.90 ms | 62.37 ms | 1.87 ms | 239.38 ms | 5.76 s | 8 | 69.00 KiB | 8.62 KiB | 1069 | 2.05 MiB | 1.96 KiB | |
innodb/innodb_data_file | 2828 | 2.52 s | 891.86 us | 253.79 ms | 290.58 ms | 71.95 ms | 2.16 s | 1299 | 25.17 MiB | 19.84 KiB | 985 | 39.14 MiB | 40.69 KiB | |
innodb/innodb_temp_file | 186 | 572.09 ms | 3.08 ms | 50.09 ms | 0 ps | 39.08 ms | 533.00 ms | 0 | 0 bytes | 0 bytes | 123 | 2.73 MiB | 22.76 KiB | |
sql/binlog | 407 | 481.57 ms | 1.18 ms | 24.51 ms | 1.19 ms | 1.73 ms | 478.64 ms | 82 | 924 bytes | 11 bytes | 36 | 7.01 KiB | 199 bytes | |
sql/ERRMSG | 80 | 48.13 ms | 601.66 us | 3.83 ms | 27.29 ms | 0 ps | 20.84 ms | 48 | 4.69 MiB | 99.97 KiB | 0 | 0 bytes | 0 bytes | |
sql/binlog_index | 38 | 44.88 ms | 1.18 ms | 25.45 ms | 844.22 us | 0 ps | 44.03 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | |
sql/io_cache | 60 | 1.90 ms | 31.70 us | 310.55 us | 139.60 us | 1.02 ms | 746.30 us | 16 | 1.12 MiB | 71.77 KiB | 24 | 1.12 MiB | 47.85 KiB | |
mysys/cnf | 5 | 1.19 ms | 237.01 us | 1.16 ms | 1.17 ms | 0 ps | 18.65 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | |
sql/casetest | 15 | 897.51 us | 59.83 us | 832.19 us | 0 ps | 0 ps | 897.51 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
myisam/dfile | 4 | 482.25 us | 120.56 us | 449.40 us | 0 ps | 0 ps | 482.25 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
mysys/charset | 3 | 305.80 us | 101.93 us | 295.10 us | 295.10 us | 0 ps | 10.70 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | |
myisam/kfile | 4 | 250.73 us | 62.68 us | 160.36 us | 0 ps | 0 ps | 250.73 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
sql/misc | 3 | 53.95 us | 17.98 us | 29.52 us | 0 ps | 0 ps | 53.95 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
sql/pid | 3 | 18.99 us | 6.33 us | 15.00 us | 0 ps | 3.02 us | 15.97 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes |
|