SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 155 | 741756052752 | 4785522720 | 38565380304 | |
wait/io/file/innodb/innodb_data_file | 1826 | 675152618448 | 369743880 | 68626160064 | |
wait/io/file/innodb/innodb_temp_file | 311 | 517691334864 | 1664602104 | 25795448448 | |
wait/io/file/sql/binlog | 247 | 46248633552 | 187241208 | 19752220752 | |
wait/io/file/sql/io_cache | 150 | 24535824720 | 163572024 | 13480979424 | |
wait/io/file/sql/ERRMSG | 45 | 22989240912 | 510871944 | 3566367552 | |
wait/io/table/sql/handler | 440 | 15743713392 | 35780976 | 6881557584 | |
wait/io/file/csv/metadata | 4 | 10714371888 | 2678592840 | 10562300496 | |
wait/io/file/sql/binlog_index | 23 | 2728096272 | 118612824 | 1414428048 | |
wait/io/file/myisam/kfile | 12 | 1515610800 | 126300768 | 600088368 | |
wait/io/file/mysys/cnf | 5 | 1159038144 | 231807576 | 1137709584 | |
wait/io/file/sql/casetest | 15 | 749838672 | 49989192 | 664179648 | |
wait/io/file/csv/data | 6 | 498222384 | 83036976 | 434555088 | |
wait/io/file/mysys/charset | 3 | 222619056 | 74206176 | 191798640 | |
wait/lock/table/sql/handler | 88 | 102213408 | 1161336 | 10230528 | |
wait/io/file/myisam/dfile | 8 | 82513728 | 10314216 | 30217440 | |
wait/io/file/sql/pid | 3 | 69189648 | 23063040 | 48824160 | |
wait/io/file/sql/misc | 1 | 12387408 | 12387408 | 12387408 |
|