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 | 2759 | 3278142868704 | 0 | 1188163416 | 260660506656 | 1476 | 29294592 | 19847.2846 | 876 | 37208064 | 42474.9589 | 66502656 | |
sql/ERRMSG | 60 | 25011427584 | 3137904 | 416857056 | 2731288560 | 36 | 3687708 | 102436.3333 | 0 | 0 | 0.0000 | 3687708 | |
innodb/innodb_temp_file | 102 | 437574890544 | 0 | 4289949840 | 24801586128 | 0 | 0 | 0.0000 | 38 | 1540096 | 40528.8421 | 1540096 | |
sql/io_cache | 32 | 3901933200 | 0 | 121935264 | 3157809600 | 8 | 701012 | 87626.5000 | 14 | 701012 | 50072.2857 | 1402024 | |
innodb/innodb_log_file | 689 | 4141025116272 | 234432 | 6010196016 | 125301361680 | 8 | 70656 | 8832.0000 | 399 | 350208 | 877.7143 | 420864 | |
mysys/charset | 3 | 192570048 | 1887600 | 64190016 | 175476576 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | 19495 | |
sql/binlog | 311 | 140204937840 | 0 | 450819600 | 21853244160 | 72 | 884 | 12.2778 | 8 | 1594 | 199.2500 | 2478 | |
myisam/kfile | 4 | 1552366464 | 636768 | 388091616 | 1530173040 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | 442 | |
sql/binlog_index | 38 | 61331483664 | 0 | 1613986176 | 37514586912 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | 288 | |
csv/metadata | 8 | 10412791488 | 1822128 | 1301598936 | 7964328240 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | 70 | |
mysys/cnf | 5 | 549066144 | 194304 | 109813176 | 533476416 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | 56 | |
sql/pid | 3 | 52214976 | 2880240 | 17404992 | 39898320 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | 4 | |
sql/casetest | 15 | 927632112 | 0 | 61842000 | 867464928 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
sql/misc | 5 | 69242976 | 0 | 13848384 | 16069152 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
csv/data | 9 | 720702048 | 0 | 80077800 | 539217888 | 2 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 | |
myisam/dfile | 2 | 8802816 | 361152 | 4401408 | 8441664 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | 0 |
|