SELECT * FROM `x$user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 717 | 4156324991280 | 91093986192 | |
background | wait/io/file/innodb/innodb_data_file | 2157 | 3013576373280 | 227694067392 | |
background | wait/io/file/innodb/innodb_temp_file | 89 | 342648093744 | 26293912128 | |
background | wait/io/file/sql/binlog_index | 36 | 47812458672 | 25895371920 | |
background | wait/io/file/sql/binlog | 37 | 34449597600 | 16310482320 | |
background | wait/io/file/sql/ERRMSG | 5 | 1201178880 | 520709904 | |
background | wait/io/file/sql/casetest | 15 | 844852800 | 749886192 | |
background | wait/io/file/mysys/cnf | 5 | 459576480 | 429913968 | |
background | wait/io/file/mysys/charset | 3 | 277490928 | 257695680 | |
background | wait/io/file/sql/pid | 3 | 35708640 | 20122080 | |
background | wait/io/file/sql/misc | 1 | 5197632 | 5197632 | |
root | wait/io/file/innodb/innodb_data_file | 262 | 440658461232 | 57462314448 | |
root | wait/io/file/sql/binlog | 340 | 280101711648 | 27033216672 | |
root | wait/io/file/innodb/innodb_temp_file | 12 | 118886104128 | 30628474272 | |
root | wait/io/file/sql/ERRMSG | 75 | 57066808128 | 3074253600 | |
root | wait/io/file/myisam/kfile | 4 | 528209616 | 510394368 | |
root | wait/io/file/myisam/dfile | 29 | 257977104 | 237414144 | |
root | wait/io/file/sql/misc | 3 | 54108912 | 30635616 | |
root | wait/io/file/sql/binlog_index | 2 | 4886640 | 3121008 |
|