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 | 3051 | 15264139446336 | 5002995360 | 66504710976 | 1329255312 | 543823399680 | 14718986791344 | 8 | 70656 | 8832.0000 | 1977 | 2875392 | 1454.4219 | |
innodb/innodb_data_file | 4969 | 8426252813088 | 1695764136 | 896965923744 | 380206710048 | 115246772784 | 7930799330256 | 1663 | 32358400 | 19457.8473 | 2257 | 79478784 | 35214.3482 | |
innodb/innodb_temp_file | 175 | 937208381472 | 5355476280 | 45681657120 | 0 | 3911970480 | 933296410992 | 0 | 0 | 0.0000 | 86 | 3964928 | 46103.8140 | |
sql/binlog | 627 | 852250480224 | 1359250992 | 27047201280 | 3005384976 | 9681804528 | 839563290720 | 126 | 1100 | 8.7302 | 58 | 12523 | 215.9138 | |
sql/ERRMSG | 80 | 60598762752 | 757484376 | 2335312320 | 36772187760 | 0 | 23826574992 | 48 | 4912471 | 102343.1458 | 0 | 0 | 0.0000 | |
sql/binlog_index | 38 | 46624287072 | 1226954784 | 29608567296 | 651157056 | 0 | 45973130016 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 24 | 5907037488 | 246126408 | 3093195600 | 5228032656 | 0 | 679004832 | 8 | 1703 | 212.8750 | 0 | 0 | 0.0000 | |
myisam/dfile | 51 | 3616861776 | 70918848 | 2328346944 | 2632440096 | 0 | 984421680 | 4 | 201 | 50.2500 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 2092014144 | 261501768 | 1143780528 | 1656717216 | 0 | 435296928 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 1613411712 | 322682184 | 1595294448 | 1596990912 | 0 | 16420800 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
sql/misc | 9 | 842293584 | 93588000 | 680217120 | 0 | 0 | 842293584 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/casetest | 15 | 794786784 | 52985592 | 729273600 | 0 | 0 | 794786784 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 15 | 463298352 | 30886416 | 219344400 | 16144128 | 178359456 | 268794768 | 4 | 278912 | 69728.0000 | 6 | 274538 | 45756.3333 | |
mysys/charset | 3 | 279845808 | 93281760 | 264750816 | 264750816 | 0 | 15094992 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
csv/data | 20 | 148011600 | 7400448 | 38676000 | 27692016 | 0 | 120319584 | 7 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 12715296 | 4238256 | 10026720 | 0 | 1707552 | 11007744 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|