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 | 2938 | 3.51 s | 0 ps | 1.19 ms | 217.77 ms | 1511 | 28.48 MiB | 19.30 KiB | 924 | 36.61 MiB | 40.57 KiB | 65.09 MiB | |
sql/ERRMSG | 50 | 33.56 ms | 2.86 us | 671.30 us | 2.34 ms | 30 | 2.93 MiB | 100.04 KiB | 0 | 0 bytes | 0 bytes | 2.93 MiB | |
innodb/innodb_temp_file | 133 | 666.36 ms | 0 ps | 5.01 ms | 45.68 ms | 0 | 0 bytes | 0 bytes | 58 | 2.47 MiB | 43.59 KiB | 2.47 MiB | |
sql/io_cache | 15 | 463.30 us | 0 ps | 30.89 us | 219.34 us | 4 | 272.38 KiB | 68.09 KiB | 6 | 268.10 KiB | 44.68 KiB | 540.48 KiB | |
innodb/innodb_log_file | 891 | 5.13 s | 234.43 ns | 5.76 ms | 66.50 ms | 8 | 69.00 KiB | 8.62 KiB | 512 | 390.50 KiB | 781 bytes | 459.50 KiB | |
mysys/charset | 3 | 279.85 us | 1.91 us | 93.28 us | 264.75 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
myisam/kfile | 12 | 4.03 ms | 670.56 ns | 335.94 us | 3.09 ms | 6 | 1.27 KiB | 216 bytes | 0 | 0 bytes | 0 bytes | 1.27 KiB | |
sql/binlog | 187 | 61.25 ms | 0 ps | 327.55 us | 21.87 ms | 43 | 768 bytes | 18 bytes | 4 | 417 bytes | 104 bytes | 1.16 KiB | |
sql/binlog_index | 38 | 46.62 ms | 0 ps | 1.23 ms | 29.61 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
myisam/dfile | 17 | 443.63 us | 403.92 ns | 26.10 us | 299.59 us | 2 | 123 bytes | 62 bytes | 0 | 0 bytes | 0 bytes | 123 bytes | |
csv/metadata | 8 | 2.09 ms | 865.39 ns | 261.50 us | 1.14 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 1.61 ms | 398.11 ns | 322.68 us | 1.60 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 12.72 us | 981.02 ns | 4.24 us | 10.03 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 794.79 us | 0 ps | 52.99 us | 729.27 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 2 | 684.44 us | 0 ps | 342.22 us | 680.22 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 20 | 148.01 us | 0 ps | 7.40 us | 38.68 us | 7 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|