nickva commented on PR #5625: URL: https://github.com/apache/couchdb/pull/5625#issuecomment-3209005577
@jaydoane wondered what happened if we try depth = 3. With the same setup as above ran a few trials with a various cache depths 3, 2 and 1. Maybe we should go with depth = 3 as the new default? <img width="954" height="849" alt="cache_depths_experiment" src="https://github.com/user-attachments/assets/651013ab-b9e3-49df-84bb-28c4f1e4a0d9"; /> #### Depth 3 ``` HTTP http_req_duration..............: avg=586.74ms min=3.14ms med=673.8ms max=5.66s p(90)=1.16s p(95)=1.28s { expected_response:true }...: avg=585.98ms min=3.14ms med=673.07ms max=5.36s p(90)=1.16s p(95)=1.28s { name:bulk_docs }...........: avg=112.06ms min=88.56ms med=108.77ms max=422.51ms p(90)=117.81ms p(95)=120.51ms { name:get_doc }.............: avg=15.37ms min=3.14ms med=11.77ms max=4.25s p(90)=21.93ms p(95)=24.55ms { name:post_doc }............: avg=794.25ms min=15.16ms med=771.39ms max=4.91s p(90)=1.16s p(95)=1.29s { name:put_doc }.............: avg=950.81ms min=39.64ms med=947.47ms max=5.66s p(90)=1.28s p(95)=1.38s http_req_failed................: 0.11% 7585 out of 6529402 http_reqs......................: 6529402 8535.726214/s EXECUTION iteration_duration.............: avg=2.76s min=1.13s med=2.74s max=8.37s p(90)=3.21s p(95)=3.37s iterations.....................: 2176133 2844.805006/s vus............................: 347 min=0 max=10000 vus_max........................: 10000 min=10000 max=10000 NETWORK data_received..................: 4.1 GB 5.3 MB/s data_sent......................: 1.1 GB 1.4 MB/s ``` ``` { "full": { "value": 0, "type": "counter", "desc": "number of times bt_engine cache was full" }, "hits": { "value": 38216261, "type": "counter", "desc": "number of bt_engine cache hits" }, "misses": { "value": 1476375, "type": "counter", "desc": "number of bt_engine cache misses" } } ``` #### Depth 2 ``` HTTP http_req_duration..............: avg=735.09ms min=3.71ms med=877.78ms max=3.4s p(90)=1.41s p(95)=1.55s { expected_response:true }...: avg=734.3ms min=3.71ms med=877.09ms max=3.2s p(90)=1.41s p(95)=1.55s { name:bulk_docs }...........: avg=109.51ms min=94.58ms med=106.51ms max=429.49ms p(90)=113.26ms p(95)=115.84ms { name:get_doc }.............: avg=15.45ms min=3.71ms med=12.45ms max=2.05s p(90)=25.08ms p(95)=28.88ms { name:post_doc }............: avg=1.04s min=13.54ms med=1.02s max=3.2s p(90)=1.45s p(95)=1.59s { name:put_doc }.............: avg=1.14s min=46.67ms med=1.12s max=3.4s p(90)=1.53s p(95)=1.65s http_req_failed................: 0.10% 5948 out of 5622800 http_reqs......................: 5622800 7371.456322/s EXECUTION iteration_duration.............: avg=3.2s min=1.41s med=3.18s max=6.65s p(90)=3.74s p(95)=3.92s iterations.....................: 1873932 2456.713362/s vus............................: 106 min=0 max=10000 vus_max........................: 10000 min=10000 max=10000 NETWORK data_received..................: 3.5 GB 4.6 MB/s data_sent......................: 933 MB 1.2 MB/s ``` ``` { "full": { "value": 0, "type": "counter", "desc": "number of times bt_engine cache was full" }, "hits": { "value": 24445315, "type": "counter", "desc": "number of bt_engine cache hits" }, "misses": { "value": 367983, "type": "counter", "desc": "number of bt_engine cache misses" } } ``` ### Depth 1 ``` HTTP http_req_duration..............: avg=897.76ms min=4.3ms med=1.05s max=4.06s p(90)=1.75s p(95)=1.93s { expected_response:true }...: avg=896.76ms min=4.3ms med=1.05s max=3.64s p(90)=1.75s p(95)=1.92s { name:bulk_docs }...........: avg=110.12ms min=88.8ms med=107.17ms max=424.52ms p(90)=114.56ms p(95)=116.5ms { name:get_doc }.............: avg=21.44ms min=4.3ms med=16.46ms max=3.55s p(90)=35.67ms p(95)=40.64ms { name:post_doc }............: avg=1.25s min=22.69ms med=1.23s max=3.62s p(90)=1.77s p(95)=1.94s { name:put_doc }.............: avg=1.41s min=24.89ms med=1.4s max=4.06s p(90)=1.92s p(95)=2.07s http_req_failed................: 0.10% 5285 out of 4881638 http_reqs......................: 4881638 6394.596739/s EXECUTION iteration_duration.............: avg=3.69s min=1.29s med=3.67s max=8.51s p(90)=4.32s p(95)=4.53s iterations.....................: 1626878 2131.093857/s vus............................: 3502 min=0 max=10000 vus_max........................: 10000 min=10000 max=10000 NETWORK data_received..................: 3.1 GB 4.0 MB/s data_sent......................: 824 MB 1.1 MB/s ``` ``` { "full": { "value": 0, "type": "counter", "desc": "number of times bt_engine cache was full" }, "hits": { "value": 16728022, "type": "counter", "desc": "number of bt_engine cache hits" }, "misses": { "value": 138036, "type": "counter", "desc": "number of bt_engine cache misses" } } ``` Maybe we should go -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@couchdb.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
