SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 2072 | 11.49 s | 493.67 ms | |
background | wait/io/file/innodb/innodb_data_file | 2939 | 4.39 s | 224.05 ms | |
background | wait/io/file/innodb/innodb_temp_file | 85 | 304.47 ms | 24.47 ms | |
background | wait/io/file/sql/binlog_index | 36 | 46.15 ms | 29.24 ms | |
background | wait/io/file/sql/binlog | 37 | 40.84 ms | 27.10 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.25 ms | 466.84 us | |
background | wait/io/file/sql/casetest | 15 | 836.72 us | 686.55 us | |
background | wait/io/file/mysys/cnf | 5 | 803.88 us | 784.39 us | |
background | wait/io/file/mysys/charset | 3 | 303.42 us | 287.05 us | |
background | wait/io/file/sql/pid | 3 | 13.33 us | 10.43 us | |
background | wait/io/file/sql/misc | 1 | 4.23 us | 4.23 us | |
root | wait/io/file/innodb/innodb_data_file | 529 | 1.53 s | 41.56 ms | |
root | wait/io/file/sql/binlog | 378 | 932.34 ms | 63.93 ms | |
root | wait/io/file/innodb/innodb_temp_file | 10 | 94.19 ms | 31.61 ms | |
root | wait/io/file/sql/ERRMSG | 55 | 26.21 ms | 3.08 ms | |
root | wait/io/file/csv/metadata | 8 | 2.14 ms | 1.05 ms | |
root | wait/io/file/csv/data | 9 | 148.28 us | 34.10 us | |
root | wait/io/file/sql/misc | 9 | 117.25 us | 19.05 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.22 us | 3.12 us |
|