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 | 1152 | 7.47 s | 6.48 ms | 839.36 ms | 1.66 ms | 100.46 ms | 7.37 s | 8 | 69.00 KiB | 8.62 KiB | 659 | 474.00 KiB | 737 bytes | |
innodb/innodb_data_file | 3430 | 5.85 s | 1.70 ms | 650.41 ms | 1.01 s | 65.99 ms | 4.77 s | 1558 | 29.22 MiB | 19.20 KiB | 1184 | 43.55 MiB | 37.66 KiB | |
innodb/innodb_temp_file | 155 | 773.56 ms | 4.99 ms | 41.74 ms | 0 ps | 4.06 ms | 769.50 ms | 0 | 0 bytes | 0 bytes | 76 | 3.00 MiB | 40.42 KiB | |
sql/binlog_index | 38 | 84.99 ms | 2.24 ms | 41.11 ms | 2.82 ms | 0 ps | 82.18 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | |
sql/binlog | 287 | 58.70 ms | 204.52 us | 20.51 ms | 1.28 ms | 1.55 ms | 55.87 ms | 68 | 868 bytes | 13 bytes | 4 | 411 bytes | 103 bytes | |
sql/ERRMSG | 50 | 29.28 ms | 585.65 us | 3.49 ms | 14.80 ms | 0 ps | 14.49 ms | 30 | 2.92 MiB | 99.69 KiB | 0 | 0 bytes | 0 bytes | |
myisam/dfile | 48 | 3.48 ms | 72.41 us | 1.89 ms | 3.31 ms | 0 ps | 169.80 us | 27 | 1.07 KiB | 41 bytes | 0 | 0 bytes | 0 bytes | |
myisam/kfile | 12 | 2.73 ms | 227.52 us | 1.73 ms | 2.68 ms | 0 ps | 52.99 us | 6 | 1.28 KiB | 218 bytes | 0 | 0 bytes | 0 bytes | |
sql/casetest | 15 | 962.47 us | 64.16 us | 897.82 us | 0 ps | 0 ps | 962.47 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | |
mysys/cnf | 5 | 456.02 us | 91.20 us | 439.42 us | 440.76 us | 0 ps | 15.26 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | |
mysys/charset | 3 | 305.93 us | 101.98 us | 290.94 us | 290.94 us | 0 ps | 14.98 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | |
sql/pid | 3 | 68.91 us | 22.97 us | 39.68 us | 0 ps | 25.55 us | 43.37 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | |
sql/misc | 2 | 39.34 us | 19.67 us | 34.37 us | 0 ps | 0 ps | 39.34 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes |
|