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 | 2436 | 2636939536176 | 0 | 1082487384 | 255763744368 | 1482 | 29392896 | 19833.2632 | 570 | 27410432 | 48088.4772 | 56803328 | |
sql/io_cache | 278 | 204574338672 | 0 | 735878880 | 116131148496 | 104 | 6912908 | 66470.2692 | 124 | 6904160 | 55678.7097 | 13817068 | |
innodb/innodb_temp_file | 249 | 841355275728 | 0 | 3378936792 | 226500608400 | 0 | 0 | 0.0000 | 181 | 4145152 | 22901.3923 | 4145152 | |
sql/ERRMSG | 60 | 37620432432 | 2671680 | 627007128 | 2312179584 | 36 | 3684111 | 102336.4167 | 0 | 0 | 0.0000 | 3684111 | |
innodb/innodb_log_file | 422 | 2619956814816 | 232848 | 6208428336 | 96851922816 | 8 | 70656 | 8832.0000 | 237 | 202752 | 855.4937 | 273408 | |
mysys/charset | 3 | 293225328 | 2303136 | 97741776 | 276990384 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 761 | 58965045744 | 0 | 77483472 | 33895667520 | 187 | 1344 | 7.1872 | 3 | 156 | 52.0000 | 1500 | |
myisam/kfile | 4 | 1420658976 | 1872816 | 355164744 | 1360588416 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 49923225264 | 0 | 1313769072 | 30804492576 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
mysys/cnf | 5 | 1244412048 | 340560 | 248882304 | 1221739728 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 49250256 | 2774640 | 16416576 | 35327952 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 845012256 | 0 | 56333904 | 753700464 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 1 | 7064640 | 0 | 7064640 | 7064640 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 3 | 39615840 | 1130976 | 13205280 | 28630272 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|