SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 984 | 6514284346200 | 6620207475 | 148444844890 | |
wait/io/file/innodb/innodb_data_file | 3090 | 4434966468860 | 1435264115 | 225206598830 | |
wait/io/file/innodb/innodb_temp_file | 409 | 1683631272870 | 4116457795 | 551813438430 | |
wait/io/file/sql/binlog | 223 | 146893595840 | 658715535 | 23960646510 | |
wait/io/file/sql/binlog_index | 38 | 53512641440 | 1408227225 | 31794243140 | |
wait/io/table/sql/handler | 2143 | 34710544290 | 16197065 | 11547491600 | |
wait/io/file/sql/ERRMSG | 40 | 25845725600 | 646143140 | 4338084980 | |
wait/io/file/sql/io_cache | 108 | 24794261780 | 229576390 | 22438578200 | |
wait/io/file/mysys/cnf | 5 | 1049331100 | 209866220 | 1028687070 | |
wait/io/file/csv/metadata | 8 | 857624800 | 107203100 | 490349640 | |
wait/io/file/csv/data | 28 | 787663740 | 28130810 | 411150680 | |
wait/io/file/sql/casetest | 15 | 732532610 | 48835260 | 674010540 | |
wait/lock/table/sql/handler | 577 | 627918030 | 1088090 | 15068430 | |
wait/io/file/myisam/kfile | 4 | 568548490 | 142136990 | 549412310 | |
wait/io/file/sql/misc | 2 | 543278090 | 271639045 | 533978180 | |
wait/io/file/mysys/charset | 3 | 293442450 | 97814150 | 269986240 | |
wait/io/file/sql/pid | 3 | 61312520 | 20437330 | 36045830 | |
wait/io/file/myisam/dfile | 2 | 8441310 | 4220655 | 8110060 |
|