SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 15640 | 59.25 s | 199.28 ms | |
background | wait/io/file/innodb/innodb_data_file | 9606 | 14.07 s | 343.76 ms | |
background | wait/io/file/innodb/innodb_temp_file | 766 | 591.01 ms | 43.33 ms | |
background | wait/io/file/sql/binlog_index | 36 | 86.13 ms | 43.05 ms | |
background | wait/io/file/sql/binlog | 37 | 73.26 ms | 41.52 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 7.14 ms | 5.95 ms | |
background | wait/io/file/mysys/cnf | 5 | 3.08 ms | 3.06 ms | |
background | wait/io/file/sql/casetest | 15 | 876.67 us | 775.93 us | |
background | wait/io/file/mysys/charset | 3 | 320.63 us | 289.53 us | |
background | wait/io/file/sql/pid | 3 | 17.59 us | 14.24 us | |
background | wait/io/file/sql/misc | 1 | 13.45 us | 13.45 us | |
root | wait/io/file/innodb/innodb_data_file | 2599 | 10.29 s | 60.19 ms | |
root | wait/io/file/sql/binlog | 1423 | 3.80 s | 59.37 ms | |
root | wait/io/file/innodb/innodb_temp_file | 76 | 416.61 ms | 36.90 ms | |
root | wait/io/file/sql/io_cache | 910 | 171.61 ms | 69.17 ms | |
root | wait/io/file/sql/ERRMSG | 75 | 85.79 ms | 14.51 ms | |
root | wait/io/file/myisam/kfile | 2933 | 74.50 ms | 50.26 ms | |
root | wait/io/file/myisam/dfile | 850 | 29.71 ms | 20.04 ms | |
root | wait/io/file/sql/SDI | 800 | 25.56 ms | 1.86 ms | |
root | wait/io/file/csv/metadata | 8 | 788.94 us | 372.77 us | |
root | wait/io/file/sql/misc | 16 | 256.34 us | 49.70 us | |
root | wait/io/file/csv/data | 4 | 251.28 us | 212.20 us | |
root | wait/io/file/sql/binlog_index | 2 | 12.02 us | 10.18 us |
|