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 | 2736 | 3152732225280 | 0 | 1152314328 | 188781886656 | 1401 | 28065792 | 20032.6852 | 914 | 38715392 | 42358.1969 | 66781184 | |
sql/ERRMSG | 50 | 34813760784 | 2761968 | 696275184 | 3564680592 | 30 | 3074958 | 102498.6000 | 0 | 0 | 0.0000 | 3074958 | |
innodb/innodb_temp_file | 108 | 481173758736 | 0 | 4455312576 | 43748242560 | 0 | 0 | 0.0000 | 42 | 1736704 | 41350.0952 | 1736704 | |
innodb/innodb_log_file | 746 | 4450972295088 | 222288 | 5966450688 | 108660565728 | 8 | 70656 | 8832.0000 | 441 | 480768 | 1090.1769 | 551424 | |
mysys/charset | 3 | 291259584 | 2387616 | 97086528 | 274430112 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 531 | 178026423696 | 0 | 335266272 | 27557859120 | 125 | 1096 | 8.7680 | 12 | 2822 | 235.1667 | 3918 | |
myisam/kfile | 8 | 3181839408 | 518496 | 397729728 | 2872910832 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | 834 | |
sql/binlog_index | 38 | 45062148912 | 0 | 1185846024 | 28846088304 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1650871200 | 164208 | 330174240 | 1626563664 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 475856832 | 482592 | 118964208 | 398192256 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 25556256 | 1381776 | 8518752 | 20205504 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 721550016 | 0 | 48103176 | 658399632 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 4 | 75660288 | 0 | 18915072 | 30100752 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 172276368 | 0 | 86138184 | 163187904 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 24330768 | 303600 | 6082560 | 16465680 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|