SELECT * FROM `x$user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 6896 | 33699877990944 | 86128504176 | |
background | wait/io/file/innodb/innodb_data_file | 5664 | 11346024995184 | 200041388448 | |
background | wait/io/file/innodb/innodb_temp_file | 384 | 331153757088 | 27509358096 | |
background | wait/io/file/sql/binlog_index | 36 | 51340132272 | 35318447472 | |
background | wait/io/file/sql/binlog | 37 | 39995888064 | 24299196768 | |
background | wait/io/file/sql/ERRMSG | 5 | 1253287200 | 575911776 | |
background | wait/io/file/sql/casetest | 15 | 879034992 | 801508224 | |
background | wait/io/file/mysys/cnf | 5 | 605986656 | 587387856 | |
background | wait/io/file/mysys/charset | 3 | 244358928 | 226808736 | |
background | wait/io/file/sql/pid | 3 | 13139280 | 10758528 | |
background | wait/io/file/sql/misc | 1 | 3517536 | 3517536 | |
root | wait/io/file/innodb/innodb_data_file | 1554 | 6417137849760 | 61418934720 | |
root | wait/io/file/sql/binlog | 1195 | 5795341763376 | 48458111856 | |
root | wait/io/file/innodb/innodb_temp_file | 90 | 850066315296 | 31564154688 | |
root | wait/io/file/sql/io_cache | 1090 | 73483067856 | 26079890496 | |
root | wait/io/file/sql/ERRMSG | 75 | 69200690592 | 6653862864 | |
root | wait/io/file/myisam/dfile | 23233 | 19925597472 | 3300866976 | |
root | wait/io/file/myisam/kfile | 354 | 8666099376 | 2038443792 | |
root | wait/io/file/sql/SDI | 90 | 6152521056 | 728928288 | |
root | wait/io/file/csv/metadata | 8 | 2675701776 | 1315289184 | |
root | wait/io/file/sql/misc | 10 | 1989402096 | 1869133200 | |
root | wait/io/file/csv/data | 14 | 540436512 | 357573216 | |
root | wait/io/file/sql/binlog_index | 2 | 233368608 | 230764512 |
|