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 | 1636 | 313811077536 | 0 | 191815800 | 59703357120 | 1267 | 27148288 | 21427.2202 | 160 | 15220736 | 95129.6000 | 42369024 | |
sql/io_cache | 104 | 18862065552 | 0 | 181365888 | 10950693600 | 36 | 2651732 | 73659.2222 | 48 | 2651732 | 55244.4167 | 5303464 | |
innodb/innodb_temp_file | 280 | 398232014400 | 0 | 1422256968 | 28952334576 | 0 | 0 | 0.0000 | 215 | 4505600 | 20956.2791 | 4505600 | |
sql/ERRMSG | 25 | 17572215408 | 5027616 | 702888384 | 3442136016 | 15 | 1535919 | 102394.6000 | 0 | 0 | 0.0000 | 1535919 | |
innodb/innodb_log_file | 53 | 165916766928 | 236544 | 3130504872 | 22599006672 | 8 | 70656 | 8832.0000 | 25 | 56320 | 2252.8000 | 126976 | |
mysys/charset | 3 | 443030016 | 7337088 | 147676584 | 401792688 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 63 | 35102548800 | 0 | 557183088 | 22179567696 | 14 | 9289 | 663.5000 | 3 | 156 | 52.0000 | 9445 | |
sql/binlog_index | 23 | 784074192 | 0 | 34090056 | 260070096 | 5 | 288 | 57.6000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 214828416 | 151008 | 42965472 | 194608656 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 13544256 | 625680 | 4514664 | 11204160 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 | 5 | |
sql/casetest | 15 | 844752480 | 0 | 56316744 | 746966880 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 6040320 | 0 | 6040320 | 6040320 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|