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 | 3153 | 4.75 s | 0 ps | 1.51 ms | 627.39 ms | 1503 | 28.36 MiB | 19.32 KiB | 1149 | 44.05 MiB | 39.26 KiB | 72.41 MiB | |
sql/io_cache | 320 | 19.62 ms | 0 ps | 61.30 us | 6.65 ms | 156 | 7.02 MiB | 46.10 KiB | 124 | 7.02 MiB | 57.99 KiB | 14.05 MiB | |
innodb/innodb_temp_file | 301 | 591.75 ms | 0 ps | 1.97 ms | 47.23 ms | 0 | 0 bytes | 0 bytes | 231 | 4.86 MiB | 21.54 KiB | 4.86 MiB | |
sql/ERRMSG | 40 | 31.12 ms | 2.30 us | 778.07 us | 5.95 ms | 24 | 2.34 MiB | 99.70 KiB | 0 | 0 bytes | 0 bytes | 2.34 MiB | |
innodb/innodb_log_file | 901 | 6.33 s | 225.46 ns | 7.02 ms | 544.30 ms | 8 | 69.00 KiB | 8.62 KiB | 536 | 575.50 KiB | 1.07 KiB | 644.50 KiB | |
mysys/charset | 3 | 315.99 us | 2.08 us | 105.33 us | 305.09 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 189 | 354.27 ms | 0 ps | 1.87 ms | 27.02 ms | 35 | 736 bytes | 21 bytes | 21 | 6.42 KiB | 313 bytes | 7.13 KiB | |
myisam/kfile | 4 | 354.80 us | 609.31 ns | 88.70 us | 335.53 us | 2 | 442 bytes | 221 bytes | 0 | 0 bytes | 0 bytes | 442 bytes | |
sql/binlog_index | 38 | 51.80 ms | 0 ps | 1.36 ms | 25.97 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
mysys/cnf | 5 | 1.66 ms | 200.64 ns | 331.25 us | 1.64 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 62.12 us | 2.74 us | 20.71 us | 38.57 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 1.03 ms | 0 ps | 68.84 us | 973.04 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 4 | 309.86 us | 0 ps | 77.47 us | 271.81 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
myisam/dfile | 2 | 7.56 us | 342.67 ns | 3.78 us | 7.22 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|