fdb-record-layer icon indicating copy to clipboard operation
fdb-record-layer copied to clipboard

Resolves #1758: Add index scan plan with additional reads to load the RYW cache

Open alecgrieser opened this issue 2 years ago • 15 comments

This adds a new RecordQueryPlan that has the same semantics (in terms of results returned, including continuations) as a RecordQueryIndexPlan, but that scans additional ranges for the purposes of loading the FDB C client's read-your-writes cache. If the query is executed multiple times in the same transaction with different bound parameters, then loading this cache might result in performance wins because query executions (after the first) can use the cache to avoid having to make additional requests to the database. At the same time, because FDB paginates range scans, the amount of additional work that each scan has to do to load the cache should be bounded as well (to approximately one page of results per scan).

This resolves #1758.

alecgrieser avatar Jun 30 '22 00:06 alecgrieser

Result of fdb-record-layer-pr-proto2 on Linux CentOS 7

  • Commit ID: b40c2708bd565d459ddb13afcd821e409bc139ff
  • Duration 0:08:31
  • Result: :x: FAILED
  • Error: Error while executing command: ./gradlew --no-daemon --console=plain -b ./build.gradle build destructiveTest sonarqube -PcoreNotStrict -PreleaseBuild=false -PpublishBuild=false -PspotbugsEnableHtmlReport. Reason: exit status 1
  • Build Logs (available for 30 days)

foundationdb-ci avatar Jun 30 '22 00:06 foundationdb-ci

Result of fdb-record-layer-pr-proto3 on Linux CentOS 7

  • Commit ID: b40c2708bd565d459ddb13afcd821e409bc139ff
  • Duration 0:13:01
  • Result: :x: FAILED
  • Error: Error while executing command: ./gradlew --no-daemon --console=plain -b ./build.gradle build destructiveTest sonarqube -PcoreNotStrict -PreleaseBuild=false -PpublishBuild=false -PspotbugsEnableHtmlReport. Reason: exit status 1
  • Build Logs (available for 30 days)

foundationdb-ci avatar Jun 30 '22 00:06 foundationdb-ci

Result of fdb-record-layer-pr-proto2 on Linux CentOS 7

  • Commit ID: e3467759c1c158034403a5a0c76b64df8baa5c8f
  • Duration 0:11:52
  • Result: :x: FAILED
  • Error: Error while executing command: ./gradlew --no-daemon --console=plain -b ./build.gradle build destructiveTest sonarqube -PcoreNotStrict -PreleaseBuild=false -PpublishBuild=false -PspotbugsEnableHtmlReport. Reason: exit status 1
  • Build Logs (available for 30 days)

foundationdb-ci avatar Jul 01 '22 17:07 foundationdb-ci

Result of fdb-record-layer-pr-proto3 on Linux CentOS 7

  • Commit ID: f2cc03ac2bc9021d84263e98683fe97ed71ce528
  • Duration 0:07:06
  • Result: :x: FAILED
  • Error: Error while executing command: ./gradlew --no-daemon --console=plain -b ./build.gradle build destructiveTest sonarqube -PcoreNotStrict -PreleaseBuild=false -PpublishBuild=false -PspotbugsEnableHtmlReport. Reason: exit status 1
  • Build Logs (available for 30 days)

foundationdb-ci avatar Jul 01 '22 18:07 foundationdb-ci

Result of fdb-record-layer-pr-proto3 on Linux CentOS 7

  • Commit ID: e3467759c1c158034403a5a0c76b64df8baa5c8f
  • Duration 1:00:44
  • Result: :x: FAILED
  • Error: Build has timed out.
  • Build Logs (available for 30 days)

foundationdb-ci avatar Jul 01 '22 18:07 foundationdb-ci

Result of fdb-record-layer-pr-proto2 on Linux CentOS 7

  • Commit ID: f2cc03ac2bc9021d84263e98683fe97ed71ce528
  • Duration 0:15:38
  • Result: :white_check_mark: SUCCEEDED
  • Error: N/A
  • Build Logs (available for 30 days)

foundationdb-ci avatar Jul 01 '22 18:07 foundationdb-ci

Result of fdb-record-layer-pr-proto2 on Linux CentOS 7

  • Commit ID: 5fc509e4eb4678884ba31a04d063cd87550a36dd
  • Duration 0:07:58
  • Result: :x: FAILED
  • Error: Error while executing command: ./gradlew --no-daemon --console=plain -b ./build.gradle build destructiveTest sonarqube -PcoreNotStrict -PreleaseBuild=false -PpublishBuild=false -PspotbugsEnableHtmlReport. Reason: exit status 1
  • Build Logs (available for 30 days)

foundationdb-ci avatar Jul 01 '22 21:07 foundationdb-ci

Result of fdb-record-layer-pr-proto2 on Linux CentOS 7

  • Commit ID: 940b4b3b620a465d2c3bc77d4d79a9d5db3673c7
  • Duration 0:14:48
  • Result: :white_check_mark: SUCCEEDED
  • Error: N/A
  • Build Logs (available for 30 days)

foundationdb-ci avatar Jul 01 '22 21:07 foundationdb-ci

Result of fdb-record-layer-pr-proto3 on Linux CentOS 7

  • Commit ID: 940b4b3b620a465d2c3bc77d4d79a9d5db3673c7
  • Duration 0:15:23
  • Result: :white_check_mark: SUCCEEDED
  • Error: N/A
  • Build Logs (available for 30 days)

foundationdb-ci avatar Jul 01 '22 21:07 foundationdb-ci

Result of fdb-record-layer-pr-proto3 on Linux CentOS 7

  • Commit ID: 5fc509e4eb4678884ba31a04d063cd87550a36dd
  • Duration 0:16:01
  • Result: :white_check_mark: SUCCEEDED
  • Error: N/A
  • Build Logs (available for 30 days)

foundationdb-ci avatar Jul 01 '22 21:07 foundationdb-ci

Result of fdb-record-layer-pr-proto2 on Linux CentOS 7

  • Commit ID: d5ee6006562be467200aaa48ae63a98fb79c1edb
  • Duration 0:14:45
  • Result: :white_check_mark: SUCCEEDED
  • Error: N/A
  • Build Logs (available for 30 days)

foundationdb-ci avatar Jul 01 '22 22:07 foundationdb-ci

Result of fdb-record-layer-pr-proto3 on Linux CentOS 7

  • Commit ID: d5ee6006562be467200aaa48ae63a98fb79c1edb
  • Duration 0:16:16
  • Result: :white_check_mark: SUCCEEDED
  • Error: N/A
  • Build Logs (available for 30 days)

foundationdb-ci avatar Jul 01 '22 22:07 foundationdb-ci

Result of fdb-record-layer-pr-proto2 on Linux CentOS 7

  • Commit ID: 70188339dc3e2ef077d903cdfa0aa45a731638db
  • Duration 0:14:38
  • Result: :white_check_mark: SUCCEEDED
  • Error: N/A
  • Build Logs (available for 30 days)

foundationdb-ci avatar Jul 01 '22 23:07 foundationdb-ci

Result of fdb-record-layer-pr-proto3 on Linux CentOS 7

  • Commit ID: 70188339dc3e2ef077d903cdfa0aa45a731638db
  • Duration 0:15:08
  • Result: :white_check_mark: SUCCEEDED
  • Error: N/A
  • Build Logs (available for 30 days)

foundationdb-ci avatar Jul 01 '22 23:07 foundationdb-ci

Closing in favor of #1774

alecgrieser avatar Oct 14 '22 10:10 alecgrieser