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 | 3655 | 6.40 s | 0 ps | 1.75 ms | 255.29 ms | 1476 | 27.94 MiB | 19.38 KiB | 1407 | 50.20 MiB | 36.54 KiB | 78.14 MiB | |
innodb/innodb_temp_file | 248 | 1.36 s | 0 ps | 5.48 ms | 146.95 ms | 0 | 0 bytes | 0 bytes | 148 | 5.44 MiB | 37.62 KiB | 5.44 MiB | |
sql/ERRMSG | 65 | 394.57 ms | 3.33 us | 6.07 ms | 339.99 ms | 39 | 3.81 MiB | 100.13 KiB | 0 | 0 bytes | 0 bytes | 3.81 MiB | |
sql/io_cache | 60 | 2.02 ms | 0 ps | 33.61 us | 612.86 us | 16 | 1.06 MiB | 68.09 KiB | 24 | 1.05 MiB | 44.68 KiB | 2.11 MiB | |
innodb/innodb_log_file | 1425 | 8.43 s | 249.22 ns | 5.91 ms | 105.66 ms | 8 | 69.00 KiB | 8.62 KiB | 820 | 655.00 KiB | 818 bytes | 724.00 KiB | |
mysys/charset | 3 | 212.44 us | 1.59 us | 70.81 us | 197.19 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 509 | 88.07 ms | 0 ps | 173.02 us | 15.06 ms | 122 | 1.06 KiB | 9 bytes | 7 | 1.70 KiB | 248 bytes | 2.75 KiB | |
myisam/kfile | 12 | 2.20 ms | 640.46 ns | 183.10 us | 1.16 ms | 6 | 1.27 KiB | 216 bytes | 0 | 0 bytes | 0 bytes | 1.27 KiB | |
sql/binlog_index | 38 | 42.88 ms | 0 ps | 1.13 ms | 26.08 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
myisam/dfile | 18 | 406.20 us | 258.19 ns | 22.57 us | 298.66 us | 1 | 261 bytes | 261 bytes | 0 | 0 bytes | 0 bytes | 261 bytes | |
csv/metadata | 8 | 952.83 us | 801.50 ns | 119.10 us | 386.52 us | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 419.33 us | 190.61 ns | 83.86 us | 401.88 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 28.26 us | 662.64 ns | 9.42 us | 23.73 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 827.38 us | 0 ps | 55.16 us | 750.01 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 2 | 19.17 us | 0 ps | 9.59 us | 14.79 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 56 | 1.05 ms | 0 ps | 18.79 us | 663.31 us | 21 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|