SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 1992 | 10.69 s | 159.00 ms | |
background | wait/io/file/innodb/innodb_data_file | 3506 | 5.82 s | 196.43 ms | |
background | wait/io/file/innodb/innodb_temp_file | 328 | 1.40 s | 842.55 ms | |
background | wait/io/file/sql/binlog_index | 36 | 52.60 ms | 35.69 ms | |
background | wait/io/file/sql/binlog | 37 | 35.54 ms | 17.86 ms | |
background | wait/io/file/mysys/cnf | 5 | 2.27 ms | 2.24 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.31 ms | 519.55 us | |
background | wait/io/file/sql/casetest | 15 | 1.07 ms | 993.85 us | |
background | wait/io/file/mysys/charset | 3 | 256.88 us | 241.68 us | |
background | wait/io/file/sql/pid | 3 | 11.75 us | 9.29 us | |
background | wait/io/file/sql/misc | 1 | 3.69 us | 3.69 us | |
root | wait/io/file/innodb/innodb_data_file | 681 | 1.15 s | 37.07 ms | |
root | wait/io/file/innodb/innodb_temp_file | 82 | 1.08 s | 170.34 ms | |
root | wait/io/file/sql/binlog | 506 | 709.01 ms | 54.77 ms | |
root | wait/io/file/sql/io_cache | 1396 | 137.23 ms | 40.14 ms | |
root | wait/io/file/sql/ERRMSG | 55 | 39.18 ms | 7.89 ms | |
root | wait/io/file/sql/misc | 10 | 1.92 ms | 1.78 ms | |
root | wait/io/file/csv/metadata | 8 | 1.22 ms | 513.37 us | |
root | wait/io/file/myisam/kfile | 8 | 584.42 us | 273.80 us | |
root | wait/io/file/csv/data | 4 | 536.35 us | 445.85 us | |
root | wait/io/file/myisam/dfile | 4 | 32.31 us | 24.68 us | |
root | wait/io/file/sql/binlog_index | 2 | 10.53 us | 7.81 us |
|