SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 671 | 3667109972064 | 5465141352 | 116198231952 | |
wait/io/file/innodb/innodb_data_file | 2537 | 1698814679232 | 669615408 | 234395839392 | |
wait/io/file/innodb/innodb_temp_file | 96 | 446254066896 | 4648479792 | 32882566464 | |
wait/io/file/sql/binlog_index | 38 | 58515371376 | 1539877944 | 35547195024 | |
wait/io/file/sql/binlog | 77 | 42831750192 | 556256448 | 20914536192 | |
wait/io/table/sql/handler | 3598 | 27859466976 | 7742856 | 7510095120 | |
wait/io/file/sql/ERRMSG | 30 | 19729818768 | 657660432 | 4001895744 | |
wait/io/file/csv/metadata | 8 | 1249043664 | 156130392 | 717032976 | |
wait/io/file/sql/casetest | 15 | 1115546784 | 74369592 | 1050804480 | |
wait/io/file/myisam/kfile | 4 | 814141152 | 203535288 | 788288688 | |
wait/io/file/mysys/cnf | 5 | 575300880 | 115060176 | 559230144 | |
wait/lock/table/sql/handler | 558 | 560693760 | 1004784 | 14608176 | |
wait/io/file/myisam/dfile | 8 | 314023248 | 39252840 | 291816096 | |
wait/io/file/csv/data | 4 | 312106080 | 78026520 | 279365328 | |
wait/io/file/mysys/charset | 3 | 297092400 | 99030624 | 281397600 | |
wait/io/file/sql/pid | 3 | 44132352 | 14710608 | 34663728 | |
wait/io/file/sql/misc | 1 | 6831264 | 6831264 | 6831264 |
|