-
Type: Task
-
Resolution: Done
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
8
-
Storage - Ra 2020-05-18
I am tracking the following wtperf configurations for perf drop. The latest develop (4th May) compared to develop before we merged durable history (0fd1d61d8) with same the wtperf defaults (0fd1d61d8 + WT-6081):
Attached script runs these workloads limiting them to 30 secs each and extracts the metrics:
dev-0fd1d61d8 -------------- - update-only-btree.wtperf ---- Load time: 2.91 load ops/sec: 1719986 Executed 29316874 update operations (100%) 977229 ops/sec ---- medium-btree.wtperf ---- Load time: 29.09 load ops/sec: 1718921 Executed 5878154 read operations (100%) 195938 ops/sec ---- evict-btree.wtperf ---- Load time: 5.80 load ops/sec: 1722949 Executed 5168161 read operations (100%) 172272 ops/sec ---- update-checkpoint-btree.wtperf ---- Load time: 2.93 load ops/sec: 1708233 Executed 8480479 insert operations (32%) 282682 ops/sec Executed 10405996 read operations (39%) 346866 ops/sec Executed 7478906 update operations (28%) 249296 ops/sec ---- update-large-record-btree.wtperf ---- Load time: 4.82 load ops/sec: 103842 Executed 2025254 update operations (100%) 67508 ops/sec ---- modify-large-record-btree.wtperf ---- Load time: 4.77 load ops/sec: 104755 Executed 618478 modify operations (100%) 20615 ops/sec ---- modify-force-update-large-record-btree.wtperf ---- Load time: 4.76 load ops/sec: 104931 Executed 640466 modify operations (100%) 21348 ops/sec ---- multi-btree-zipfian-populate.wtperf ---- Executed 3938099 insert operations (100%) 131269 ops/sec ---- multi-btree-zipfian-workload.wtperf ---- Executed 94405436 read operations (100%) 3146847 ops/sec
latest dev: ------------ ---- update-only-btree.wtperf ---- Load time: 2.90 load ops/sec: 1725923 Executed 25451018 update operations (100%) 848367 ops/sec ---- medium-btree.wtperf ---- Load time: 29.02 load ops/sec: 1723187 Executed 5065234 read operations (100%) 168841 ops/sec ---- evict-btree.wtperf ---- Load time: 5.82 load ops/sec: 1717327 Executed 4311149 read operations (100%) 143704 ops/sec ---- update-checkpoint-btree.wtperf ---- Load time: 2.90 load ops/sec: 1725923 Executed 8323124 insert operations (32%) 277437 ops/sec Executed 10259666 read operations (39%) 341988 ops/sec Executed 7253990 update operations (28%) 241799 ops/sec ---- update-large-record-btree.wtperf ---- Load time: 4.81 load ops/sec: 104036 Executed 1877509 update operations (100%) 62583 ops/sec ---- modify-large-record-btree.wtperf ---- Load time: 4.88 load ops/sec: 102543 Executed 602617 modify operations (100%) 20087 ops/sec ---- modify-force-update-large-record-btree.wtperf ---- Load time: 4.96 load ops/sec: 100867 Executed 616761 modify operations (100%) 20558 ops/sec ---- multi-btree-zipfian-populate.wtperf ---- Executed 3635678 insert operations (100%) 121189 ops/sec ---- multi-btree-zipfian-workload.wtperf ---- Executed 94714323 read operations (100%) 3157144 ops/sec
Regression at the moment:
Workload | regression - insert | regression - read | regression - update | regression - modify |
---|---|---|---|---|
update-only-btree.wtperf | N/A | N/A | 13.2% | N/A |
medium-btree.wtperf | N/A | 13.8% | N/A | N/A |
evict-btree.wtperf | N/A | 16.6% | N/A | N/A |
update-checkpoint-btree.wtperf | 5% | 1.4% | 3% | N/A |
update-large-record-btree.wtperf | N/A | N/A | 7.2% | N/A |
modify-large-record-btree.wtperf | N/A | N/A | N/A | 2.5% |
modify-force-update-large-record-btree.wtperf | N/A | N/A | N/A | 3.7% |
multi-btree-zipfian-populate.wtperf | 7.6% | N/A | N/A | N/A |
multi-btree-zipfian-workload.wtperf | N/A | 0% | N/A | N/A |
- is depended on by
-
WT-5897 Insert benchmark in 4.4 after durable history was merged
- Closed
- is related to
-
WT-6082 Skip writing txn-id to data store when not needed
- Closed
-
WT-6151 Perform an empty check on time window before performing visibility check
- Closed
-
WT-6173 Change __wt_time_window_ functions to macros
- Closed
-
WT-6200 Significant performance overhead to cleaning up cells from the previous run
- Closed