SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 613 | 3608139525408 | 5886034968 | 117426295008 | |
wait/io/file/innodb/innodb_data_file | 2438 | 2845646864016 | 1167205248 | 215553644064 | |
wait/io/table/sql/handler | 2941859 | 1510624673712 | 513480 | 4073278176 | |
wait/io/file/innodb/innodb_temp_file | 96 | 362132714592 | 3772215744 | 33907333680 | |
wait/io/file/sql/binlog | 229 | 185661303168 | 810747960 | 29970166512 | |
wait/io/file/sql/binlog_index | 38 | 60711997632 | 1597683912 | 35026381632 | |
wait/io/file/sql/ERRMSG | 60 | 47578266384 | 792970992 | 4096295808 | |
wait/io/file/csv/metadata | 8 | 2451382560 | 306422688 | 1248840384 | |
wait/io/file/sql/casetest | 15 | 868003488 | 57866688 | 799894128 | |
wait/io/file/mysys/cnf | 5 | 521988720 | 104397744 | 482030736 | |
wait/lock/table/sql/handler | 317 | 354713040 | 1118832 | 12899568 | |
wait/io/file/mysys/charset | 3 | 279557520 | 93185664 | 264492624 | |
wait/io/file/sql/misc | 5 | 195977232 | 39195288 | 136924656 | |
wait/io/file/csv/data | 4 | 151463136 | 37865784 | 77835120 | |
wait/io/file/sql/pid | 3 | 19169568 | 6389856 | 14660976 |
|