SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 255 | 1194130669776 | 4682865264 | 27073727472 | |
wait/io/file/innodb/innodb_data_file | 1744 | 945586154832 | 542193696 | 195974418288 | |
wait/io/file/innodb/innodb_temp_file | 96 | 408012709104 | 4250132304 | 54691345104 | |
wait/io/file/sql/binlog_index | 38 | 55336979280 | 1456236144 | 28889379024 | |
wait/io/file/sql/binlog | 57 | 36612365328 | 642322032 | 20123708352 | |
wait/io/table/sql/handler | 314 | 14834899200 | 47244648 | 4516808736 | |
wait/io/file/sql/ERRMSG | 15 | 7287434352 | 485828904 | 1712344656 | |
wait/io/file/csv/metadata | 4 | 3376700976 | 844175112 | 1907104848 | |
wait/io/file/sql/casetest | 15 | 895852848 | 59723400 | 813221904 | |
wait/io/file/mysys/cnf | 5 | 423623904 | 84724728 | 405869904 | |
wait/io/file/mysys/charset | 3 | 305534064 | 101844600 | 288990768 | |
wait/lock/table/sql/handler | 52 | 50850624 | 977856 | 4014912 | |
wait/io/file/csv/data | 2 | 18081888 | 9040944 | 11591184 | |
wait/io/file/sql/pid | 3 | 12032064 | 4010688 | 9714672 | |
wait/io/file/sql/misc | 1 | 4783152 | 4783152 | 4783152 |
|