SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 2673 | 12.31 s | 181.18 ms | |
background | wait/io/file/innodb/innodb_data_file | 4089 | 6.28 s | 651.16 ms | |
background | wait/io/file/innodb/innodb_temp_file | 276 | 323.97 ms | 29.08 ms | |
background | wait/io/file/sql/binlog_index | 36 | 45.56 ms | 25.84 ms | |
background | wait/io/file/sql/binlog | 37 | 39.61 ms | 18.85 ms | |
background | wait/io/file/mysys/cnf | 5 | 2.25 ms | 2.23 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.28 ms | 521.82 us | |
background | wait/io/file/sql/casetest | 15 | 1.11 ms | 983.50 us | |
background | wait/io/file/mysys/charset | 3 | 311.01 us | 268.93 us | |
background | wait/io/file/sql/pid | 3 | 40.80 us | 32.68 us | |
background | wait/io/file/sql/misc | 1 | 5.94 us | 5.94 us | |
root | wait/io/file/sql/binlog | 390 | 949.53 ms | 39.02 ms | |
root | wait/io/file/innodb/innodb_data_file | 654 | 688.92 ms | 34.55 ms | |
root | wait/io/file/innodb/innodb_temp_file | 40 | 343.12 ms | 32.11 ms | |
root | wait/io/file/sql/io_cache | 474 | 174.03 ms | 58.48 ms | |
root | wait/io/file/sql/ERRMSG | 70 | 39.39 ms | 3.15 ms | |
root | wait/io/file/csv/metadata | 8 | 2.13 ms | 1.12 ms | |
root | wait/io/file/myisam/kfile | 4 | 467.48 us | 206.00 us | |
root | wait/io/file/sql/misc | 10 | 302.47 us | 190.67 us | |
root | wait/io/file/sql/binlog_index | 2 | 257.63 us | 255.87 us | |
root | wait/io/file/csv/data | 4 | 103.76 us | 39.62 us | |
root | wait/io/file/myisam/dfile | 4 | 90.58 us | 35.56 us |
|