SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 456 | 2.80 s | 115.38 ms | |
background | wait/io/file/innodb/innodb_data_file | 1945 | 2.17 s | 238.30 ms | |
background | wait/io/file/innodb/innodb_temp_file | 135 | 955.55 ms | 370.21 ms | |
background | wait/io/file/sql/binlog_index | 36 | 56.54 ms | 35.50 ms | |
background | wait/io/file/sql/binlog | 37 | 35.75 ms | 17.13 ms | |
background | wait/io/file/mysys/cnf | 5 | 2.66 ms | 2.64 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.36 ms | 538.42 us | |
background | wait/io/file/sql/casetest | 15 | 854.45 us | 778.95 us | |
background | wait/io/file/mysys/charset | 3 | 300.64 us | 287.32 us | |
background | wait/io/file/sql/pid | 3 | 53.17 us | 38.71 us | |
background | wait/io/file/sql/misc | 1 | 14.32 us | 14.32 us | |
root | wait/io/file/innodb/innodb_temp_file | 34 | 493.80 ms | 150.79 ms | |
root | wait/io/file/sql/io_cache | 354 | 198.33 ms | 98.26 ms | |
root | wait/io/file/sql/binlog | 470 | 115.34 ms | 22.08 ms | |
root | wait/io/file/innodb/innodb_data_file | 223 | 57.55 ms | 1.95 ms | |
root | wait/io/file/sql/ERRMSG | 45 | 28.85 ms | 4.57 ms | |
root | wait/io/file/csv/metadata | 8 | 1.27 ms | 578.47 us | |
root | wait/io/file/csv/data | 16 | 1.08 ms | 993.96 us | |
root | wait/io/file/sql/misc | 3 | 804.50 us | 557.06 us | |
root | wait/io/file/myisam/kfile | 4 | 644.62 us | 502.01 us | |
root | wait/io/file/myisam/dfile | 2 | 33.16 us | 31.59 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.08 us | 3.46 us |
|