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 | 4355 | 6197038023264 | 0 | 1422970824 | 651161022336 | 1386 | 27820032 | 20072.1732 | 2137 | 77971456 | 36486.4090 | 105791488 | |
sql/io_cache | 444 | 173516391840 | 0 | 390802632 | 58484599536 | 192 | 10582908 | 55119.3125 | 182 | 10582908 | 58147.8462 | 21165816 | |
innodb/innodb_temp_file | 320 | 642487804992 | 0 | 2007774384 | 32113489584 | 0 | 0 | 0.0000 | 242 | 5799936 | 23966.6777 | 5799936 | |
sql/ERRMSG | 70 | 38775621984 | 3061872 | 553937208 | 3153458352 | 42 | 4297463 | 102320.5476 | 0 | 0 | 0.0000 | 4297463 | |
innodb/innodb_log_file | 2473 | 11269238910336 | 299376 | 4556910072 | 181175352336 | 8 | 70656 | 8832.0000 | 1634 | 2883072 | 1764.4259 | 2953728 | |
mysys/charset | 3 | 311010480 | 3950496 | 103670160 | 268934688 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 381 | 910021366320 | 0 | 2388507264 | 39017365200 | 61 | 840 | 13.7705 | 65 | 16533 | 254.3538 | 17373 | |
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 | 9 | 300144768 | 0 | 33349272 | 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 |
|