SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 576 | 3717543237936 | 6454067928 | 276927100560 | |
wait/io/file/innodb/innodb_data_file | 2577 | 3046960228224 | 1182367032 | 246859888176 | |
wait/io/file/innodb/innodb_temp_file | 190 | 415698315120 | 2187885744 | 37221783984 | |
wait/io/file/sql/binlog | 154 | 226104325920 | 1468209864 | 26330184144 | |
wait/io/file/sql/binlog_index | 38 | 40841345952 | 1074772248 | 25226289792 | |
wait/io/file/sql/ERRMSG | 55 | 31356179184 | 570112224 | 3804564720 | |
wait/io/table/sql/handler | 952 | 21004780896 | 22063800 | 4441053936 | |
wait/io/file/sql/io_cache | 76 | 9636869616 | 126800784 | 7788069168 | |
wait/io/file/sql/casetest | 15 | 851667696 | 56777688 | 766341312 | |
wait/io/file/mysys/cnf | 5 | 596326896 | 119265168 | 560220144 | |
wait/io/file/mysys/charset | 3 | 375203664 | 125067888 | 343525248 | |
wait/lock/table/sql/handler | 306 | 359013072 | 1173216 | 15060144 | |
wait/io/file/myisam/kfile | 4 | 265574496 | 66393624 | 247611936 | |
wait/io/file/sql/misc | 6 | 65132496 | 10855416 | 16564416 | |
wait/io/file/sql/pid | 3 | 13321968 | 4440480 | 10891584 | |
wait/io/file/myisam/dfile | 2 | 6953232 | 3476616 | 6687120 |
|