SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 4082 | 21.32 s | 116.20 ms | |
background | wait/io/file/innodb/innodb_data_file | 6849 | 7.89 s | 234.40 ms | |
background | wait/io/file/innodb/innodb_temp_file | 856 | 1.52 s | 658.38 ms | |
background | wait/io/file/sql/binlog_index | 36 | 58.51 ms | 35.55 ms | |
background | wait/io/file/sql/binlog | 37 | 40.72 ms | 20.91 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.24 ms | 419.45 us | |
background | wait/io/file/sql/casetest | 15 | 1.12 ms | 1.05 ms | |
background | wait/io/file/mysys/cnf | 5 | 575.30 us | 559.23 us | |
background | wait/io/file/mysys/charset | 3 | 297.09 us | 281.40 us | |
background | wait/io/file/sql/pid | 3 | 44.13 us | 34.66 us | |
background | wait/io/file/sql/misc | 1 | 6.83 us | 6.83 us | |
root | wait/io/file/innodb/innodb_temp_file | 52 | 498.08 ms | 37.67 ms | |
root | wait/io/file/innodb/innodb_data_file | 562 | 221.53 ms | 21.95 ms | |
root | wait/io/file/sql/binlog | 244 | 218.39 ms | 21.46 ms | |
root | wait/io/file/sql/io_cache | 1442 | 131.86 ms | 28.37 ms | |
root | wait/io/file/sql/ERRMSG | 50 | 33.69 ms | 4.00 ms | |
root | wait/io/file/myisam/kfile | 16 | 1.67 ms | 788.29 us | |
root | wait/io/file/csv/data | 21 | 1.28 ms | 851.70 us | |
root | wait/io/file/csv/metadata | 8 | 1.25 ms | 717.03 us | |
root | wait/io/file/sql/misc | 9 | 379.86 us | 251.65 us | |
root | wait/io/file/myisam/dfile | 14 | 337.83 us | 291.82 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.21 us | 3.41 us |
|