SELECT * FROM `x$user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 1372 | 7686955068144 | 54937272192 | |
background | wait/io/file/innodb/innodb_data_file | 3335 | 5411139603408 | 485074896768 | |
background | wait/io/file/innodb/innodb_temp_file | 108 | 355263756672 | 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/innodb/innodb_temp_file | 58 | 609879368736 | 48406189392 | |
root | wait/io/file/sql/binlog | 894 | 170485179216 | 20471648208 | |
root | wait/io/file/innodb/innodb_data_file | 259 | 154840946304 | 22556692752 | |
root | wait/io/file/sql/ERRMSG | 55 | 54563825712 | 15823617744 | |
root | wait/io/file/csv/metadata | 4 | 674905968 | 569394144 | |
root | wait/io/file/sql/misc | 5 | 288775344 | 177606000 | |
root | wait/io/file/csv/data | 8 | 44188320 | 13078560 | |
root | wait/io/file/sql/binlog_index | 2 | 5066160 | 3019632 |
|