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 | 7934 | 16316016980208 | 0 | 2056467864 | 213384328608 | 1655 | 32227328 | 19472.7057 | 4503 | 151928832 | 33739.4697 | 184156160 | |
sql/io_cache | 204 | 5665112640 | 0 | 27770160 | 1325993328 | 106 | 4618880 | 43574.3396 | 78 | 4618880 | 59216.4103 | 9237760 | |
innodb/innodb_temp_file | 325 | 854299730592 | 0 | 2628614472 | 107473396272 | 0 | 0 | 0.0000 | 244 | 6029312 | 24710.2951 | 6029312 | |
sql/ERRMSG | 90 | 71326908048 | 2869680 | 792521136 | 6354713376 | 54 | 5521354 | 102247.2963 | 0 | 0 | 0.0000 | 5521354 | |
innodb/innodb_log_file | 4808 | 26629864581408 | 230208 | 5538657168 | 213675444048 | 8 | 70656 | 8832.0000 | 3007 | 4104704 | 1365.0496 | 4175360 | |
myisam/dfile | 9008 | 11957115984 | 77616 | 1327128 | 5570260080 | 7628 | 500759 | 65.6475 | 107 | 4144 | 38.7290 | 504903 | |
sql/binlog | 980 | 2105101891728 | 0 | 2148062928 | 28630096176 | 174 | 1880 | 10.8046 | 146 | 86696 | 593.8082 | 88576 | |
sql/SDI | 33 | 1976946048 | 2786784 | 59907408 | 533228256 | 0 | 0 | 0.0000 | 11 | 64052 | 5822.9091 | 64052 | |
mysys/charset | 3 | 278735952 | 2240832 | 92911896 | 267215520 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/kfile | 187 | 4980548496 | 387024 | 26633904 | 1235376912 | 30 | 5930 | 197.6667 | 98 | 4472 | 45.6327 | 10402 | |
sql/binlog_index | 38 | 63680862432 | 0 | 1675812072 | 44336284080 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 724485696 | 715440 | 90560712 | 387658128 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 562605648 | 173184 | 112521024 | 546815280 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 46019952 | 2644224 | 15339984 | 36588816 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
csv/data | 15 | 495368544 | 0 | 33024552 | 415276752 | 5 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 24 | 2854740240 | 0 | 118947312 | 2018942640 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/casetest | 15 | 801702528 | 0 | 53446800 | 734592672 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|