SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 610 | 4149048808340 | 6801719225 | 148444844890 | |
wait/io/file/innodb/innodb_data_file | 2341 | 2532964045320 | 1082000830 | 225206598830 | |
wait/io/file/innodb/innodb_temp_file | 243 | 1380259335940 | 5680079430 | 551813438430 | |
wait/io/file/sql/binlog | 77 | 121697049750 | 1580480935 | 23960646510 | |
wait/io/file/sql/binlog_index | 38 | 53512641440 | 1408227225 | 31794243140 | |
wait/io/table/sql/handler | 1023 | 27125939540 | 26515900 | 11547491600 | |
wait/io/file/sql/io_cache | 108 | 24794261780 | 229576390 | 22438578200 | |
wait/io/file/sql/ERRMSG | 30 | 15675120470 | 522503945 | 2410523210 | |
wait/io/file/mysys/cnf | 5 | 1049331100 | 209866220 | 1028687070 | |
wait/io/file/csv/metadata | 8 | 857624800 | 107203100 | 490349640 | |
wait/io/file/sql/casetest | 15 | 732532610 | 48835260 | 674010540 | |
wait/io/file/sql/misc | 2 | 543278090 | 271639045 | 533978180 | |
wait/io/file/mysys/charset | 3 | 293442450 | 97814150 | 269986240 | |
wait/io/file/csv/data | 11 | 278751910 | 25340890 | 217542210 | |
wait/lock/table/sql/handler | 105 | 140469610 | 1337720 | 8708430 | |
wait/io/file/sql/pid | 3 | 61312520 | 20437330 | 36045830 |
|