SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 819 | 5407279287696 | 6602294424 | 606311815824 | |
wait/io/file/innodb/innodb_data_file | 2839 | 2298463895904 | 809603256 | 212105484624 | |
wait/io/file/innodb/innodb_temp_file | 658 | 1450795181616 | 2204855664 | 523078155600 | |
wait/io/table/sql/handler | 172626 | 321621298944 | 1863048 | 4131922608 | |
wait/io/file/sql/binlog | 234 | 76216540224 | 325711584 | 15815939568 | |
wait/io/file/sql/binlog_index | 38 | 51093437472 | 1344564144 | 33556398480 | |
wait/io/file/sql/ERRMSG | 60 | 37640992224 | 627349800 | 5760901872 | |
wait/io/file/sql/io_cache | 432 | 37518638784 | 86848608 | 19854323808 | |
wait/io/file/mysys/cnf | 5 | 1329204096 | 265840608 | 1311682416 | |
wait/io/file/myisam/kfile | 8 | 1182726864 | 147840792 | 646831680 | |
wait/io/file/sql/casetest | 15 | 853153488 | 56876688 | 783241536 | |
wait/io/file/csv/metadata | 4 | 501489648 | 125372280 | 435771072 | |
wait/lock/table/sql/handler | 371 | 391989840 | 1056528 | 15176832 | |
wait/io/file/mysys/charset | 3 | 194306640 | 64768704 | 180987312 | |
wait/io/file/sql/misc | 3 | 40312272 | 13437336 | 26147616 | |
wait/io/file/csv/data | 2 | 19057104 | 9528552 | 13035792 | |
wait/io/file/myisam/dfile | 4 | 17387568 | 4346760 | 9474960 | |
wait/io/file/sql/pid | 3 | 14643024 | 4880832 | 12215280 |
|