SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 2304 | 13.31 s | 336.45 ms | |
background | wait/io/file/innodb/innodb_data_file | 4064 | 8.21 s | 291.58 ms | |
background | wait/io/file/innodb/innodb_temp_file | 304 | 398.19 ms | 31.50 ms | |
background | wait/io/file/sql/binlog_index | 36 | 53.56 ms | 28.92 ms | |
background | wait/io/file/sql/binlog | 37 | 35.69 ms | 17.23 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.35 ms | 594.90 us | |
background | wait/io/file/sql/casetest | 15 | 836.19 us | 767.67 us | |
background | wait/io/file/mysys/cnf | 5 | 703.13 us | 685.69 us | |
background | wait/io/file/mysys/charset | 3 | 347.39 us | 315.47 us | |
background | wait/io/file/sql/pid | 3 | 65.24 us | 41.12 us | |
background | wait/io/file/sql/misc | 1 | 14.01 us | 14.01 us | |
root | wait/io/file/innodb/innodb_data_file | 763 | 1.40 s | 45.22 ms | |
root | wait/io/file/sql/binlog | 567 | 792.67 ms | 33.12 ms | |
root | wait/io/file/innodb/innodb_temp_file | 64 | 615.67 ms | 34.40 ms | |
root | wait/io/file/sql/io_cache | 997 | 193.91 ms | 83.35 ms | |
root | wait/io/file/sql/ERRMSG | 60 | 47.69 ms | 3.84 ms | |
root | wait/io/file/myisam/kfile | 12 | 3.35 ms | 2.08 ms | |
root | wait/io/file/csv/metadata | 8 | 781.83 us | 441.43 us | |
root | wait/io/file/csv/data | 12 | 463.26 us | 336.23 us | |
root | wait/io/file/sql/misc | 11 | 369.80 us | 201.51 us | |
root | wait/io/file/sql/binlog_index | 2 | 251.69 us | 249.19 us | |
root | wait/io/file/myisam/dfile | 6 | 93.57 us | 31.85 us |
|