SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_data_file | 1865 | 643265514672 | 344914416 | 158702608416 | |
wait/io/file/innodb/innodb_log_file | 125 | 568282069872 | 4546256352 | 21052190016 | |
wait/io/file/innodb/innodb_temp_file | 200 | 544863137280 | 2724315528 | 32644462752 | |
wait/io/file/sql/binlog | 87 | 42613032528 | 489804744 | 23527084416 | |
wait/io/file/sql/ERRMSG | 20 | 11271847488 | 563592216 | 1938514512 | |
wait/io/table/sql/handler | 59 | 6267038448 | 106220928 | 3895664784 | |
wait/io/file/sql/binlog_index | 23 | 1395638112 | 60679872 | 371390448 | |
wait/io/file/sql/casetest | 15 | 762213408 | 50814192 | 649998624 | |
wait/io/file/mysys/cnf | 5 | 555271728 | 111054240 | 537440112 | |
wait/io/file/mysys/charset | 3 | 544121952 | 181373808 | 512163696 | |
wait/io/file/sql/pid | 3 | 48935040 | 16311504 | 38849712 | |
wait/lock/table/sql/handler | 23 | 30682080 | 1333992 | 2527536 | |
wait/io/file/sql/misc | 1 | 4515456 | 4515456 | 4515456 |
|