SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 4842 | 23.22 s | 335.29 ms | |
background | wait/io/file/innodb/innodb_data_file | 6211 | 11.16 s | 211.99 ms | |
background | wait/io/file/innodb/innodb_temp_file | 693 | 609.04 ms | 180.63 ms | |
background | wait/io/file/sql/binlog_index | 36 | 45.91 ms | 28.63 ms | |
background | wait/io/file/sql/binlog | 37 | 31.08 ms | 15.66 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.51 ms | 581.06 us | |
background | wait/io/file/sql/casetest | 15 | 1.14 ms | 1.03 ms | |
background | wait/io/file/mysys/cnf | 5 | 578.78 us | 532.62 us | |
background | wait/io/file/mysys/charset | 3 | 229.50 us | 208.05 us | |
background | wait/io/file/sql/pid | 3 | 19.26 us | 14.12 us | |
background | wait/io/file/sql/misc | 1 | 5.71 us | 5.71 us | |
root | wait/io/file/sql/binlog | 852 | 1.92 s | 30.95 ms | |
root | wait/io/file/innodb/innodb_data_file | 992 | 1.64 s | 31.13 ms | |
root | wait/io/file/innodb/innodb_temp_file | 72 | 753.15 ms | 120.58 ms | |
root | wait/io/file/sql/io_cache | 928 | 52.57 ms | 16.89 ms | |
root | wait/io/file/sql/ERRMSG | 80 | 40.33 ms | 2.85 ms | |
root | wait/io/file/sql/misc | 26 | 2.17 ms | 1.84 ms | |
root | wait/io/file/csv/metadata | 8 | 1.01 ms | 581.87 us | |
root | wait/io/file/csv/data | 24 | 722.06 us | 294.93 us | |
root | wait/io/file/myisam/kfile | 9 | 539.72 us | 263.75 us | |
root | wait/io/file/myisam/dfile | 7 | 365.82 us | 315.66 us | |
root | wait/io/file/sql/binlog_index | 2 | 151.40 us | 149.81 us |
|