SELECT * FROM `x$user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 2235 | 9872564491680 | 141877032000 | |
background | wait/io/file/innodb/innodb_data_file | 3206 | 4776666846336 | 211082690016 | |
background | wait/io/file/innodb/innodb_temp_file | 122 | 332830402608 | 22185352992 | |
background | wait/io/file/sql/binlog_index | 36 | 43006580496 | 24694970256 | |
background | wait/io/file/sql/binlog | 37 | 34818028080 | 17385885792 | |
background | wait/io/file/mysys/cnf | 5 | 1759646064 | 1712328288 | |
background | wait/io/file/sql/ERRMSG | 5 | 1355789952 | 395648352 | |
background | wait/io/file/sql/casetest | 15 | 817115904 | 722290800 | |
background | wait/io/file/mysys/charset | 3 | 237329136 | 218566656 | |
background | wait/io/file/sql/pid | 3 | 13465056 | 10730544 | |
background | wait/io/file/sql/misc | 1 | 5978016 | 5978016 | |
root | wait/io/file/innodb/innodb_temp_file | 74 | 781636301952 | 34275409872 | |
root | wait/io/file/sql/binlog | 1180 | 740861535216 | 42184348800 | |
root | wait/io/file/innodb/innodb_data_file | 526 | 217714251216 | 19563245856 | |
root | wait/io/file/sql/ERRMSG | 65 | 49576642368 | 7254759600 | |
root | wait/io/file/csv/metadata | 8 | 1498239600 | 451635360 | |
root | wait/io/file/myisam/kfile | 4 | 328372704 | 133755600 | |
root | wait/io/file/sql/misc | 7 | 150291504 | 61996704 | |
root | wait/io/file/myisam/dfile | 4 | 97654128 | 26185632 | |
root | wait/io/file/csv/data | 4 | 96025776 | 35691744 | |
root | wait/io/file/sql/binlog_index | 2 | 9516144 | 6921024 |
|