SELECT * FROM `x$io_global_by_wait_by_bytes`
|
event_name | total | total_latency | min_latency | avg_latency | max_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | total_requested | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_data_file | 4093 | 4081582278576 | 0 | 997210368 | 219411566352 | 1505 | 29769728 | 19780.5502 | 2097 | 76300288 | 36385.4497 | 106070016 | |
sql/io_cache | 478 | 10567240464 | 0 | 22107096 | 2408982576 | 236 | 11578130 | 49059.8729 | 192 | 11578130 | 60302.7604 | 23156260 | |
sql/ERRMSG | 65 | 315158577888 | 2543904 | 4848593376 | 273601399104 | 39 | 3984361 | 102163.1026 | 0 | 0 | 0.0000 | 3984361 | |
innodb/innodb_temp_file | 167 | 1368220346064 | 0 | 8192936136 | 433177047072 | 0 | 0 | 0.0000 | 86 | 3440640 | 40007.4419 | 3440640 | |
innodb/innodb_log_file | 1641 | 8847570526608 | 236016 | 5391572472 | 263690719248 | 8 | 70656 | 8832.0000 | 981 | 796672 | 812.1019 | 867328 | |
mysys/charset | 3 | 204961680 | 1416624 | 68320560 | 191885232 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 209 | 88017316464 | 0 | 421135440 | 28166447232 | 48 | 788 | 16.4167 | 5 | 834 | 166.8000 | 1622 | |
myisam/kfile | 8 | 5312271888 | 1598256 | 664033920 | 4540468416 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | 834 | |
sql/binlog_index | 38 | 65084208816 | 0 | 1712742240 | 30858444672 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 16428687264 | 635712 | 2053585776 | 15271653936 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 553675056 | 150480 | 110734800 | 534004944 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13161984 | 658416 | 4387152 | 10584816 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1197154992 | 0 | 79810104 | 1131872016 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 14206368 | 0 | 7103184 | 10496112 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 16 | 463948848 | 0 | 28996704 | 206629632 | 5 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 7 | 59954928 | 513744 | 8564952 | 33705408 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|