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 | 2624 | 2994008815776 | 0 | 1141009320 | 254264789856 | 1389 | 27869184 | 20064.2073 | 803 | 34684928 | 43194.1818 | 62554112 | |
innodb/innodb_temp_file | 147 | 1440696695856 | 0 | 9800657592 | 599957440896 | 0 | 0 | 0.0000 | 66 | 3112960 | 47166.0606 | 3112960 | |
sql/ERRMSG | 45 | 23159059968 | 2734512 | 514645560 | 4617447120 | 27 | 2770368 | 102606.2222 | 0 | 0 | 0.0000 | 2770368 | |
innodb/innodb_log_file | 581 | 3760470801120 | 228624 | 6472410912 | 259781341776 | 8 | 70656 | 8832.0000 | 333 | 292864 | 879.4715 | 363520 | |
mysys/charset | 3 | 262978848 | 2073456 | 87659616 | 251044992 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 125 | 83439316752 | 0 | 667514496 | 27556310496 | 27 | 704 | 26.0741 | 5 | 600 | 120.0000 | 1304 | |
sql/binlog_index | 38 | 69106323264 | 0 | 1818587232 | 36383164752 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 517715088 | 149952 | 103542912 | 501350256 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 52643712 | 3067152 | 17547816 | 40858224 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 725116656 | 0 | 48341040 | 664429920 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 2 | 245588640 | 0 | 122794320 | 232526976 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|