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 | 7407 | 14356623162816 | 0 | 1938250512 | 651161022336 | 1386 | 27820032 | 20072.1732 | 4305 | 148193280 | 34423.5261 | 176013312 | |
sql/io_cache | 1226 | 253714442784 | 0 | 206944848 | 58484599536 | 533 | 29087508 | 54573.1857 | 498 | 29061264 | 58355.9518 | 58148772 | |
innodb/innodb_temp_file | 705 | 1076840082384 | 0 | 1527432720 | 105818279952 | 0 | 0 | 0.0000 | 610 | 12943360 | 21218.6230 | 12943360 | |
innodb/innodb_log_file | 5907 | 27877393210656 | 299376 | 4719382536 | 181175352336 | 8 | 70656 | 8832.0000 | 3853 | 6751232 | 1752.2014 | 6821888 | |
sql/ERRMSG | 80 | 45276192720 | 3061872 | 565952376 | 3153458352 | 48 | 4906165 | 102211.7708 | 0 | 0 | 0.0000 | 4906165 | |
sql/binlog | 705 | 1969382058864 | 0 | 2793449472 | 39017365200 | 105 | 1016 | 9.6762 | 139 | 47961 | 345.0432 | 48977 | |
mysys/charset | 3 | 311010480 | 3950496 | 103670160 | 268934688 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog_index | 38 | 45814246368 | 0 | 1205637840 | 25838526384 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 2130531744 | 1723392 | 266316336 | 1121824704 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 2250708768 | 165792 | 450141648 | 2233388784 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 40799616 | 2208096 | 13599696 | 32678976 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 1114827648 | 0 | 74321808 | 983498736 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 18 | 868121232 | 0 | 48228840 | 465064512 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 4 | 103759920 | 0 | 25939848 | 39615840 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 4 | 90579984 | 0 | 22644864 | 35556048 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/kfile | 4 | 467476416 | 0 | 116869104 | 206004480 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|