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 | 6149 | 11470407569280 | 0 | 1865410008 | 651161022336 | 1386 | 27820032 | 20072.1732 | 3396 | 118210560 | 34808.7633 | 146030592 | |
sql/io_cache | 866 | 221443506240 | 0 | 255708288 | 58484599536 | 362 | 20328132 | 56155.0608 | 354 | 20301888 | 57349.9661 | 40630020 | |
innodb/innodb_temp_file | 601 | 938445076272 | 0 | 1561472616 | 105818279952 | 0 | 0 | 0.0000 | 512 | 10944512 | 21376.0000 | 10944512 | |
sql/ERRMSG | 80 | 45276192720 | 3061872 | 565952376 | 3153458352 | 48 | 4906165 | 102211.7708 | 0 | 0 | 0.0000 | 4906165 | |
innodb/innodb_log_file | 4187 | 20143625927568 | 299376 | 4810992384 | 181175352336 | 8 | 70656 | 8832.0000 | 2712 | 4427264 | 1632.4720 | 4497920 | |
sql/binlog | 627 | 1719141389328 | 0 | 2741852256 | 39017365200 | 95 | 976 | 10.2737 | 120 | 41096 | 342.4667 | 42072 | |
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 | 17 | 403056720 | 0 | 23709048 | 190668720 | 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 |
|