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 | 2793 | 2839933238736 | 0 | 1016803656 | 238437168816 | 1502 | 29720576 | 19787.3342 | 917 | 38879232 | 42398.2901 | 68599808 | |
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 | 171 | 801476309568 | 0 | 4686995808 | 91521852048 | 0 | 0 | 0.0000 | 95 | 3260416 | 34320.1684 | 3260416 | |
innodb/innodb_log_file | 711 | 3869016096528 | 225984 | 5441654064 | 66252141648 | 8 | 70656 | 8832.0000 | 421 | 413696 | 982.6508 | 484352 | |
mysys/charset | 3 | 285612624 | 2117808 | 95204208 | 270948480 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 255 | 222586739760 | 0 | 872889072 | 37416358848 | 55 | 816 | 14.8364 | 14 | 5647 | 403.3571 | 6463 | |
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 |
|