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 | 1654 | 1139334731568 | 0 | 688835928 | 260310600528 | 1244 | 25493504 | 20493.1704 | 223 | 17121280 | 76777.0404 | 42614784 | |
sql/ERRMSG | 45 | 24930540096 | 3195984 | 554011920 | 4883879616 | 27 | 2750124 | 101856.4444 | 0 | 0 | 0.0000 | 2750124 | |
innodb/innodb_temp_file | 132 | 883514246736 | 0 | 6693289680 | 42151847232 | 0 | 0 | 0.0000 | 55 | 2670592 | 48556.2182 | 2670592 | |
innodb/innodb_log_file | 152 | 982727437296 | 225456 | 6465311952 | 112885764288 | 8 | 70656 | 8832.0000 | 82 | 85504 | 1042.7317 | 156160 | |
mysys/charset | 3 | 306168192 | 2918256 | 102056064 | 286171248 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 155 | 176644874736 | 0 | 1139644176 | 123608327040 | 35 | 736 | 21.0286 | 4 | 426 | 106.5000 | 1162 | |
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 | 2 | 139791168 | 0 | 69895584 | 132475728 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|