SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 2351 | 12423946929504 | 5284537104 | 116198231952 | |
wait/io/file/innodb/innodb_data_file | 5026 | 4861892721840 | 967348272 | 234395839392 | |
wait/io/file/innodb/innodb_temp_file | 613 | 1471320309888 | 2400196128 | 658381239120 | |
wait/io/table/sql/handler | 996424 | 643045374576 | 645216 | 7510095120 | |
wait/io/file/sql/binlog | 143 | 116261054976 | 813014136 | 20914536192 | |
wait/io/file/sql/io_cache | 874 | 92898233472 | 106290624 | 28367353344 | |
wait/io/file/sql/binlog_index | 38 | 58515371376 | 1539877944 | 35547195024 | |
wait/io/file/sql/ERRMSG | 50 | 32710941648 | 654218664 | 4001895744 | |
wait/lock/table/sql/handler | 2230 | 2261142048 | 1013760 | 21910944 | |
wait/io/file/csv/metadata | 8 | 1249043664 | 156130392 | 717032976 | |
wait/io/file/csv/data | 13 | 1209024960 | 93001920 | 851699904 | |
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/io/file/myisam/dfile | 8 | 314023248 | 39252840 | 291816096 | |
wait/io/file/sql/misc | 5 | 305240496 | 61047888 | 251651664 | |
wait/io/file/mysys/charset | 3 | 297092400 | 99030624 | 281397600 | |
wait/io/file/sql/pid | 3 | 44132352 | 14710608 | 34663728 |
|