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 | 3271 | 4657621898160 | 0 | 1423913568 | 238437168816 | 1511 | 29868032 | 19767.0629 | 1248 | 48971776 | 39240.2051 | 78839808 | |
sql/io_cache | 291 | 86491910208 | 0 | 297222816 | 74938409040 | 128 | 7032454 | 54941.0469 | 118 | 7023706 | 59522.9322 | 14056160 | |
innodb/innodb_temp_file | 288 | 1009759529328 | 0 | 3506109288 | 91521852048 | 0 | 0 | 0.0000 | 203 | 5619712 | 27683.3103 | 5619712 | |
sql/ERRMSG | 60 | 38984396352 | 2087712 | 649739904 | 2824118352 | 36 | 3685521 | 102375.5833 | 0 | 0 | 0.0000 | 3685521 | |
innodb/innodb_log_file | 992 | 5734587787104 | 225984 | 5780834400 | 66252141648 | 8 | 70656 | 8832.0000 | 586 | 602624 | 1028.3686 | 673280 | |
mysys/charset | 3 | 285612624 | 2117808 | 95204208 | 270948480 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 419 | 343786598496 | 0 | 820492992 | 41803278000 | 93 | 968 | 10.4086 | 20 | 7531 | 376.5500 | 8499 | |
myisam/kfile | 16 | 1809897936 | 628848 | 113118456 | 674303520 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | 1703 | |
sql/binlog_index | 38 | 53199003792 | 0 | 1399973784 | 28980230400 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2197926192 | 1002144 | 274740576 | 1292414112 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 474758592 | 275616 | 94951560 | 456456528 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 68445168 | 5137968 | 22814880 | 50582928 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 721327728 | 0 | 48088392 | 650074656 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 5 | 107216208 | 0 | 21443136 | 34704384 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 665567760 | 0 | 166391808 | 602982336 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 8 | 56456400 | 330528 | 7056984 | 27806064 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|