SELECT * FROM `x$user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 372 | 2200933475664 | 54937272192 | |
background | wait/io/file/innodb/innodb_data_file | 1892 | 2138465827344 | 485074896768 | |
background | wait/io/file/innodb/innodb_temp_file | 85 | 353956376400 | 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_data_file | 216 | 110166357840 | 22556692752 | |
root | wait/io/file/innodb/innodb_temp_file | 10 | 102631562352 | 27593341776 | |
root | wait/io/file/sql/binlog | 216 | 64137157920 | 20471648208 | |
root | wait/io/file/sql/ERRMSG | 45 | 48351499152 | 15823617744 | |
root | wait/io/file/sql/misc | 3 | 220296912 | 177606000 | |
root | wait/io/file/sql/binlog_index | 2 | 5066160 | 3019632 |
|