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 | 3845 | 6.24 s | 0 ps | 1.62 ms | 206.61 ms | 1445 | 27.45 MiB | 19.45 KiB | 1667 | 58.98 MiB | 36.23 KiB | 86.44 MiB | |
innodb/innodb_temp_file | 281 | 909.17 ms | 0 ps | 3.24 ms | 81.74 ms | 0 | 0 bytes | 0 bytes | 201 | 5.02 MiB | 25.55 KiB | 5.02 MiB | |
sql/ERRMSG | 70 | 50.58 ms | 3.14 us | 722.53 us | 3.95 ms | 42 | 4.10 MiB | 100.08 KiB | 0 | 0 bytes | 0 bytes | 4.10 MiB | |
sql/io_cache | 82 | 350.58 ms | 0 ps | 4.28 ms | 250.81 ms | 38 | 1.95 MiB | 52.67 KiB | 34 | 1.95 MiB | 58.87 KiB | 3.91 MiB | |
innodb/innodb_log_file | 1585 | 9.13 s | 232.32 ns | 5.76 ms | 112.81 ms | 8 | 69.00 KiB | 8.62 KiB | 953 | 914.50 KiB | 983 bytes | 983.50 KiB | |
mysys/charset | 3 | 262.25 us | 4.14 us | 87.42 us | 239.86 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 475 | 192.76 ms | 0 ps | 405.81 us | 17.90 ms | 110 | 1.01 KiB | 9 bytes | 14 | 3.79 KiB | 277 bytes | 4.80 KiB | |
myisam/kfile | 8 | 3.15 ms | 644.69 ns | 393.14 us | 2.40 ms | 4 | 904 bytes | 226 bytes | 0 | 0 bytes | 0 bytes | 904 bytes | |
sql/binlog_index | 38 | 46.28 ms | 0 ps | 1.22 ms | 28.62 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 3.26 ms | 543.31 ns | 407.45 us | 1.38 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 2.31 ms | 94.51 ns | 462.47 us | 2.29 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 17.25 us | 1.33 us | 5.75 us | 12.99 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 829.78 us | 0 ps | 55.32 us | 743.86 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 2 | 14.48 us | 0 ps | 7.24 us | 10.61 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 11 | 387.01 us | 0 ps | 35.18 us | 200.89 us | 2 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
myisam/dfile | 12 | 60.26 us | 340.56 ns | 5.02 us | 10.08 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|