SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 4401 | 19.59 s | 124.45 ms | |
background | wait/io/file/innodb/innodb_data_file | 4674 | 7.52 s | 662.55 ms | |
background | wait/io/file/innodb/innodb_temp_file | 665 | 448.42 ms | 28.36 ms | |
background | wait/io/file/sql/binlog_index | 36 | 48.83 ms | 25.39 ms | |
background | wait/io/file/sql/binlog | 37 | 37.76 ms | 19.61 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 2.12 ms | 1.27 ms | |
background | wait/io/file/sql/casetest | 15 | 759.12 us | 688.19 us | |
background | wait/io/file/mysys/cnf | 5 | 556.27 us | 535.77 us | |
background | wait/io/file/mysys/charset | 3 | 325.51 us | 307.22 us | |
background | wait/io/file/sql/pid | 3 | 47.43 us | 37.37 us | |
background | wait/io/file/sql/misc | 1 | 14.16 us | 14.16 us | |
root | wait/io/file/innodb/innodb_data_file | 857 | 2.09 s | 40.46 ms | |
root | wait/io/file/sql/binlog | 996 | 1.48 s | 29.17 ms | |
root | wait/io/file/innodb/innodb_temp_file | 166 | 1.36 s | 44.88 ms | |
root | wait/io/file/sql/io_cache | 2209 | 340.78 ms | 167.83 ms | |
root | wait/io/file/sql/ERRMSG | 80 | 69.92 ms | 6.99 ms | |
root | wait/io/file/myisam/kfile | 2443 | 50.12 ms | 21.85 ms | |
root | wait/io/file/sql/SDI | 210 | 30.97 ms | 5.74 ms | |
root | wait/io/file/myisam/dfile | 6926 | 14.73 ms | 2.46 ms | |
root | wait/io/file/sql/misc | 10 | 392.82 us | 244.83 us | |
root | wait/io/file/sql/binlog_index | 2 | 4.63 us | 2.58 us |
|