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 | 684 | 3422223313344 | 5003250384 | 74588086320 | 1502898144 | 124380042864 | 3296340372336 | 8 | 70656 | 8832.0000 | 407 | 353280 | 868.0098 | |
innodb/innodb_data_file | 2464 | 1615167044832 | 655505928 | 215702522112 | 237901458432 | 33816945888 | 1343448640512 | 1373 | 27607040 | 20107.0940 | 844 | 37011456 | 43852.4360 | |
innodb/innodb_temp_file | 399 | 820054057152 | 2055273264 | 186249724848 | 0 | 190018735104 | 630035322048 | 0 | 0 | 0.0000 | 325 | 6897664 | 21223.5815 | |
sql/binlog | 105 | 120290031840 | 1145619288 | 36015226896 | 3849934176 | 1898853264 | 114541244400 | 21 | 680 | 32.3810 | 7 | 1268 | 181.1429 | |
sql/binlog_index | 38 | 44297969232 | 1165735824 | 26037704352 | 529893936 | 0 | 43768075296 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 40 | 30042123408 | 751053072 | 6580913328 | 19140380160 | 0 | 10901743248 | 24 | 2457596 | 102399.8333 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 21397273920 | 2674659240 | 12826276848 | 425218992 | 0 | 20972054928 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
sql/io_cache | 76 | 3207865584 | 42208584 | 1043179104 | 188541936 | 771675696 | 2247647952 | 34 | 1901164 | 55916.5882 | 32 | 1901164 | 59411.3750 | |
sql/casetest | 15 | 1075431456 | 71695272 | 942865440 | 0 | 0 | 1075431456 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 877527024 | 219381624 | 786737424 | 0 | 0 | 877527024 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 853454448 | 170690784 | 831348672 | 833175552 | 0 | 20278896 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 266065008 | 66516120 | 226693104 | 230006304 | 0 | 36058704 | 2 | 392 | 196.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 239951184 | 79983552 | 226985088 | 226985088 | 0 | 12966096 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 17256096 | 5752032 | 13640352 | 0 | 2686992 | 14569104 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 15720672 | 7860336 | 15278736 | 0 | 0 | 15720672 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 1 | 4823808 | 4823808 | 4823808 | 0 | 0 | 4823808 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|