SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 803 | 4.40 s | 136.44 ms | |
background | wait/io/file/innodb/innodb_data_file | 2351 | 3.14 s | 217.96 ms | |
background | wait/io/file/innodb/innodb_temp_file | 114 | 307.43 ms | 23.25 ms | |
background | wait/io/file/sql/binlog_index | 36 | 67.68 ms | 38.38 ms | |
background | wait/io/file/sql/binlog | 37 | 40.38 ms | 19.81 ms | |
background | wait/io/file/mysys/cnf | 5 | 1.83 ms | 1.80 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.19 ms | 419.32 us | |
background | wait/io/file/sql/casetest | 15 | 948.93 us | 881.29 us | |
background | wait/io/file/mysys/charset | 3 | 251.70 us | 232.74 us | |
background | wait/io/file/sql/pid | 3 | 16.62 us | 11.28 us | |
background | wait/io/file/sql/misc | 1 | 5.38 us | 5.38 us | |
root | wait/io/file/innodb/innodb_temp_file | 58 | 479.34 ms | 36.96 ms | |
root | wait/io/file/sql/binlog | 342 | 295.40 ms | 26.83 ms | |
root | wait/io/file/innodb/innodb_data_file | 434 | 286.18 ms | 24.72 ms | |
root | wait/io/file/sql/ERRMSG | 40 | 22.08 ms | 3.44 ms | |
root | wait/io/file/sql/SDI | 12 | 1.23 ms | 1.03 ms | |
root | wait/io/file/csv/metadata | 8 | 945.29 us | 456.17 us | |
root | wait/io/file/myisam/kfile | 84 | 745.01 us | 347.07 us | |
root | wait/io/file/myisam/dfile | 34 | 488.44 us | 343.85 us | |
root | wait/io/file/sql/misc | 3 | 250.59 us | 214.44 us | |
root | wait/io/file/csv/data | 9 | 94.46 us | 25.72 us | |
root | wait/io/file/sql/binlog_index | 2 | 4.83 us | 3.28 us |
|