SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 5611 | 28.37 s | 115.45 ms | |
background | wait/io/file/innodb/innodb_data_file | 6388 | 11.02 s | 208.45 ms | |
background | wait/io/file/innodb/innodb_temp_file | 331 | 543.80 ms | 101.45 ms | |
background | wait/io/file/sql/binlog_index | 36 | 42.62 ms | 24.76 ms | |
background | wait/io/file/sql/binlog | 37 | 32.24 ms | 15.64 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.23 ms | 494.35 us | |
background | wait/io/file/mysys/cnf | 5 | 1.14 ms | 1.12 ms | |
background | wait/io/file/sql/casetest | 15 | 729.23 us | 655.47 us | |
background | wait/io/file/mysys/charset | 3 | 228.12 us | 207.15 us | |
background | wait/io/file/sql/pid | 3 | 13.12 us | 10.48 us | |
background | wait/io/file/sql/misc | 1 | 2.38 us | 2.38 us | |
root | wait/io/file/innodb/innodb_data_file | 1060 | 4.01 s | 51.44 ms | |
root | wait/io/file/sql/binlog | 478 | 1.73 s | 45.21 ms | |
root | wait/io/file/innodb/innodb_temp_file | 32 | 344.59 ms | 40.31 ms | |
root | wait/io/file/sql/io_cache | 394 | 175.15 ms | 115.63 ms | |
root | wait/io/file/sql/ERRMSG | 85 | 47.84 ms | 3.12 ms | |
root | wait/io/file/csv/data | 4 | 3.92 ms | 3.87 ms | |
root | wait/io/file/csv/metadata | 8 | 2.43 ms | 1.14 ms | |
root | wait/io/file/myisam/kfile | 8 | 1.66 ms | 1.42 ms | |
root | wait/io/file/myisam/dfile | 162 | 679.50 us | 327.77 us | |
root | wait/io/file/sql/misc | 17 | 313.65 us | 35.78 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.03 us | 3.06 us |
|