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 | 1769 | 1631625372960 | 0 | 922343136 | 260310600528 | 1261 | 25772032 | 20437.7732 | 291 | 19316736 | 66380.5361 | 45088768 | |
sql/ERRMSG | 50 | 27600261744 | 3195984 | 552004992 | 4883879616 | 30 | 3061283 | 102042.7667 | 0 | 0 | 0.0000 | 3061283 | |
innodb/innodb_temp_file | 132 | 883514246736 | 0 | 6693289680 | 42151847232 | 0 | 0 | 0.0000 | 55 | 2670592 | 48556.2182 | 2670592 | |
innodb/innodb_log_file | 229 | 1526745423984 | 225456 | 6667010328 | 112885764288 | 8 | 70656 | 8832.0000 | 130 | 143872 | 1106.7077 | 214528 | |
mysys/charset | 3 | 306168192 | 2918256 | 102056064 | 286171248 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 163 | 202553134608 | 0 | 1242657240 | 123608327040 | 36 | 740 | 20.5556 | 6 | 1012 | 168.6667 | 1752 | |
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 |
|