SELECT * FROM `x$user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 164 | 994776585264 | 48451507104 | |
background | wait/io/file/innodb/innodb_data_file | 1542 | 916485903696 | 253994914272 | |
background | wait/io/file/innodb/innodb_temp_file | 81 | 353785577376 | 25080080256 | |
background | wait/io/file/sql/binlog_index | 36 | 39906505056 | 20165128368 | |
background | wait/io/file/sql/binlog | 37 | 35869652016 | 16206163776 | |
background | wait/io/file/sql/ERRMSG | 5 | 1166335104 | 440789712 | |
background | wait/io/file/mysys/charset | 3 | 965594784 | 950439072 | |
background | wait/io/file/sql/casetest | 15 | 740309328 | 654047328 | |
background | wait/io/file/mysys/cnf | 5 | 648998064 | 619166064 | |
background | wait/io/file/sql/pid | 3 | 19687008 | 15895968 | |
background | wait/io/file/sql/misc | 1 | 10865184 | 10865184 | |
root | wait/io/file/sql/ERRMSG | 45 | 48351499152 | 15823617744 | |
root | wait/io/file/innodb/innodb_data_file | 132 | 38072703504 | 3390992352 | |
root | wait/io/file/innodb/innodb_temp_file | 2 | 20058984528 | 19995272880 | |
root | wait/io/file/sql/binlog | 112 | 576167856 | 21355488 | |
root | wait/io/file/sql/binlog_index | 2 | 5066160 | 3019632 |
|