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 | 3677 | 2.87 s | 0 ps | 780.98 us | 77.56 ms | 1637 | 31.30 MiB | 19.58 KiB | 1514 | 54.95 MiB | 37.17 KiB | 86.25 MiB | |
innodb/innodb_temp_file | 392 | 717.13 ms | 0 ps | 1.83 ms | 35.52 ms | 0 | 0 bytes | 0 bytes | 303 | 7.17 MiB | 24.24 KiB | 7.17 MiB | |
sql/ERRMSG | 35 | 18.94 ms | 2.70 us | 541.10 us | 3.36 ms | 21 | 2.06 MiB | 100.49 KiB | 0 | 0 bytes | 0 bytes | 2.06 MiB | |
sql/io_cache | 38 | 795.17 us | 0 ps | 20.93 us | 61.12 us | 10 | 1002.57 KiB | 100.26 KiB | 18 | 1002.57 KiB | 55.70 KiB | 1.96 MiB | |
innodb/innodb_log_file | 1157 | 5.78 s | 234.96 ns | 5.00 ms | 119.16 ms | 8 | 69.00 KiB | 8.62 KiB | 688 | 611.50 KiB | 910 bytes | 680.50 KiB | |
sql/binlog | 1081 | 178.90 ms | 0 ps | 165.49 us | 19.98 ms | 282 | 207.15 KiB | 752 bytes | 12 | 3.18 KiB | 271 bytes | 210.33 KiB | |
mysys/charset | 3 | 357.82 us | 2.20 us | 119.27 us | 344.60 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
myisam/dfile | 81 | 716.52 us | 115.63 ns | 8.85 us | 238.93 us | 50 | 2.90 KiB | 59 bytes | 0 | 0 bytes | 0 bytes | 2.90 KiB | |
myisam/kfile | 24 | 2.06 ms | 376.46 ns | 85.75 us | 882.96 us | 12 | 2.29 KiB | 196 bytes | 0 | 0 bytes | 0 bytes | 2.29 KiB | |
sql/binlog_index | 23 | 970.28 us | 0 ps | 42.19 us | 241.05 us | 5 | 288 bytes | 58 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 1.13 ms | 240.77 ns | 226.49 us | 1.10 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 17.02 us | 918.19 ns | 5.67 us | 13.23 us | 0 | 0 bytes | 0 bytes | 1 | 5 bytes | 5 bytes | 5 bytes | |
sql/casetest | 15 | 982.81 us | 0 ps | 65.52 us | 902.15 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 2 | 21.99 us | 0 ps | 10.99 us | 16.19 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|