SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 663 | 3894132384384 | 5873502624 | 283309614192 | |
wait/io/file/innodb/innodb_data_file | 2849 | 3675154189344 | 1289980296 | 204107782560 | |
wait/io/file/innodb/innodb_temp_file | 752 | 1456371896496 | 1936664664 | 33646830096 | |
wait/io/file/sql/binlog | 599 | 110507876160 | 184487160 | 24051409536 | |
wait/io/file/sql/binlog_index | 38 | 79966011312 | 2104368552 | 42666337824 | |
wait/io/table/sql/handler | 1656 | 34044594144 | 20558208 | 4643065152 | |
wait/io/file/sql/io_cache | 562 | 31088896080 | 55318296 | 12979834560 | |
wait/io/file/sql/ERRMSG | 60 | 28988841552 | 483147192 | 2411078736 | |
wait/io/file/sql/casetest | 15 | 1222589808 | 81505776 | 1157854368 | |
wait/lock/table/sql/handler | 801 | 908883360 | 1134672 | 16607712 | |
wait/io/file/mysys/cnf | 5 | 628430352 | 125685912 | 607543200 | |
wait/io/file/myisam/kfile | 4 | 283186992 | 70796616 | 249570288 | |
wait/io/file/mysys/charset | 3 | 278992032 | 92997168 | 267183312 | |
wait/io/file/sql/misc | 3 | 215864352 | 71954784 | 199829520 | |
wait/io/file/sql/pid | 3 | 20008032 | 6669168 | 11877888 | |
wait/io/file/myisam/dfile | 2 | 8373552 | 4186776 | 7953264 |
|