SELECT * FROM `x$waits_global_by_latency`
|
events | total | total_latency | avg_latency | max_latency | |
---|---|---|---|---|---|
wait/io/file/innodb/innodb_log_file | 312 | 1679799593472 | 5383972968 | 39899451504 | |
wait/io/file/innodb/innodb_data_file | 1960 | 1430028710352 | 729606240 | 251350017072 | |
wait/io/table/sql/handler | 979484 | 540991029744 | 552288 | 4094744544 | |
wait/io/file/innodb/innodb_temp_file | 102 | 452903779680 | 4440232896 | 30903630384 | |
wait/io/file/sql/binlog | 135 | 59097172464 | 437756616 | 19057350048 | |
wait/io/file/sql/binlog_index | 38 | 44556027648 | 1172526960 | 24308389776 | |
wait/io/file/sql/ERRMSG | 30 | 15918603888 | 530619936 | 3043046160 | |
wait/io/file/mysys/cnf | 5 | 830573040 | 166114608 | 811062912 | |
wait/io/file/csv/metadata | 8 | 771825120 | 96478008 | 371877792 | |
wait/io/file/sql/casetest | 15 | 724370064 | 48291144 | 662167968 | |
wait/io/file/mysys/charset | 3 | 290371488 | 96790320 | 271135920 | |
wait/io/file/csv/data | 4 | 258392112 | 64597896 | 206444832 | |
wait/lock/table/sql/handler | 162 | 147549072 | 910536 | 3289440 | |
wait/io/file/sql/pid | 3 | 47827824 | 15942432 | 37167504 | |
wait/io/file/sql/misc | 2 | 31074384 | 15537192 | 17895504 |
|