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 | 3199 | 3.04 s | 0 ps | 950.37 us | 209.17 ms | 1397 | 26.70 MiB | 19.57 KiB | 1418 | 52.27 MiB | 37.74 KiB | 78.97 MiB | |
sql/io_cache | 802 | 183.09 ms | 0 ps | 228.29 us | 70.10 ms | 380 | 18.72 MiB | 50.44 KiB | 322 | 18.72 MiB | 59.53 KiB | 37.44 MiB | |
innodb/innodb_temp_file | 734 | 823.33 ms | 0 ps | 1.12 ms | 51.11 ms | 0 | 0 bytes | 0 bytes | 658 | 11.91 MiB | 18.53 KiB | 11.91 MiB | |
sql/ERRMSG | 60 | 36.99 ms | 3.59 us | 616.51 us | 2.41 ms | 36 | 3.52 MiB | 100.02 KiB | 0 | 0 bytes | 0 bytes | 3.52 MiB | |
innodb/innodb_log_file | 1095 | 5.49 s | 245.52 ns | 5.02 ms | 38.56 ms | 8 | 69.00 KiB | 8.62 KiB | 653 | 505.00 KiB | 792 bytes | 574.00 KiB | |
mysys/charset | 3 | 311.31 us | 3.60 us | 103.77 us | 246.52 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 1065 | 67.34 ms | 0 ps | 63.23 us | 31.22 ms | 263 | 1.61 KiB | 6 bytes | 3 | 156 bytes | 52 bytes | 1.76 KiB | |
myisam/kfile | 4 | 2.73 ms | 489.98 ns | 681.56 us | 2.71 ms | 2 | 442 bytes | 221 bytes | 0 | 0 bytes | 0 bytes | 442 bytes | |
sql/binlog_index | 38 | 48.79 ms | 0 ps | 1.28 ms | 31.10 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 5.59 ms | 298.32 ns | 1.12 ms | 5.57 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
csv/metadata | 4 | 855.57 us | 906.58 ns | 213.89 us | 666.22 us | 1 | 35 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 35 bytes | |
sql/pid | 3 | 19.81 us | 907.10 ns | 6.60 us | 15.31 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 1.07 ms | 0 ps | 71.66 us | 956.08 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 1 | 4.33 us | 0 ps | 4.33 us | 4.33 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 2 | 21.35 us | 0 ps | 10.68 us | 13.98 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
myisam/dfile | 2 | 7.40 us | 838.46 ns | 3.70 us | 6.56 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|