SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_data_file | 1675 | 847451793408 | 505941216 | 222775784880 | |
wait/io/file/innodb/innodb_log_file | 171 | 821457912528 | 4803847224 | 27177780432 | |
wait/io/file/innodb/innodb_temp_file | 93 | 385455078096 | 4144678032 | 29550527952 | |
wait/io/file/sql/binlog_index | 38 | 47432794992 | 1248231336 | 26943374832 | |
wait/io/file/sql/binlog | 57 | 40106592240 | 703624416 | 19664604960 | |
wait/io/file/sql/ERRMSG | 20 | 16888056240 | 844402680 | 5312789328 | |
wait/io/table/sql/handler | 105 | 3746420304 | 35680128 | 1161412032 | |
wait/io/file/sql/casetest | 15 | 917246880 | 61149792 | 842346384 | |
wait/io/file/mysys/cnf | 5 | 678474720 | 135694944 | 648228240 | |
wait/io/file/mysys/charset | 3 | 269424144 | 89808048 | 252202368 | |
wait/io/file/sql/pid | 3 | 48376944 | 16125648 | 37272576 | |
wait/lock/table/sql/handler | 50 | 47743872 | 954624 | 2422464 | |
wait/io/file/sql/misc | 1 | 5717184 | 5717184 | 5717184 |
|