SELECT * FROM `x$user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 2926 | 12761424422208 | 83108643552 | |
background | wait/io/file/innodb/innodb_data_file | 3567 | 5757676294656 | 1013083075488 | |
background | wait/io/file/innodb/innodb_temp_file | 81 | 391998032976 | 29635887600 | |
background | wait/io/file/sql/binlog_index | 36 | 48256676160 | 26313887952 | |
background | wait/io/file/sql/binlog | 37 | 33943575600 | 16119967248 | |
background | wait/io/file/sql/ERRMSG | 5 | 2225581248 | 1424457936 | |
background | wait/io/file/sql/casetest | 15 | 1100043648 | 1034840400 | |
background | wait/io/file/mysys/cnf | 5 | 463030128 | 443220624 | |
background | wait/io/file/mysys/charset | 3 | 332276736 | 319271040 | |
background | wait/io/file/sql/pid | 3 | 55850256 | 35049696 | |
background | wait/io/file/sql/misc | 1 | 3457872 | 3457872 | |
root | wait/io/file/innodb/innodb_data_file | 804 | 1212179071488 | 38693363280 | |
root | wait/io/file/sql/binlog | 1248 | 1042164894672 | 40185303840 | |
root | wait/io/file/sql/ERRMSG | 35 | 23128156656 | 3614040672 | |
root | wait/io/file/innodb/innodb_temp_file | 2 | 18366082944 | 18307377264 | |
root | wait/io/file/csv/metadata | 8 | 1627961280 | 573347808 | |
root | wait/io/file/myisam/dfile | 4 | 682840752 | 636099024 | |
root | wait/io/file/myisam/kfile | 4 | 479943552 | 310747008 | |
root | wait/io/file/sql/misc | 13 | 435194496 | 241826640 | |
root | wait/io/file/csv/data | 4 | 71652768 | 40557264 | |
root | wait/io/file/sql/binlog_index | 2 | 5049264 | 3060816 |
|