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 | 2339 | 2004800790960 | 0 | 857118504 | 218748299088 | 1367 | 27508736 | 20123.4353 | 627 | 29507584 | 47061.5375 | 57016320 | |
sql/io_cache | 90 | 2139928560 | 0 | 23776896 | 491571168 | 24 | 1673472 | 69728.0000 | 36 | 1647228 | 45756.3333 | 3320700 | |
sql/ERRMSG | 50 | 46622105376 | 2572416 | 932441928 | 6159199200 | 30 | 3071272 | 102375.7333 | 0 | 0 | 0.0000 | 3071272 | |
innodb/innodb_temp_file | 90 | 388650991344 | 0 | 4318344096 | 38735426928 | 0 | 0 | 0.0000 | 30 | 1146880 | 38229.3333 | 1146880 | |
innodb/innodb_log_file | 501 | 2700774125808 | 226512 | 5390766480 | 38512050192 | 8 | 70656 | 8832.0000 | 290 | 245248 | 845.6828 | 315904 | |
mysys/charset | 3 | 277377408 | 1949376 | 92459136 | 266080320 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 129 | 40778400960 | 0 | 316111488 | 19250616528 | 29 | 712 | 24.5517 | 3 | 156 | 52.0000 | 868 | |
sql/binlog_index | 38 | 43663942608 | 0 | 1149051024 | 24890170272 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 441089616 | 156288 | 88217712 | 423359904 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
csv/metadata | 4 | 379895472 | 628848 | 94973736 | 323330304 | 1 | 35 | 35.0000 | 0 | 0 | 0.0000 | 35 | |
sql/pid | 3 | 46338864 | 2683296 | 15446112 | 36406128 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1204416048 | 0 | 80294280 | 1142801088 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 5793744 | 0 | 5793744 | 5793744 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 2 | 14508384 | 0 | 7254192 | 9555216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|