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 | 1870 | 1765810081200 | 0 | 944283384 | 241979330208 | 1273 | 25968640 | 20399.5601 | 347 | 20692992 | 59633.9827 | 46661632 | |
sql/ERRMSG | 45 | 21360270624 | 2626800 | 474672528 | 2112442992 | 27 | 2771638 | 102653.2593 | 0 | 0 | 0.0000 | 2771638 | |
innodb/innodb_temp_file | 151 | 588703336320 | 0 | 3898697352 | 34867908768 | 0 | 0 | 0.0000 | 81 | 2637824 | 32565.7284 | 2637824 | |
innodb/innodb_log_file | 310 | 1997130873936 | 286176 | 6442357416 | 77014294368 | 8 | 70656 | 8832.0000 | 174 | 150016 | 862.1609 | 220672 | |
mysys/charset | 3 | 251668560 | 1415040 | 83889432 | 239154432 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 200 | 111843886176 | 0 | 559219320 | 27417454944 | 46 | 927 | 20.1522 | 6 | 867 | 144.5000 | 1794 | |
myisam/dfile | 42 | 2845926336 | 228624 | 67760088 | 2439597600 | 28 | 1792 | 64.0000 | 0 | 0 | 0.0000 | 1792 | |
myisam/kfile | 12 | 2538832032 | 525360 | 211569336 | 1603133136 | 6 | 1261 | 210.1667 | 0 | 0 | 0.0000 | 1261 | |
sql/binlog_index | 38 | 59314300320 | 0 | 1560902640 | 33337065168 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2336510352 | 1632576 | 292063728 | 1079915232 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 663325872 | 346896 | 132665016 | 640392192 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 49205376 | 2737680 | 16401792 | 38181792 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1251205296 | 0 | 83413440 | 1187766096 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 555104352 | 0 | 138776088 | 521184576 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 99247632 | 0 | 24811776 | 35783088 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|