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 | 3022 | 4237267262448 | 0 | 1402139904 | 254264789856 | 1404 | 28114944 | 20024.8889 | 1064 | 42450944 | 39897.5038 | 70565888 | |
innodb/innodb_temp_file | 365 | 2151689625360 | 0 | 5895040008 | 599957440896 | 0 | 0 | 0.0000 | 270 | 7372800 | 27306.6667 | 7372800 | |
sql/io_cache | 78 | 3681987936 | 0 | 47204784 | 2398805376 | 36 | 1925908 | 53497.4444 | 32 | 1925908 | 60184.6250 | 3851816 | |
sql/ERRMSG | 50 | 25218082032 | 2734512 | 504361440 | 4617447120 | 30 | 3074804 | 102493.4667 | 0 | 0 | 0.0000 | 3074804 | |
innodb/innodb_log_file | 842 | 5262188202480 | 228624 | 6249629496 | 259781341776 | 8 | 70656 | 8832.0000 | 485 | 411136 | 847.7031 | 481792 | |
mysys/charset | 3 | 262978848 | 2073456 | 87659616 | 251044992 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 181 | 225043610352 | 0 | 1243334664 | 27556310496 | 37 | 744 | 20.1081 | 13 | 2784 | 214.1538 | 3528 | |
myisam/kfile | 4 | 509581248 | 742368 | 127395312 | 487877280 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
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 | 3 | 258134976 | 0 | 86044992 | 232526976 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 1 | 10060512 | 10060512 | 10060512 | 10060512 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|