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 | 1490 | 857295121056 | 0 | 575365824 | 260310600528 | 1176 | 24379392 | 20730.7755 | 160 | 15220736 | 95129.6000 | 39600128 | |
sql/ERRMSG | 40 | 23578042224 | 3195984 | 589451016 | 4883879616 | 24 | 2445858 | 101910.7500 | 0 | 0 | 0.0000 | 2445858 | |
innodb/innodb_temp_file | 112 | 749430306240 | 0 | 6691341888 | 39130316016 | 0 | 0 | 0.0000 | 41 | 2048000 | 49951.2195 | 2048000 | |
innodb/innodb_log_file | 82 | 508284271440 | 225456 | 6198588528 | 80289640464 | 8 | 70656 | 8832.0000 | 41 | 64512 | 1573.4634 | 135168 | |
mysys/charset | 3 | 306168192 | 2918256 | 102056064 | 286171248 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 81 | 50707467888 | 0 | 626017920 | 31290922608 | 17 | 664 | 39.0588 | 3 | 156 | 52.0000 | 820 | |
sql/binlog_index | 38 | 70297792224 | 0 | 1849941720 | 45391595040 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 3362881632 | 645744 | 672576168 | 3319165344 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 47718528 | 2735568 | 15906000 | 37749360 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1280488176 | 0 | 85365720 | 1201203696 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 7315440 | 0 | 7315440 | 7315440 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|