SELECT * FROM `x$user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 613 | 3562395611280 | 273945574320 | |
background | wait/io/file/innodb/innodb_data_file | 2230 | 2435758176192 | 223742561856 | |
background | wait/io/file/innodb/innodb_temp_file | 290 | 398291613984 | 88498649184 | |
background | wait/io/file/sql/binlog_index | 36 | 44467550160 | 28562390736 | |
background | wait/io/file/sql/binlog | 37 | 28508218464 | 14984282544 | |
background | wait/io/file/sql/ERRMSG | 5 | 1180243680 | 539743776 | |
background | wait/io/file/sql/casetest | 15 | 826890768 | 754792368 | |
background | wait/io/file/mysys/cnf | 5 | 518780592 | 500110512 | |
background | wait/io/file/mysys/charset | 3 | 284158512 | 261077520 | |
background | wait/io/file/sql/pid | 3 | 13600752 | 10595376 | |
background | wait/io/file/sql/misc | 1 | 5740944 | 5740944 | |
root | wait/io/file/innodb/innodb_temp_file | 38 | 373490466624 | 27111942528 | |
root | wait/io/file/innodb/innodb_data_file | 379 | 155757687360 | 11497991472 | |
root | wait/io/file/sql/ERRMSG | 40 | 31336012224 | 4489688544 | |
root | wait/io/file/sql/binlog | 140 | 4027859088 | 1925384736 | |
root | wait/io/file/sql/io_cache | 164 | 3827474112 | 392218464 | |
root | wait/io/file/myisam/kfile | 8 | 3016325664 | 1809532560 | |
root | wait/io/file/csv/metadata | 8 | 1029912048 | 547511712 | |
root | wait/io/file/csv/data | 4 | 336937392 | 288650736 | |
root | wait/io/file/sql/binlog_index | 2 | 136901424 | 134820576 | |
root | wait/io/file/myisam/dfile | 7 | 47361600 | 14252832 |
|