SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 176 | 986436886512 | 5604754848 | 114498136896 | |
wait/io/file/innodb/innodb_data_file | 1758 | 635514404448 | 361498368 | 202850911824 | |
wait/io/file/innodb/innodb_temp_file | 90 | 317346812640 | 3526075608 | 30422438640 | |
wait/io/file/sql/binlog_index | 38 | 42318955008 | 1113656544 | 26665072896 | |
wait/io/file/sql/binlog | 41 | 40473682128 | 987162792 | 20558455104 | |
wait/io/table/sql/handler | 102 | 10737638736 | 105270792 | 9156827856 | |
wait/io/file/sql/ERRMSG | 10 | 6748147824 | 674814624 | 2930015616 | |
wait/io/file/myisam/kfile | 4 | 1456560864 | 364140216 | 1393843440 | |
wait/io/file/sql/casetest | 15 | 1181443824 | 78762816 | 1083376800 | |
wait/io/file/mysys/cnf | 5 | 414464160 | 82892832 | 391981920 | |
wait/io/file/mysys/charset | 3 | 279378528 | 93126000 | 256923744 | |
wait/lock/table/sql/handler | 71 | 69006960 | 971784 | 7063056 | |
wait/io/file/myisam/dfile | 2 | 30641424 | 15320712 | 29330928 | |
wait/io/file/sql/pid | 3 | 13972992 | 4657488 | 11560560 | |
wait/io/file/sql/misc | 1 | 6002832 | 6002832 | 6002832 |
|