SELECT * FROM `x$user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 848 | 4816954622832 | 45685542672 | |
background | wait/io/file/innodb/innodb_data_file | 2525 | 3584007370416 | 220035777456 | |
background | wait/io/file/innodb/innodb_temp_file | 94 | 392840001840 | 35020522416 | |
background | wait/io/file/sql/binlog_index | 36 | 51665721360 | 26358474384 | |
background | wait/io/file/sql/binlog | 37 | 37782844176 | 19064681328 | |
background | wait/io/file/sql/ERRMSG | 5 | 1309215072 | 462537504 | |
background | wait/io/file/sql/casetest | 15 | 872634048 | 807574416 | |
background | wait/io/file/mysys/cnf | 5 | 631799520 | 614266224 | |
background | wait/io/file/mysys/charset | 3 | 289039872 | 275489808 | |
background | wait/io/file/sql/pid | 3 | 45552672 | 36164304 | |
background | wait/io/file/sql/misc | 1 | 14965104 | 14965104 | |
root | wait/io/file/innodb/innodb_temp_file | 40 | 412931760912 | 42186998832 | |
root | wait/io/file/innodb/innodb_data_file | 257 | 104977812720 | 17348104224 | |
root | wait/io/file/sql/binlog | 1016 | 67876872096 | 16016054208 | |
root | wait/io/file/sql/ERRMSG | 50 | 36860868000 | 3338379792 | |
root | wait/io/file/csv/metadata | 8 | 2445165360 | 1239353280 | |
root | wait/io/file/sql/misc | 3 | 279842112 | 236476416 | |
root | wait/io/file/csv/data | 4 | 104246736 | 40159152 | |
root | wait/io/file/sql/binlog_index | 2 | 5535552 | 3505392 |
|