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 | 2891 | 3875888742528 | 0 | 1340673840 | 240508788432 | 1405 | 28131328 | 20022.2975 | 1030 | 42287104 | 41055.4408 | 70418432 | |
innodb/innodb_temp_file | 210 | 1060233795984 | 0 | 5048732304 | 192861578976 | 0 | 0 | 0.0000 | 131 | 4046848 | 30891.9695 | 4046848 | |
sql/ERRMSG | 50 | 44180075808 | 2725008 | 883601400 | 16349165184 | 30 | 3074711 | 102490.3667 | 0 | 0 | 0.0000 | 3074711 | |
sql/io_cache | 52 | 3453342816 | 0 | 66410256 | 1396869408 | 20 | 1282986 | 64149.3000 | 22 | 1282986 | 58317.5455 | 2565972 | |
innodb/innodb_log_file | 897 | 5249338720032 | 228624 | 5852105424 | 45643329072 | 8 | 70656 | 8832.0000 | 535 | 566784 | 1059.4093 | 637440 | |
mysys/charset | 3 | 279603984 | 1966800 | 93201240 | 266722368 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 227 | 206584883472 | 0 | 910065552 | 33693563904 | 49 | 792 | 16.1633 | 12 | 4333 | 361.0833 | 5125 | |
myisam/kfile | 4 | 1823976528 | 542256 | 455994000 | 1800383904 | 2 | 392 | 196.0000 | 0 | 0 | 0.0000 | 392 | |
sql/binlog_index | 38 | 46078281744 | 0 | 1212586320 | 27516535728 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 779006976 | 237600 | 155801184 | 756171504 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 633168096 | 966240 | 158292024 | 543671040 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 47389056 | 2580864 | 15796176 | 36837504 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 936889008 | 0 | 62459232 | 858818400 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 5 | 59533584 | 0 | 11906664 | 13865280 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 8 | 285098880 | 0 | 35637360 | 240061008 | 3 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 20254080 | 248160 | 5063520 | 10132848 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|