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 | 2204 | 10063913534928 | 4566203928 | 74588086320 | 1502898144 | 490537759536 | 9571872877248 | 8 | 70656 | 8832.0000 | 1431 | 1741312 | 1216.8498 | |
innodb/innodb_data_file | 3423 | 3910738459584 | 1142488512 | 215702522112 | 250926344064 | 77132884752 | 3582679230768 | 1418 | 28344320 | 19988.9422 | 1509 | 58802176 | 38967.6448 | |
innodb/innodb_temp_file | 530 | 1059411905376 | 1998890256 | 186249724848 | 0 | 191678306160 | 867733599216 | 0 | 0 | 0.0000 | 442 | 9732096 | 22018.3167 | |
sql/binlog | 197 | 498671615376 | 2531327832 | 36015226896 | 4446813360 | 10003705008 | 484221097008 | 32 | 724 | 22.6250 | 31 | 14493 | 467.5161 | |
sql/binlog_index | 38 | 44297969232 | 1165735824 | 26037704352 | 529893936 | 0 | 43768075296 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 40390393824 | 673173072 | 6580913328 | 26837040912 | 0 | 13553352912 | 36 | 3683718 | 102325.5000 | 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 | 8 | 530371248 | 66296208 | 243596496 | 478261872 | 0 | 52109376 | 4 | 834 | 208.5000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 239951184 | 79983552 | 226985088 | 226985088 | 0 | 12966096 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
sql/misc | 4 | 167447808 | 41861952 | 154039776 | 0 | 0 | 167447808 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
myisam/dfile | 7 | 47175216 | 6739128 | 22239888 | 0 | 0 | 47175216 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 17256096 | 5752032 | 13640352 | 0 | 2686992 | 14569104 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 |
|