SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1792 | 9595178427648 | 5354452224 | 117397966224 | |
wait/io/file/innodb/innodb_data_file | 4172 | 6304117834080 | 1511053896 | 222961337808 | |
wait/io/file/innodb/innodb_temp_file | 877 | 1487081799984 | 1695646128 | 49380453936 | |
wait/io/file/sql/binlog | 329 | 374523121632 | 1138368000 | 24927301872 | |
wait/lock/metadata/sql/mdl | 1 | 233381445792 | 233381445792 | 233381445792 | |
wait/io/table/sql/handler | 5065 | 93769878576 | 18513264 | 35472076464 | |
wait/io/file/sql/binlog_index | 38 | 58457567520 | 1538357040 | 41022546576 | |
wait/io/file/sql/ERRMSG | 80 | 47437498416 | 592968552 | 14480776992 | |
wait/io/file/sql/io_cache | 503 | 25484566272 | 50665032 | 5881978080 | |
wait/lock/table/sql/handler | 1252 | 1343671296 | 1073160 | 15918144 | |
wait/io/file/sql/casetest | 15 | 983535168 | 65568888 | 919182000 | |
wait/io/file/mysys/cnf | 5 | 681436272 | 136287096 | 655788144 | |
wait/io/file/sql/misc | 9 | 354912096 | 39434472 | 267528096 | |
wait/io/file/mysys/charset | 3 | 277080144 | 92359872 | 237049824 | |
wait/io/file/sql/pid | 3 | 14126640 | 4708704 | 9380448 |
|