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 | 3150 | 4.53 s | 0 ps | 1.44 ms | 208.08 ms | 1600 | 29.88 MiB | 19.12 KiB | 955 | 36.98 MiB | 39.66 KiB | 66.86 MiB | |
sql/io_cache | 1359 | 228.22 ms | 0 ps | 167.93 us | 174.45 ms | 562 | 30.77 MiB | 56.07 KiB | 562 | 30.77 MiB | 56.06 KiB | 61.54 MiB | |
innodb/innodb_temp_file | 462 | 1.19 s | 0 ps | 2.58 ms | 60.77 ms | 0 | 0 bytes | 0 bytes | 363 | 8.73 MiB | 24.64 KiB | 8.73 MiB | |
sql/ERRMSG | 50 | 36.45 ms | 2.84 us | 728.97 us | 4.11 ms | 30 | 2.94 MiB | 100.39 KiB | 0 | 0 bytes | 0 bytes | 2.94 MiB | |
innodb/innodb_log_file | 829 | 4.98 s | 229.15 ns | 6.01 ms | 35.66 ms | 8 | 69.00 KiB | 8.62 KiB | 469 | 346.50 KiB | 757 bytes | 415.50 KiB | |
mysys/charset | 3 | 238.38 us | 2.11 us | 79.46 us | 226.37 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 379 | 36.93 ms | 0 ps | 97.45 us | 15.70 ms | 93 | 1.23 KiB | 14 bytes | 3 | 156 bytes | 52 bytes | 1.38 KiB | |
myisam/kfile | 12 | 1.08 ms | 657.89 ns | 90.30 us | 552.61 us | 6 | 1.23 KiB | 210 bytes | 0 | 0 bytes | 0 bytes | 1.23 KiB | |
sql/binlog_index | 38 | 63.37 ms | 0 ps | 1.67 ms | 44.96 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 10.58 ms | 1.36 us | 1.32 ms | 9.00 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 2.35 ms | 182.69 ns | 470.40 us | 2.34 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 69.07 us | 4.64 us | 23.02 us | 53.66 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 835.14 us | 0 ps | 55.68 us | 758.28 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 1 | 5.32 us | 0 ps | 5.32 us | 5.32 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 4 | 700.35 us | 0 ps | 175.09 us | 574.07 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
myisam/dfile | 7 | 72.87 us | 360.10 ns | 10.41 us | 29.82 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|