SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 456 | 2619480933168 | 5744475528 | 75712846176 | |
wait/io/file/innodb/innodb_data_file | 2403 | 2538132915120 | 1056234960 | 269024469648 | |
wait/io/file/innodb/innodb_temp_file | 288 | 1014992381568 | 3524279088 | 29237761344 | |
wait/io/file/sql/binlog | 497 | 201061057824 | 404549376 | 30980635488 | |
wait/lock/metadata/sql/mdl | 3 | 110445479760 | 36815159832 | 58808184336 | |
wait/io/file/sql/io_cache | 526 | 70752118800 | 134509584 | 32230736736 | |
wait/io/file/sql/binlog_index | 38 | 44711789232 | 1176625824 | 26920753200 | |
wait/io/file/sql/ERRMSG | 50 | 28987345200 | 579746904 | 2822892864 | |
wait/io/table/sql/handler | 1404 | 20763516048 | 14788752 | 5967442800 | |
wait/io/file/myisam/kfile | 16 | 9773495424 | 610843464 | 6897871728 | |
wait/io/file/sql/casetest | 15 | 777302064 | 51820032 | 703951248 | |
wait/io/file/mysys/cnf | 5 | 615337008 | 123067296 | 592396992 | |
wait/lock/table/sql/handler | 381 | 424997760 | 1115400 | 14693712 | |
wait/io/file/mysys/charset | 3 | 252366576 | 84122016 | 239019264 | |
wait/io/file/sql/misc | 4 | 93989280 | 23497320 | 68480016 | |
wait/io/file/myisam/dfile | 8 | 77865744 | 9733152 | 30187872 | |
wait/io/file/sql/pid | 3 | 23300112 | 7766616 | 13526304 |
|