SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_data_file | 1544 | 422195856720 | 273442752 | 173565092448 | |
wait/io/file/innodb/innodb_temp_file | 188 | 370229298384 | 1969304568 | 24440018064 | |
wait/io/file/innodb/innodb_log_file | 70 | 274755025776 | 3925071744 | 17520870576 | |
wait/io/file/sql/binlog | 55 | 45073644000 | 819520680 | 21816706560 | |
wait/io/file/sql/ERRMSG | 25 | 10515324864 | 420612984 | 2546767344 | |
wait/io/table/sql/handler | 204 | 4062279936 | 19912992 | 901721040 | |
wait/io/file/sql/io_cache | 25 | 1465164096 | 58606416 | 890458272 | |
wait/io/file/mysys/cnf | 5 | 1375850784 | 275170104 | 1344589488 | |
wait/io/file/sql/binlog_index | 23 | 833385168 | 36234000 | 314752416 | |
wait/io/file/sql/casetest | 15 | 828849120 | 55256520 | 752770656 | |
wait/io/file/mysys/charset | 3 | 193439136 | 64479624 | 176899008 | |
wait/lock/table/sql/handler | 61 | 59986608 | 983136 | 3023328 | |
wait/io/file/sql/pid | 3 | 35578224 | 11859408 | 30471936 | |
wait/io/file/sql/misc | 1 | 5906736 | 5906736 | 5906736 |
|