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 | 1588 | 302241457584 | 0 | 190328160 | 59703357120 | 1219 | 26361856 | 21625.8048 | 160 | 15220736 | 95129.6000 | 41582592 | |
innodb/innodb_temp_file | 93 | 333813180096 | 0 | 3589388880 | 28952334576 | 0 | 0 | 0.0000 | 32 | 1245184 | 38912.0000 | 1245184 | |
sql/ERRMSG | 10 | 7456550640 | 6312768 | 745655064 | 3442136016 | 6 | 608668 | 101444.6667 | 0 | 0 | 0.0000 | 608668 | |
innodb/innodb_log_file | 44 | 120974289216 | 236544 | 2749415592 | 15685802880 | 8 | 70656 | 8832.0000 | 20 | 46080 | 2304.0000 | 116736 | |
mysys/charset | 3 | 443030016 | 7337088 | 147676584 | 401792688 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 47 | 34448404848 | 0 | 732944784 | 22179567696 | 10 | 9273 | 927.3000 | 3 | 156 | 52.0000 | 9429 | |
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 |
|