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 | 3706 | 5.61 s | 0 ps | 1.51 ms | 206.61 ms | 1445 | 27.45 MiB | 19.45 KiB | 1589 | 57.05 MiB | 36.76 KiB | 84.50 MiB | |
sql/ERRMSG | 60 | 46.04 ms | 3.14 us | 767.34 us | 3.95 ms | 36 | 3.51 MiB | 99.94 KiB | 0 | 0 bytes | 0 bytes | 3.51 MiB | |
innodb/innodb_temp_file | 184 | 817.81 ms | 0 ps | 4.44 ms | 81.74 ms | 0 | 0 bytes | 0 bytes | 107 | 3.36 MiB | 32.15 KiB | 3.36 MiB | |
innodb/innodb_log_file | 1484 | 8.43 s | 232.32 ns | 5.68 ms | 112.81 ms | 8 | 69.00 KiB | 8.62 KiB | 898 | 878.50 KiB | 1002 bytes | 947.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 | 339 | 191.95 ms | 0 ps | 566.23 us | 17.90 ms | 76 | 900 bytes | 12 bytes | 14 | 3.79 KiB | 277 bytes | 4.67 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 |
|