SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 451 | 2668038586224 | 5915828160 | 107465080800 | |
wait/io/file/innodb/innodb_data_file | 2326 | 2362659698784 | 1015760592 | 233157288144 | |
wait/io/file/innodb/innodb_temp_file | 136 | 555693035568 | 4085978160 | 25075847280 | |
wait/io/table/sql/handler | 88992 | 185951582784 | 2089296 | 31343622288 | |
wait/io/file/sql/binlog | 283 | 139677913056 | 493561464 | 29102793984 | |
wait/io/file/sql/binlog_index | 38 | 58274517312 | 1533539832 | 35948287584 | |
wait/io/file/sql/ERRMSG | 55 | 26796350592 | 487206192 | 2676620496 | |
wait/io/file/csv/metadata | 8 | 1461084240 | 182635464 | 775246560 | |
wait/io/file/sql/casetest | 15 | 918999312 | 61266480 | 831021312 | |
wait/io/file/sql/io_cache | 30 | 816322320 | 27210744 | 207405792 | |
wait/io/file/csv/data | 4 | 428594496 | 107148624 | 384153792 | |
wait/io/file/mysys/cnf | 5 | 362239152 | 72447672 | 345458256 | |
wait/io/file/mysys/charset | 3 | 295392768 | 98464080 | 277236432 | |
wait/lock/table/sql/handler | 245 | 275072688 | 1122528 | 15327312 | |
wait/io/file/sql/misc | 7 | 91720464 | 13102848 | 22259952 | |
wait/io/file/sql/pid | 3 | 13200528 | 4400088 | 10639728 |
|