SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 797 | 5025992692512 | 6306138696 | 265671232464 | |
wait/io/file/innodb/innodb_data_file | 2566 | 2176784715072 | 848318064 | 213556083840 | |
wait/io/file/innodb/innodb_temp_file | 277 | 806575822800 | 2911826016 | 35672901264 | |
wait/io/file/sql/binlog | 269 | 59433881232 | 220943712 | 23519755248 | |
wait/io/file/sql/binlog_index | 38 | 44848158960 | 1180214640 | 28982271120 | |
wait/io/file/sql/io_cache | 644 | 29446921680 | 45724800 | 8646064416 | |
wait/io/table/sql/handler | 4611 | 24569099280 | 5328312 | 9569351088 | |
wait/io/file/sql/ERRMSG | 35 | 20916870480 | 597624720 | 2972948352 | |
wait/io/file/csv/metadata | 8 | 3172865520 | 396607992 | 1978976736 | |
wait/io/file/mysys/cnf | 5 | 1453507440 | 290701488 | 1434083376 | |
wait/io/file/myisam/kfile | 8 | 1160436288 | 145054536 | 530007984 | |
wait/io/file/sql/casetest | 15 | 757745472 | 50516136 | 686738448 | |
wait/lock/table/sql/handler | 445 | 507605472 | 1140480 | 31456128 | |
wait/io/file/mysys/charset | 3 | 290873616 | 96957696 | 262680000 | |
wait/io/file/myisam/dfile | 4 | 122428416 | 30607104 | 71702928 | |
wait/io/file/csv/data | 4 | 59928000 | 14982000 | 25185600 | |
wait/lock/metadata/sql/mdl | 2 | 31195824 | 15597912 | 19349616 | |
wait/io/file/sql/pid | 3 | 13033680 | 4344384 | 10480800 | |
wait/io/file/sql/misc | 1 | 2870208 | 2870208 | 2870208 |
|