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 | 2670 | 2.78 s | 0 ps | 1.04 ms | 217.77 ms | 1499 | 28.30 MiB | 19.33 KiB | 728 | 30.95 MiB | 43.54 KiB | 59.25 MiB | |
innodb/innodb_temp_file | 130 | 635.12 ms | 0 ps | 4.89 ms | 45.68 ms | 0 | 0 bytes | 0 bytes | 56 | 2.38 MiB | 43.43 KiB | 2.38 MiB | |
sql/ERRMSG | 40 | 23.98 ms | 2.86 us | 599.52 us | 2.24 ms | 24 | 2.35 MiB | 100.31 KiB | 0 | 0 bytes | 0 bytes | 2.35 MiB | |
sql/io_cache | 15 | 463.30 us | 0 ps | 30.89 us | 219.34 us | 4 | 272.38 KiB | 68.09 KiB | 6 | 268.10 KiB | 44.68 KiB | 540.48 KiB | |
innodb/innodb_log_file | 744 | 4.29 s | 234.43 ns | 5.76 ms | 66.50 ms | 8 | 69.00 KiB | 8.62 KiB | 429 | 330.50 KiB | 789 bytes | 399.50 KiB | |
mysys/charset | 3 | 279.85 us | 1.91 us | 93.28 us | 264.75 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
myisam/kfile | 12 | 4.03 ms | 670.56 ns | 335.94 us | 3.09 ms | 6 | 1.27 KiB | 216 bytes | 0 | 0 bytes | 0 bytes | 1.27 KiB | |
sql/binlog | 125 | 31.40 ms | 0 ps | 251.19 us | 15.72 ms | 28 | 708 bytes | 25 bytes | 3 | 156 bytes | 52 bytes | 864 bytes | |
sql/binlog_index | 38 | 46.62 ms | 0 ps | 1.23 ms | 29.61 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
myisam/dfile | 16 | 434.55 us | 403.92 ns | 27.16 us | 299.59 us | 2 | 123 bytes | 62 bytes | 0 | 0 bytes | 0 bytes | 123 bytes | |
csv/metadata | 8 | 2.09 ms | 865.39 ns | 261.50 us | 1.14 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 1.61 ms | 398.11 ns | 322.68 us | 1.60 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 12.72 us | 981.02 ns | 4.24 us | 10.03 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 794.79 us | 0 ps | 52.99 us | 729.27 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 1 | 4.22 us | 0 ps | 4.22 us | 4.22 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 20 | 148.01 us | 0 ps | 7.40 us | 38.68 us | 7 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|