SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 7763 | 40332201685248 | 5195440008 | 398995159728 | |
wait/io/file/innodb/innodb_data_file | 10179 | 21997038420192 | 2161021368 | 524990971824 | |
wait/io/file/sql/binlog | 1173 | 2313193941696 | 1972032216 | 35616519840 | |
wait/io/file/innodb/innodb_temp_file | 551 | 1097326075824 | 1991517264 | 70915918128 | |
wait/lock/metadata/sql/mdl | 8 | 999183931680 | 124897991328 | 261340173600 | |
wait/io/file/sql/ERRMSG | 90 | 153019995744 | 1700222040 | 67664871120 | |
wait/io/table/sql/handler | 1799 | 103720669536 | 57654432 | 65290766112 | |
wait/io/file/sql/io_cache | 416 | 75498583776 | 181486800 | 32408293632 | |
wait/io/file/sql/binlog_index | 38 | 71333736144 | 1877203416 | 36688196160 | |
wait/io/file/csv/metadata | 8 | 11481197376 | 1435149672 | 6359604240 | |
wait/io/file/sql/misc | 29 | 4866035328 | 167794176 | 2102071488 | |
wait/io/file/csv/data | 4 | 2488718496 | 622179624 | 1263702528 | |
wait/io/file/mysys/cnf | 5 | 2131779936 | 426355776 | 2108416464 | |
wait/lock/table/sql/handler | 1135 | 1680996768 | 1481040 | 297620400 | |
wait/io/file/sql/casetest | 15 | 1264089552 | 84272496 | 1191444672 | |
wait/io/file/myisam/kfile | 4 | 315693312 | 78923328 | 296479920 | |
wait/io/file/mysys/charset | 3 | 197447712 | 65815728 | 185371824 | |
wait/io/file/sql/pid | 3 | 27559488 | 9186408 | 15838416 | |
wait/io/file/myisam/dfile | 6 | 21604176 | 3600696 | 8628576 |
|