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 | 1844 | 1532050921104 | 0 | 830830176 | 219197557920 | 1262 | 25788416 | 20434.5610 | 375 | 21676032 | 57802.7520 | 47464448 | |
sql/io_cache | 95 | 22528947408 | 0 | 237146712 | 13769296992 | 34 | 2330060 | 68531.1765 | 41 | 2330060 | 56830.7317 | 4660120 | |
innodb/innodb_temp_file | 222 | 536590395792 | 0 | 2417073648 | 27144528048 | 0 | 0 | 0.0000 | 158 | 3506176 | 22190.9873 | 3506176 | |
sql/ERRMSG | 25 | 19258938336 | 2547600 | 770357280 | 4233154464 | 15 | 1531208 | 102080.5333 | 0 | 0 | 0.0000 | 1531208 | |
innodb/innodb_log_file | 412 | 2976554528112 | 228624 | 7224646704 | 732075747744 | 8 | 70656 | 8832.0000 | 241 | 222208 | 922.0249 | 292864 | |
mysys/charset | 3 | 311625072 | 2488464 | 103875024 | 297535392 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 77 | 36920793360 | 0 | 479490792 | 16813685856 | 16 | 660 | 41.2500 | 3 | 156 | 52.0000 | 816 | |
sql/binlog_index | 38 | 57926488224 | 0 | 1524381144 | 30399215616 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 575916000 | 180576 | 115183200 | 559968288 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 501719856 | 711216 | 125429832 | 426005712 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 50532768 | 2847504 | 16844256 | 39169680 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 796932576 | 0 | 53128680 | 734420544 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 10096416 | 0 | 10096416 | 10096416 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 16808352 | 0 | 8404176 | 11054736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|