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 | 2696 | 2357101750608 | 0 | 874295664 | 221116210128 | 1229 | 25247744 | 20543.3230 | 1167 | 47071232 | 40335.2459 | 72318976 | |
sql/ERRMSG | 40 | 20196644688 | 3523344 | 504916104 | 3199107648 | 24 | 2465379 | 102724.1250 | 0 | 0 | 0.0000 | 2465379 | |
innodb/innodb_temp_file | 93 | 377792642304 | 0 | 4062286272 | 28676036400 | 0 | 0 | 0.0000 | 32 | 1245184 | 38912.0000 | 1245184 | |
innodb/innodb_log_file | 985 | 5137122422784 | 227040 | 5215352472 | 134007513024 | 8 | 70656 | 8832.0000 | 602 | 477184 | 792.6645 | 547840 | |
mysys/charset | 3 | 259097520 | 3311616 | 86365752 | 240466512 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 166 | 39621914640 | 0 | 238686096 | 19374493776 | 39 | 899 | 23.0513 | 3 | 156 | 52.0000 | 1055 | |
sql/binlog_index | 38 | 52790407296 | 0 | 1389221064 | 29637031248 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1075628928 | 265056 | 215125680 | 1052486160 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 680796336 | 486816 | 170198952 | 552852960 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 48518976 | 2766192 | 16172904 | 37946304 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1022986800 | 0 | 68199120 | 918319248 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 8980224 | 0 | 8980224 | 8980224 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 14022096 | 0 | 7011048 | 9120672 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|