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 | 5724 | 11587590082992 | 0 | 2024386584 | 519658791696 | 1495 | 29605888 | 19803.2696 | 3025 | 108740608 | 35947.3084 | 138346496 | |
sql/io_cache | 791 | 156114280608 | 0 | 197362968 | 43942661136 | 409 | 18844618 | 46074.8606 | 312 | 18844618 | 60399.4167 | 37689236 | |
innodb/innodb_temp_file | 398 | 980649412512 | 0 | 2463943152 | 82541036688 | 0 | 0 | 0.0000 | 313 | 7421952 | 23712.3067 | 7421952 | |
innodb/innodb_log_file | 4142 | 20929846204608 | 238656 | 5053077216 | 591224951328 | 8 | 70656 | 8832.0000 | 2735 | 4980736 | 1821.1101 | 5051392 | |
sql/ERRMSG | 75 | 68606821536 | 3400320 | 914757360 | 5944207632 | 45 | 4600824 | 102240.5333 | 0 | 0 | 0.0000 | 4600824 | |
sql/binlog | 561 | 1292946224592 | 0 | 2304716832 | 30396075600 | 94 | 972 | 10.3404 | 89 | 46856 | 526.4719 | 47828 | |
mysys/charset | 3 | 289078416 | 2702832 | 96359472 | 270186048 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
myisam/kfile | 4 | 587172960 | 2465232 | 146793240 | 528924000 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 42613047840 | 0 | 1121395968 | 25739955648 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 448626816 | 145728 | 89725152 | 428210640 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 11452945680 | 494208 | 2863236288 | 9103606512 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 14327280 | 726000 | 4775760 | 10661376 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 786055248 | 0 | 52403472 | 707000448 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 7 | 2101390896 | 0 | 300198624 | 1846735440 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 9 | 301885584 | 0 | 33542784 | 246721728 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 32393328 | 6767904 | 16196664 | 25625424 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|