SELECT * FROM `x$user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 1269 | 7726338178944 | 664558371840 | |
background | wait/io/file/innodb/innodb_data_file | 2982 | 4633413028992 | 198428218032 | |
background | wait/io/file/innodb/innodb_temp_file | 103 | 319721937744 | 23220741984 | |
background | wait/io/file/sql/binlog_index | 36 | 49057689648 | 26916316416 | |
background | wait/io/file/sql/binlog | 37 | 29630042112 | 15381775200 | |
background | wait/io/file/sql/ERRMSG | 5 | 1209415152 | 428715408 | |
background | wait/io/file/sql/casetest | 15 | 742063872 | 665690256 | |
background | wait/io/file/mysys/cnf | 5 | 531927792 | 515436768 | |
background | wait/io/file/mysys/charset | 3 | 251355456 | 231932448 | |
background | wait/io/file/sql/pid | 3 | 12653520 | 10456512 | |
background | wait/io/file/sql/misc | 1 | 5436288 | 5436288 | |
root | wait/io/file/innodb/innodb_data_file | 518 | 901953159360 | 39707563632 | |
root | wait/io/file/sql/binlog | 947 | 355229050704 | 24401171520 | |
root | wait/io/file/innodb/innodb_temp_file | 16 | 161329043040 | 30805482576 | |
root | wait/io/file/sql/io_cache | 69 | 65780538384 | 61872143520 | |
root | wait/io/file/sql/ERRMSG | 55 | 39558586848 | 4423606704 | |
root | wait/io/file/myisam/kfile | 12 | 2881956528 | 1522345968 | |
root | wait/io/file/csv/metadata | 8 | 2753659920 | 1953453216 | |
root | wait/io/file/sql/misc | 8 | 458467680 | 351564048 | |
root | wait/io/file/csv/data | 7 | 425581200 | 371827632 | |
root | wait/io/file/sql/binlog_index | 2 | 264975216 | 263430288 | |
root | wait/io/file/myisam/dfile | 6 | 25365648 | 10042560 |
|