SELECT * FROM `x$user_summary_by_file_io_type`
|
user | event_name | total | latency | max_latency | |
---|---|---|---|---|---|
background | wait/io/file/innodb/innodb_log_file | 1171 | 6040229828160 | 116273443968 | |
background | wait/io/file/innodb/innodb_data_file | 2868 | 2212890600624 | 212631757008 | |
background | wait/io/file/innodb/innodb_temp_file | 83 | 306914353680 | 19815427104 | |
background | wait/io/file/sql/binlog_index | 36 | 55460360208 | 33946737792 | |
background | wait/io/file/sql/binlog | 37 | 30599869872 | 17067959568 | |
background | wait/io/file/mysys/cnf | 5 | 1721957424 | 1704012288 | |
background | wait/io/file/sql/ERRMSG | 5 | 1173678000 | 466832784 | |
background | wait/io/file/sql/casetest | 15 | 973536432 | 910188048 | |
background | wait/io/file/mysys/charset | 3 | 256080528 | 241688304 | |
background | wait/io/file/sql/pid | 3 | 12593856 | 10365168 | |
background | wait/io/file/sql/misc | 1 | 3222384 | 3222384 | |
root | wait/io/file/innodb/innodb_data_file | 244 | 70575498048 | 5148829488 | |
root | wait/io/file/innodb/innodb_temp_file | 6 | 69141727776 | 33093629184 | |
root | wait/io/file/sql/ERRMSG | 50 | 27067318608 | 3273138528 | |
root | wait/io/file/sql/binlog | 672 | 5620899504 | 1844564304 | |
root | wait/io/file/csv/metadata | 8 | 901218384 | 462227040 | |
root | wait/io/file/csv/data | 4 | 44618640 | 21905664 | |
root | wait/io/file/sql/binlog_index | 2 | 4762032 | 3269376 |
|