SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_data_file | 1689 | 714041780496 | 422759832 | 226358375232 | |
wait/io/file/innodb/innodb_log_file | 146 | 624429270432 | 4276912728 | 20691680592 | |
wait/io/file/innodb/innodb_temp_file | 98 | 414517450512 | 4229769720 | 30114841680 | |
wait/io/file/sql/binlog | 75 | 33742406016 | 449898504 | 16244002896 | |
wait/io/file/sql/ERRMSG | 35 | 19748097072 | 564231096 | 1986960096 | |
wait/io/table/sql/handler | 312 | 7428592512 | 23809368 | 4388224896 | |
wait/io/file/sql/binlog_index | 23 | 1694010384 | 73652568 | 553494480 | |
wait/io/file/sql/casetest | 15 | 695900304 | 46393248 | 633450048 | |
wait/io/file/mysys/charset | 3 | 328222224 | 109407408 | 311191584 | |
wait/lock/table/sql/handler | 255 | 244881648 | 960168 | 2893440 | |
wait/io/file/mysys/cnf | 5 | 156331296 | 31266048 | 136973760 | |
wait/io/file/sql/pid | 3 | 30995184 | 10331640 | 24563088 | |
wait/io/file/sql/misc | 1 | 10342464 | 10342464 | 10342464 |
|