SELECT * FROM `io_global_by_wait_by_bytes`
|
event_name | total | total_latency | min_latency | avg_latency | max_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | total_requested | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_data_file | 3042 | 4.96 s | 0 ps | 1.63 ms | 281.48 ms | 1334 | 25.72 MiB | 19.74 KiB | 1175 | 44.36 MiB | 38.66 KiB | 70.08 MiB | |
innodb/innodb_temp_file | 337 | 1.84 s | 0 ps | 5.47 ms | 70.79 ms | 0 | 0 bytes | 0 bytes | 220 | 7.62 MiB | 35.49 KiB | 7.62 MiB | |
sql/io_cache | 102 | 7.15 ms | 0 ps | 70.06 us | 4.08 ms | 42 | 2.25 MiB | 54.76 KiB | 40 | 2.25 MiB | 57.50 KiB | 4.49 MiB | |
sql/ERRMSG | 65 | 45.42 ms | 2.76 us | 698.77 us | 9.28 ms | 39 | 3.81 MiB | 99.93 KiB | 0 | 0 bytes | 0 bytes | 3.81 MiB | |
innodb/innodb_log_file | 1025 | 6.20 s | 227.57 ns | 6.05 ms | 117.17 ms | 8 | 69.00 KiB | 8.62 KiB | 603 | 572.50 KiB | 972 bytes | 641.50 KiB | |
mysys/charset | 3 | 341.59 us | 2.27 us | 113.86 us | 319.85 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 701 | 416.16 ms | 0 ps | 593.67 us | 26.44 ms | 160 | 1.21 KiB | 8 bytes | 27 | 7.51 KiB | 285 bytes | 8.72 KiB | |
myisam/dfile | 80 | 224.53 us | 93.98 ns | 2.81 us | 193.03 us | 50 | 2.90 KiB | 59 bytes | 0 | 0 bytes | 0 bytes | 2.90 KiB | |
myisam/kfile | 4 | 711.88 us | 843.22 ns | 177.97 us | 684.32 us | 2 | 442 bytes | 221 bytes | 0 | 0 bytes | 0 bytes | 442 bytes | |
sql/binlog_index | 38 | 82.21 ms | 0 ps | 2.16 ms | 53.06 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 14.34 ms | 244.46 ns | 2.87 ms | 14.32 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
csv/metadata | 4 | 661.64 us | 663.70 ns | 165.41 us | 601.39 us | 1 | 35 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 35 bytes | |
sql/pid | 3 | 24.52 us | 780.91 ns | 8.17 us | 17.73 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 967.20 us | 0 ps | 64.48 us | 881.86 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 6 | 2.51 ms | 0 ps | 419.04 us | 1.82 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 23 | 547.43 us | 0 ps | 23.80 us | 266.23 us | 9 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|