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 | 2552 | 1.17 s | 0 ps | 458.53 us | 77.56 ms | 1487 | 28.95 MiB | 19.94 KiB | 726 | 31.48 MiB | 44.41 KiB | 60.44 MiB | |
innodb/innodb_temp_file | 215 | 468.08 ms | 0 ps | 2.18 ms | 35.52 ms | 0 | 0 bytes | 0 bytes | 143 | 3.61 MiB | 25.85 KiB | 3.61 MiB | |
sql/ERRMSG | 30 | 16.54 ms | 2.70 us | 551.36 us | 3.36 ms | 18 | 1.77 MiB | 100.61 KiB | 0 | 0 bytes | 0 bytes | 1.77 MiB | |
innodb/innodb_log_file | 555 | 2.81 s | 234.96 ns | 5.07 ms | 119.16 ms | 8 | 69.00 KiB | 8.62 KiB | 325 | 283.00 KiB | 892 bytes | 352.00 KiB | |
sql/binlog | 369 | 112.16 ms | 0 ps | 303.95 us | 16.99 ms | 106 | 206.46 KiB | 1.95 KiB | 8 | 1.51 KiB | 193 bytes | 207.97 KiB | |
mysys/charset | 3 | 357.82 us | 2.20 us | 119.27 us | 344.60 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
myisam/dfile | 81 | 716.52 us | 115.63 ns | 8.85 us | 238.93 us | 50 | 2.90 KiB | 59 bytes | 0 | 0 bytes | 0 bytes | 2.90 KiB | |
myisam/kfile | 24 | 2.06 ms | 376.46 ns | 85.75 us | 882.96 us | 12 | 2.29 KiB | 196 bytes | 0 | 0 bytes | 0 bytes | 2.29 KiB | |
sql/binlog_index | 23 | 970.28 us | 0 ps | 42.19 us | 241.05 us | 5 | 288 bytes | 58 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 1.13 ms | 240.77 ns | 226.49 us | 1.10 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 17.02 us | 918.19 ns | 5.67 us | 13.23 us | 0 | 0 bytes | 0 bytes | 1 | 5 bytes | 5 bytes | 5 bytes | |
sql/casetest | 15 | 982.81 us | 0 ps | 65.52 us | 902.15 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 2 | 21.99 us | 0 ps | 10.99 us | 16.19 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|