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 | 2583 | 2345386360944 | 0 | 908008464 | 238437168816 | 1501 | 29704192 | 19789.6016 | 746 | 33636352 | 45088.9437 | 63340544 | |
sql/io_cache | 165 | 83436086976 | 0 | 505672992 | 74938409040 | 72 | 4115702 | 57162.5278 | 68 | 4115702 | 60525.0294 | 8231404 | |
sql/ERRMSG | 60 | 38984396352 | 2087712 | 649739904 | 2824118352 | 36 | 3685521 | 102375.5833 | 0 | 0 | 0.0000 | 3685521 | |
innodb/innodb_temp_file | 168 | 758839389792 | 0 | 4516900872 | 91521852048 | 0 | 0 | 0.0000 | 93 | 3162112 | 34001.2043 | 3162112 | |
innodb/innodb_log_file | 649 | 3484344594720 | 225984 | 5368789800 | 66252141648 | 8 | 70656 | 8832.0000 | 386 | 383488 | 993.4922 | 454144 | |
mysys/charset | 3 | 285612624 | 2117808 | 95204208 | 270948480 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 195 | 222252154080 | 0 | 1139754528 | 37416358848 | 40 | 756 | 18.9000 | 14 | 5647 | 403.3571 | 6403 | |
myisam/kfile | 8 | 935002992 | 628848 | 116875176 | 674303520 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | 834 | |
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 | 4 | 19891344 | 330528 | 4972704 | 9797568 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|