SELECT * FROM `x$io_global_by_wait_by_latency`
|
event_name | total | total_latency | avg_latency | max_latency | read_latency | write_latency | misc_latency | count_read | total_read | avg_read | count_write | total_written | avg_written | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
innodb/innodb_log_file | 2380 | 13871899612560 | 5828529168 | 107173599456 | 1177684992 | 375523643088 | 13495198284480 | 8 | 70656 | 8832.0000 | 1460 | 1897472 | 1299.6384 | |
innodb/innodb_data_file | 5210 | 9994517866608 | 1918333560 | 232773667632 | 248081841744 | 129031660560 | 9617404364304 | 1531 | 30195712 | 19722.8687 | 2676 | 94224384 | 35210.9058 | |
sql/binlog | 507 | 880848388464 | 1737373440 | 33258571104 | 2673773520 | 4182045648 | 873992569296 | 96 | 980 | 10.2083 | 58 | 17912 | 308.8276 | |
innodb/innodb_temp_file | 175 | 822033285744 | 4697332992 | 30297374448 | 0 | 46881882432 | 775151403312 | 0 | 0 | 0.0000 | 94 | 3571712 | 37996.9362 | |
sql/binlog_index | 38 | 51532765680 | 1356125232 | 34473055056 | 1782996864 | 0 | 49749768816 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 31705056768 | 528417384 | 3240814896 | 18494062224 | 0 | 13210994544 | 36 | 3693658 | 102601.6111 | 0 | 0 | 0.0000 | |
sql/io_cache | 304 | 6465642480 | 21268368 | 860388144 | 1849585056 | 3150643056 | 1465414368 | 152 | 7369588 | 48484.1316 | 122 | 7369588 | 60406.4590 | |
csv/metadata | 8 | 2134113168 | 266764080 | 1088562816 | 1553068704 | 0 | 581044464 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 8 | 1959514656 | 244939200 | 1674848208 | 1915306272 | 0 | 44208384 | 4 | 904 | 226.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 848983872 | 56598696 | 786492432 | 0 | 0 | 848983872 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 743253456 | 148650480 | 719409504 | 721411680 | 0 | 21841776 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 15 | 310887984 | 20725848 | 35631024 | 0 | 0 | 310887984 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 295823616 | 98607696 | 275089584 | 275089584 | 0 | 20734032 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 121169136 | 30292152 | 59646576 | 0 | 0 | 121169136 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 4 | 21192864 | 5298216 | 9114864 | 0 | 0 | 21192864 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 12876864 | 4292112 | 10220496 | 0 | 1995312 | 10881552 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|