SELECT * FROM `x$user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 1040 | 7197677366352 | 956375233968 | |
background | wait/io/file/innodb/innodb_data_file | 2773 | 4980596254128 | 227431549488 | |
background | wait/io/file/innodb/innodb_temp_file | 127 | 379533611424 | 25386446976 | |
background | wait/io/file/sql/binlog_index | 36 | 54222523872 | 34310150160 | |
background | wait/io/file/sql/binlog | 37 | 40430064048 | 18218649504 | |
background | wait/io/file/sql/ERRMSG | 5 | 2251026096 | 1339921440 | |
background | wait/io/file/sql/casetest | 15 | 1076014896 | 1011896688 | |
background | wait/io/file/mysys/cnf | 5 | 709217520 | 692100288 | |
background | wait/io/file/mysys/charset | 3 | 258082176 | 243725856 | |
background | wait/io/file/sql/pid | 3 | 59537280 | 37835952 | |
background | wait/io/file/sql/misc | 1 | 15035328 | 15035328 | |
root | wait/io/file/innodb/innodb_temp_file | 72 | 669798898032 | 36748192800 | |
root | wait/io/file/innodb/innodb_data_file | 345 | 409146534720 | 29390284176 | |
root | wait/io/file/sql/binlog | 396 | 328696486800 | 32480427936 | |
root | wait/io/file/sql/ERRMSG | 45 | 28869892128 | 2315502816 | |
root | wait/io/file/sql/io_cache | 68 | 7116027600 | 5536123824 | |
root | wait/io/file/csv/metadata | 8 | 1361010288 | 563600928 | |
root | wait/io/file/csv/data | 4 | 263695872 | 198724944 | |
root | wait/io/file/sql/misc | 4 | 82600320 | 29212656 | |
root | wait/io/file/sql/binlog_index | 2 | 6383520 | 3963168 |
|