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 | 2808 | 2901436818720 | 0 | 1033275144 | 238437168816 | 1502 | 29720576 | 19787.3342 | 927 | 39141376 | 42223.7066 | 68861952 | |
sql/io_cache | 261 | 85158353808 | 0 | 326277072 | 74938409040 | 120 | 6474630 | 53955.2500 | 106 | 6474630 | 61081.4151 | 12949260 | |
innodb/innodb_temp_file | 270 | 897286437168 | 0 | 3323282952 | 91521852048 | 0 | 0 | 0.0000 | 191 | 5029888 | 26334.4921 | 5029888 | |
sql/ERRMSG | 60 | 38984396352 | 2087712 | 649739904 | 2824118352 | 36 | 3685521 | 102375.5833 | 0 | 0 | 0.0000 | 3685521 | |
innodb/innodb_log_file | 722 | 3946519627776 | 225984 | 5466093600 | 66252141648 | 8 | 70656 | 8832.0000 | 427 | 416768 | 976.0375 | 487424 | |
mysys/charset | 3 | 285612624 | 2117808 | 95204208 | 270948480 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 287 | 222749168928 | 0 | 776129376 | 37416358848 | 63 | 848 | 13.4603 | 14 | 5647 | 403.3571 | 6495 | |
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 | 2 | 25307040 | 0 | 12653520 | 13080672 | 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 |
|