SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 1337 | 8132110590912 | 6082356456 | 664558371840 | |
wait/io/file/innodb/innodb_data_file | 3594 | 5806011065712 | 1615473288 | 198428218032 | |
wait/io/file/innodb/innodb_temp_file | 129 | 481185261744 | 3730118304 | 30805482576 | |
wait/io/file/sql/binlog | 1124 | 385556055984 | 343021272 | 24401171520 | |
wait/io/file/sql/io_cache | 69 | 65780538384 | 953340960 | 61872143520 | |
wait/io/file/sql/binlog_index | 38 | 49322664864 | 1297964712 | 26916316416 | |
wait/io/file/sql/ERRMSG | 60 | 40768002000 | 679466568 | 4423606704 | |
wait/io/table/sql/handler | 874 | 33030418608 | 37792128 | 5498014368 | |
wait/io/file/myisam/kfile | 12 | 2881956528 | 240162912 | 1522345968 | |
wait/io/file/csv/metadata | 8 | 2753659920 | 344207424 | 1953453216 | |
wait/lock/table/sql/handler | 621 | 802732128 | 1292544 | 78286560 | |
wait/io/file/sql/casetest | 15 | 742063872 | 49470696 | 665690256 | |
wait/io/file/mysys/cnf | 5 | 531927792 | 106385400 | 515436768 | |
wait/io/file/sql/misc | 9 | 463903968 | 51544680 | 351564048 | |
wait/io/file/csv/data | 7 | 425581200 | 60797088 | 371827632 | |
wait/io/file/mysys/charset | 3 | 251355456 | 83785152 | 231932448 | |
wait/io/file/myisam/dfile | 6 | 25365648 | 4227432 | 10042560 | |
wait/io/file/sql/pid | 3 | 12653520 | 4217664 | 10456512 |
|