SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 2235 | 9.56 s | 142.01 ms | |
background | wait/io/file/innodb/innodb_data_file | 2752 | 3.40 s | 241.73 ms | |
background | wait/io/file/innodb/innodb_temp_file | 368 | 1.39 s | 350.11 ms | |
background | wait/io/file/sql/binlog_index | 36 | 51.80 ms | 30.93 ms | |
background | wait/io/file/sql/binlog | 37 | 36.78 ms | 18.27 ms | |
background | wait/io/file/sql/casetest | 15 | 1.12 ms | 1.06 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.08 ms | 491.71 us | |
background | wait/io/file/mysys/cnf | 5 | 653.68 us | 637.53 us | |
background | wait/io/file/mysys/charset | 3 | 223.31 us | 210.42 us | |
background | wait/io/file/sql/pid | 3 | 46.26 us | 36.47 us | |
background | wait/io/file/sql/misc | 1 | 11.54 us | 11.54 us | |
root | wait/io/file/innodb/innodb_temp_file | 82 | 1.01 s | 141.15 ms | |
root | wait/io/file/sql/binlog | 224 | 712.77 ms | 132.32 ms | |
root | wait/io/file/sql/io_cache | 1444 | 431.48 ms | 169.28 ms | |
root | wait/io/file/innodb/innodb_data_file | 627 | 195.71 ms | 16.19 ms | |
root | wait/io/file/sql/ERRMSG | 50 | 167.40 ms | 127.01 ms | |
root | wait/io/file/csv/metadata | 4 | 10.65 ms | 10.40 ms | |
root | wait/io/file/myisam/kfile | 14 | 5.97 ms | 3.13 ms | |
root | wait/io/file/sql/misc | 6 | 749.15 us | 673.91 us | |
root | wait/io/file/csv/data | 9 | 533.60 us | 487.64 us | |
root | wait/io/file/sql/binlog_index | 2 | 202.88 us | 188.07 us | |
root | wait/io/file/myisam/dfile | 10 | 145.77 us | 36.83 us |
|