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 | 2350 | 1487552871552 | 0 | 633000984 | 73965088032 | 1582 | 32063488 | 20267.6915 | 365 | 21118976 | 57860.2082 | 53182464 | |
sql/io_cache | 368 | 46519558800 | 0 | 126411648 | 20444976816 | 164 | 9068676 | 55296.8049 | 154 | 9068676 | 58887.5065 | 18137352 | |
innodb/innodb_temp_file | 438 | 766349099472 | 0 | 1749655248 | 36856703664 | 0 | 0 | 0.0000 | 349 | 8273920 | 23707.5072 | 8273920 | |
sql/ERRMSG | 65 | 30621952416 | 2172720 | 471106944 | 3916135872 | 39 | 3995278 | 102443.0256 | 0 | 0 | 0.0000 | 3995278 | |
innodb/innodb_log_file | 346 | 1826772514512 | 228096 | 5279689272 | 46707145584 | 8 | 70656 | 8832.0000 | 194 | 184832 | 952.7423 | 255488 | |
sql/binlog | 423 | 71471415312 | 0 | 168962904 | 22485771264 | 106 | 51927 | 489.8774 | 5 | 743 | 148.6000 | 52670 | |
mysys/charset | 3 | 182858016 | 1090320 | 60952584 | 174340320 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog_index | 23 | 2658445152 | 0 | 115584480 | 1612268064 | 5 | 224 | 44.8000 | 0 | 0 | 0.0000 | 224 | |
mysys/cnf | 5 | 1201346256 | 178992 | 240269040 | 1184068512 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 44900592 | 2458896 | 14966688 | 35302608 | 0 | 0 | 0.0000 | 1 | 5 | 5.0000 | 5 | |
sql/casetest | 15 | 888021024 | 0 | 59201208 | 831639072 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 16751856 | 0 | 8375928 | 8870400 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|