SELECT * FROM `x$user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 456 | 2619480933168 | 75712846176 | |
background | wait/io/file/innodb/innodb_data_file | 2012 | 2430826938144 | 269024469648 | |
background | wait/io/file/innodb/innodb_temp_file | 204 | 308638504416 | 24641749440 | |
background | wait/io/file/sql/binlog_index | 36 | 44532204288 | 26920753200 | |
background | wait/io/file/sql/binlog | 37 | 39599425536 | 26009121072 | |
background | wait/io/file/sql/ERRMSG | 5 | 1272526464 | 422303904 | |
background | wait/io/file/sql/casetest | 15 | 777302064 | 703951248 | |
background | wait/io/file/mysys/cnf | 5 | 615337008 | 592396992 | |
background | wait/io/file/mysys/charset | 3 | 252366576 | 239019264 | |
background | wait/io/file/sql/pid | 3 | 23300112 | 13526304 | |
background | wait/io/file/sql/misc | 1 | 2742960 | 2742960 | |
root | wait/io/file/innodb/innodb_temp_file | 74 | 706215882240 | 29237761344 | |
root | wait/io/file/sql/binlog | 460 | 161461632288 | 30980635488 | |
root | wait/io/file/innodb/innodb_data_file | 401 | 107443971888 | 14129867136 | |
root | wait/io/file/sql/io_cache | 526 | 70752118800 | 32230736736 | |
root | wait/io/file/sql/ERRMSG | 45 | 27714818736 | 2822892864 | |
root | wait/io/file/myisam/kfile | 16 | 9773495424 | 6897871728 | |
root | wait/io/file/sql/binlog_index | 2 | 179584944 | 177977184 | |
root | wait/io/file/sql/misc | 3 | 91246320 | 68480016 | |
root | wait/io/file/myisam/dfile | 8 | 77865744 | 30187872 |
|