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 | 2156 | 11622184364736 | 5390623392 | 342611491200 | 1308393504 | 396416840688 | 11224459130544 | 8 | 70656 | 8832.0000 | 1352 | 1824256 | 1349.3018 | |
innodb/innodb_data_file | 4093 | 6309158440464 | 1541450856 | 246859888176 | 250473346992 | 90294044016 | 5968391049456 | 1542 | 30375936 | 19699.0506 | 1748 | 65880064 | 37688.8238 | |
sql/binlog | 258 | 726420429504 | 2815582968 | 26330184144 | 2982003024 | 2001908832 | 721436517648 | 38 | 895 | 23.5526 | 51 | 21300 | 417.6471 | |
innodb/innodb_temp_file | 204 | 556596492672 | 2728414128 | 37476202896 | 0 | 6673896240 | 549922596432 | 0 | 0 | 0.0000 | 135 | 3457024 | 25607.5852 | |
sql/binlog_index | 38 | 40841345952 | 1074772248 | 25226289792 | 428287200 | 0 | 40413058752 | 9 | 288 | 32.0000 | 0 | 0 | 0.0000 | |
sql/ERRMSG | 60 | 33389974992 | 556499328 | 3804564720 | 16833484800 | 0 | 16556490192 | 36 | 3692368 | 102565.7778 | 0 | 0 | 0.0000 | |
sql/io_cache | 76 | 9636869616 | 126800784 | 7788069168 | 486282192 | 1041056016 | 8109531408 | 34 | 1855800 | 54582.3529 | 32 | 1855800 | 57993.7500 | |
sql/casetest | 15 | 851667696 | 56777688 | 766341312 | 0 | 0 | 851667696 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
mysys/cnf | 5 | 596326896 | 119265168 | 560220144 | 576318336 | 0 | 20008560 | 3 | 56 | 18.6667 | 0 | 0 | 0.0000 | |
csv/metadata | 8 | 495448272 | 61930968 | 200712336 | 350674368 | 0 | 144773904 | 2 | 70 | 35.0000 | 0 | 0 | 0.0000 | |
mysys/charset | 3 | 375203664 | 125067888 | 343525248 | 343525248 | 0 | 31678416 | 1 | 19495 | 19495.0000 | 0 | 0 | 0.0000 | |
myisam/kfile | 4 | 265574496 | 66393624 | 247611936 | 249629952 | 0 | 15944544 | 2 | 442 | 221.0000 | 0 | 0 | 0.0000 | |
csv/data | 4 | 230702208 | 57675552 | 196476192 | 0 | 0 | 230702208 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/misc | 6 | 65132496 | 10855416 | 16564416 | 0 | 0 | 65132496 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 | |
sql/pid | 3 | 13321968 | 4440480 | 10891584 | 0 | 1792560 | 11529408 | 0 | 0 | 0.0000 | 1 | 4 | 4.0000 | |
myisam/dfile | 2 | 6953232 | 3476616 | 6687120 | 0 | 0 | 6953232 | 0 | 0 | 0.0000 | 0 | 0 | 0.0000 |
|