SELECT * FROM `user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 5358 | 23.89 s | 98.71 ms | |
background | wait/io/file/innodb/innodb_data_file | 5700 | 9.12 s | 492.08 ms | |
background | wait/io/file/innodb/innodb_temp_file | 748 | 318.19 ms | 21.77 ms | |
background | wait/io/file/sql/binlog_index | 36 | 46.70 ms | 28.16 ms | |
background | wait/io/file/sql/binlog | 37 | 32.30 ms | 16.64 ms | |
background | wait/io/file/sql/casetest | 15 | 1.37 ms | 1.30 ms | |
background | wait/io/file/sql/ERRMSG | 5 | 1.16 ms | 521.05 us | |
background | wait/io/file/mysys/cnf | 5 | 499.41 us | 477.55 us | |
background | wait/io/file/mysys/charset | 3 | 258.35 us | 236.12 us | |
background | wait/io/file/sql/pid | 3 | 18.73 us | 14.96 us | |
background | wait/io/file/sql/misc | 1 | 4.83 us | 4.83 us | |
root | wait/io/file/innodb/innodb_data_file | 866 | 1.82 s | 43.38 ms | |
root | wait/io/file/sql/binlog | 932 | 1.46 s | 41.56 ms | |
root | wait/io/file/innodb/innodb_temp_file | 130 | 1.13 s | 35.43 ms | |
root | wait/io/file/sql/io_cache | 1257 | 363.78 ms | 127.94 ms | |
root | wait/io/file/sql/ERRMSG | 65 | 49.13 ms | 3.13 ms | |
root | wait/io/file/sql/SDI | 210 | 28.67 ms | 5.13 ms | |
root | wait/io/file/myisam/kfile | 2459 | 25.07 ms | 5.49 ms | |
root | wait/io/file/myisam/dfile | 8171 | 22.36 ms | 1.96 ms | |
root | wait/io/file/csv/data | 4 | 912.38 us | 864.26 us | |
root | wait/io/file/csv/metadata | 8 | 822.74 us | 413.17 us | |
root | wait/io/file/sql/misc | 6 | 81.85 us | 24.39 us | |
root | wait/io/file/sql/binlog_index | 2 | 5.59 us | 3.80 us |
|