SELECT * FROM `x$user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 177 | 813209666544 | 36603060912 | |
background | wait/io/file/innodb/innodb_data_file | 1520 | 635703225168 | 224683002720 | |
background | wait/io/file/innodb/innodb_temp_file | 83 | 326451952464 | 26098907472 | |
background | wait/io/file/sql/binlog_index | 36 | 50954796288 | 33570265344 | |
background | wait/io/file/sql/binlog | 37 | 35489687376 | 21710499360 | |
background | wait/io/file/sql/ERRMSG | 5 | 1212870384 | 538174560 | |
background | wait/io/file/sql/casetest | 15 | 886885824 | 784058880 | |
background | wait/io/file/mysys/cnf | 5 | 845663808 | 822551136 | |
background | wait/io/file/mysys/charset | 3 | 301625280 | 264464112 | |
background | wait/io/file/sql/pid | 3 | 14344704 | 11449152 | |
background | wait/io/file/sql/misc | 1 | 6142752 | 6142752 | |
root | wait/io/file/innodb/innodb_temp_file | 10 | 155724236448 | 88384798128 | |
root | wait/io/file/innodb/innodb_data_file | 132 | 39302853216 | 3605947488 | |
root | wait/io/file/sql/ERRMSG | 25 | 19928118672 | 3209814960 | |
root | wait/io/file/sql/binlog | 62 | 15331119408 | 13080491424 | |
root | wait/io/file/csv/metadata | 8 | 1429523040 | 702172416 | |
root | wait/io/file/csv/data | 4 | 37542384 | 11777040 | |
root | wait/io/file/sql/misc | 1 | 9407904 | 9407904 | |
root | wait/io/file/sql/binlog_index | 2 | 4628976 | 3164304 |
|