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 | 3403 | 4.72 s | 0 ps | 1.39 ms | 224.41 ms | 1573 | 29.45 MiB | 19.17 KiB | 1213 | 45.02 MiB | 38.00 KiB | 74.47 MiB | |
innodb/innodb_temp_file | 143 | 740.26 ms | 0 ps | 5.18 ms | 36.42 ms | 0 | 0 bytes | 0 bytes | 67 | 2.67 MiB | 40.84 KiB | 2.67 MiB | |
sql/ERRMSG | 40 | 31.65 ms | 3.03 us | 791.23 us | 3.89 ms | 24 | 2.35 MiB | 100.07 KiB | 0 | 0 bytes | 0 bytes | 2.35 MiB | |
sql/io_cache | 30 | 1.33 ms | 0 ps | 44.25 us | 811.67 us | 8 | 544.75 KiB | 68.09 KiB | 12 | 536.21 KiB | 44.68 KiB | 1.06 MiB | |
innodb/innodb_log_file | 1067 | 6.27 s | 217.54 ns | 5.88 ms | 117.14 ms | 8 | 69.00 KiB | 8.62 KiB | 609 | 452.50 KiB | 761 bytes | 521.50 KiB | |
mysys/charset | 3 | 333.86 us | 2.42 us | 111.29 us | 318.01 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
myisam/kfile | 16 | 3.20 ms | 525.89 ns | 200.20 us | 2.31 ms | 8 | 1.66 KiB | 213 bytes | 0 | 0 bytes | 0 bytes | 1.66 KiB | |
sql/binlog | 307 | 58.11 ms | 0 ps | 189.29 us | 23.02 ms | 73 | 888 bytes | 12 bytes | 4 | 400 bytes | 100 bytes | 1.26 KiB | |
myisam/dfile | 39 | 334.03 us | 177.94 ns | 8.56 us | 270.28 us | 25 | 975 bytes | 39 bytes | 0 | 0 bytes | 0 bytes | 975 bytes | |
sql/binlog_index | 38 | 55.20 ms | 0 ps | 1.45 ms | 29.42 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 8.17 ms | 694.85 ns | 1.02 ms | 5.75 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 1.10 ms | 296.21 ns | 219.63 us | 1.08 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 56.95 us | 3.20 us | 18.98 us | 36.71 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 836.29 us | 0 ps | 55.75 us | 755.94 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 2 | 24.94 us | 0 ps | 12.47 us | 12.81 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 35 | 443.47 us | 0 ps | 12.67 us | 142.32 us | 13 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|