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 | 1806 | 1809150304896 | 0 | 1001744304 | 260310600528 | 1263 | 25804800 | 20431.3539 | 310 | 19808256 | 63897.6000 | 45613056 | |
sql/ERRMSG | 60 | 33556591728 | 3195984 | 559276344 | 4883879616 | 36 | 3684501 | 102347.2500 | 0 | 0 | 0.0000 | 3684501 | |
innodb/innodb_temp_file | 132 | 883514246736 | 0 | 6693289680 | 42151847232 | 0 | 0 | 0.0000 | 55 | 2670592 | 48556.2182 | 2670592 | |
innodb/innodb_log_file | 251 | 1682010390720 | 225456 | 6701236608 | 112885764288 | 8 | 70656 | 8832.0000 | 142 | 150016 | 1056.4507 | 220672 | |
mysys/charset | 3 | 306168192 | 2918256 | 102056064 | 286171248 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 191 | 202695653952 | 0 | 1061233536 | 123608327040 | 43 | 768 | 17.8605 | 6 | 1012 | 168.6667 | 1780 | |
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 | 3 | 152400864 | 0 | 50800200 | 132475728 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|