SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 301 | 1535282185008 | 5100605136 | 57235777632 | |
wait/io/file/innodb/innodb_data_file | 1844 | 889966605264 | 482628168 | 245410425744 | |
wait/io/file/innodb/innodb_temp_file | 197 | 427646774016 | 2170795704 | 26543867328 | |
wait/io/file/sql/binlog_index | 38 | 51779263536 | 1362611976 | 35470844640 | |
wait/io/file/sql/binlog | 93 | 32264903088 | 346934280 | 15083359104 | |
wait/io/table/sql/handler | 180 | 24644846160 | 136915680 | 21485978448 | |
wait/io/file/sql/ERRMSG | 35 | 16449295104 | 469979664 | 1923128592 | |
wait/io/file/mysys/cnf | 5 | 1469243424 | 293848632 | 1444132800 | |
wait/io/file/sql/casetest | 15 | 1291776288 | 86118384 | 1201424400 | |
wait/io/file/mysys/charset | 3 | 229817808 | 76605936 | 207184032 | |
wait/lock/table/sql/handler | 111 | 97683696 | 879912 | 6396720 | |
wait/io/file/sql/pid | 3 | 15370608 | 5123448 | 10822944 | |
wait/io/file/sql/misc | 1 | 7728864 | 7728864 | 7728864 |
|