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 | 2787 | 4.32 s | 0 ps | 1.55 ms | 723.69 ms | 1615 | 30.11 MiB | 19.09 KiB | 696 | 29.64 MiB | 43.61 KiB | 59.75 MiB | |
sql/io_cache | 1288 | 142.53 ms | 0 ps | 110.66 us | 61.14 ms | 660 | 29.02 MiB | 45.03 KiB | 498 | 29.02 MiB | 59.68 KiB | 58.05 MiB | |
innodb/innodb_temp_file | 676 | 1.24 s | 0 ps | 1.84 ms | 72.23 ms | 0 | 0 bytes | 0 bytes | 581 | 11.89 MiB | 20.96 KiB | 11.89 MiB | |
sql/ERRMSG | 50 | 43.42 ms | 2.62 us | 868.32 us | 5.60 ms | 30 | 2.93 MiB | 100.12 KiB | 0 | 0 bytes | 0 bytes | 2.93 MiB | |
innodb/innodb_log_file | 617 | 4.00 s | 229.15 ns | 6.48 ms | 134.52 ms | 8 | 69.00 KiB | 8.62 KiB | 349 | 270.50 KiB | 794 bytes | 339.50 KiB | |
mysys/charset | 3 | 294.49 us | 1.43 us | 98.16 us | 282.76 us | 1 | 19.04 KiB | 19.04 KiB | 0 | 0 bytes | 0 bytes | 19.04 KiB | |
sql/binlog | 311 | 244.46 ms | 0 ps | 786.05 us | 22.46 ms | 68 | 868 bytes | 13 bytes | 16 | 3.34 KiB | 214 bytes | 4.19 KiB | |
myisam/kfile | 16 | 2.20 ms | 809.95 ns | 137.53 us | 657.95 us | 8 | 1.66 KiB | 213 bytes | 0 | 0 bytes | 0 bytes | 1.66 KiB | |
sql/binlog_index | 38 | 43.82 ms | 0 ps | 1.15 ms | 23.95 ms | 9 | 288 bytes | 32 bytes | 0 | 0 bytes | 0 bytes | 288 bytes | |
csv/metadata | 8 | 5.06 ms | 627.26 ns | 632.38 us | 3.95 ms | 2 | 70 bytes | 35 bytes | 0 | 0 bytes | 0 bytes | 70 bytes | |
mysys/cnf | 5 | 1.39 ms | 222.82 ns | 277.29 us | 1.36 ms | 3 | 56 bytes | 19 bytes | 0 | 0 bytes | 0 bytes | 56 bytes | |
sql/pid | 3 | 46.95 us | 3.04 us | 15.65 us | 35.60 us | 0 | 0 bytes | 0 bytes | 1 | 4 bytes | 4 bytes | 4 bytes | |
sql/casetest | 15 | 797.17 us | 0 ps | 53.14 us | 736.47 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
sql/misc | 8 | 168.44 us | 0 ps | 21.05 us | 74.05 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
csv/data | 4 | 3.69 ms | 0 ps | 922.24 us | 3.60 ms | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes | |
myisam/dfile | 8 | 91.32 us | 287.76 ns | 11.41 us | 28.29 us | 0 | 0 bytes | 0 bytes | 0 | 0 bytes | 0 bytes | 0 bytes |
|