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 | 3404 | 6.12 s | 0 ps | 1.80 ms | 507.94 ms | 1524 | 28.69 MiB | 19.28 KiB | 1254 | 46.11 MiB | 37.65 KiB | 74.80 MiB | |
sql/io_cache | 1534 | 457.66 ms | 0 ps | 298.34 us | 402.96 ms | 734 | 33.95 MiB | 47.36 KiB | 600 | 33.95 MiB | 57.94 KiB | 67.90 MiB | |
innodb/innodb_temp_file | 473 | 2.70 s | 0 ps | 5.70 ms | 1.15 s | 0 | 0 bytes | 0 bytes | 365 | 9.33 MiB | 26.17 KiB | 9.33 MiB | |
sql/ERRMSG | 60 | 45.23 ms | 2.67 us | 753.76 us | 6.87 ms | 36 | 3.52 MiB | 100.04 KiB | 0 | 0 bytes | 0 bytes | 3.52 MiB | |
innodb/innodb_log_file | 1176 | 6.83 s | 227.04 ns | 5.81 ms | 40.38 ms | 8 | 69.00 KiB | 8.62 KiB | 689 | 614.00 KiB | 913 bytes | 683.00 KiB | |
mysys/charset | 3 | 353.02 us | 2.13 us | 117.67 us | 340.02 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 293 | 227.88 ms | 0 ps | 777.75 us | 28.00 ms | 65 | 856 bytes | 13 bytes | 13 | 3.62 KiB | 285 bytes | 4.46 KiB | |
myisam/kfile | 12 | 1.18 ms | 683.76 ns | 98.07 us | 506.92 us | 6 | 1.21 KiB | 207 bytes | 0 | 0 bytes | 0 bytes | 1.21 KiB | |
sql/binlog_index | 38 | 63.91 ms | 0 ps | 1.68 ms | 37.17 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
myisam/dfile | 10 | 1.33 ms | 231.79 ns | 133.40 us | 1.24 ms | 1 | 67 bytes | 67 bytes | 0 | 0 bytes | 0 bytes | 67 bytes | |
mysys/cnf | 5 | 652.76 us | 137.81 ns | 130.55 us | 636.74 us | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
csv/metadata | 4 | 395.64 us | 697.49 ns | 98.91 us | 288.49 us | 1 | 35 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 35 bytes | |
sql/pid | 3 | 66.51 us | 3.58 us | 22.17 us | 38.93 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 799.45 us | 0 ps | 53.30 us | 740.28 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 3 | 53.48 us | 0 ps | 17.83 us | 29.40 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 2 | 698.31 us | 0 ps | 349.15 us | 686.91 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|