SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 82 | 487639582848 | 5946824136 | 89167639440 | |
wait/io/file/innodb/innodb_data_file | 1348 | 371086679568 | 275286792 | 189147176064 | |
wait/io/file/innodb/innodb_temp_file | 90 | 327458431872 | 3638426880 | 35871428208 | |
wait/io/file/sql/binlog_index | 38 | 41589863568 | 1094470080 | 25868100192 | |
wait/io/file/sql/binlog | 45 | 28405393104 | 631230864 | 15047587632 | |
wait/io/file/sql/ERRMSG | 10 | 12238727952 | 1223872584 | 8460907488 | |
wait/io/table/sql/handler | 6 | 1317123984 | 219520488 | 662814240 | |
wait/io/file/sql/casetest | 15 | 774600816 | 51639984 | 702045168 | |
wait/io/file/mysys/cnf | 5 | 437438496 | 87487488 | 413107728 | |
wait/io/file/mysys/charset | 3 | 261042672 | 87014136 | 243970848 | |
wait/lock/table/sql/handler | 13 | 26620704 | 2047584 | 13150896 | |
wait/io/file/sql/pid | 3 | 19389744 | 6463248 | 15701664 | |
wait/io/file/sql/misc | 1 | 7111104 | 7111104 | 7111104 |
|