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 | 3843 | 4.36 s | 0 ps | 1.14 ms | 212.11 ms | 1571 | 29.42 MiB | 19.18 KiB | 1758 | 63.02 MiB | 36.71 KiB | 92.44 MiB | |
sql/io_cache | 1020 | 77.99 ms | 0 ps | 76.46 us | 22.97 ms | 520 | 22.94 MiB | 45.17 KiB | 400 | 22.94 MiB | 58.72 KiB | 45.87 MiB | |
innodb/innodb_temp_file | 961 | 1.99 s | 0 ps | 2.07 ms | 523.08 ms | 0 | 0 bytes | 0 bytes | 834 | 17.84 MiB | 21.91 KiB | 17.84 MiB | |
sql/ERRMSG | 70 | 42.37 ms | 2.97 us | 605.35 us | 5.76 ms | 42 | 4.10 MiB | 100.06 KiB | 0 | 0 bytes | 0 bytes | 4.10 MiB | |
innodb/innodb_log_file | 1704 | 9.76 s | 233.90 ns | 5.73 ms | 606.31 ms | 8 | 69.00 KiB | 8.62 KiB | 1046 | 989.50 KiB | 969 bytes | 1.03 MiB | |
mysys/charset | 3 | 194.31 us | 1.45 us | 64.77 us | 180.99 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 338 | 227.04 ms | 0 ps | 671.72 us | 23.14 ms | 76 | 1.02 KiB | 14 bytes | 15 | 4.06 KiB | 277 bytes | 5.08 KiB | |
myisam/kfile | 8 | 1.18 ms | 679.01 ns | 147.84 us | 646.83 us | 4 | 834 bytes | 208 bytes | 0 | 0 bytes | 0 bytes | 834 bytes | |
sql/binlog_index | 38 | 51.09 ms | 0 ps | 1.34 ms | 33.56 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 681.05 us | 720.19 ns | 85.13 us | 435.77 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 1.33 ms | 163.68 ns | 265.84 us | 1.31 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 14.64 us | 619.87 ns | 4.88 us | 12.22 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 853.15 us | 0 ps | 56.88 us | 783.24 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 5 | 61.22 us | 0 ps | 12.24 us | 26.15 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 9 | 483.67 us | 0 ps | 53.74 us | 303.90 us | 2 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
myisam/dfile | 4 | 17.39 us | 368.54 ns | 4.35 us | 9.47 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|