improve memory test

.github/workflows/verify_runner_perf.yml

@@ -0,0 +1,99 @@
+name: verify runner performance with sysbench
+
+on:
+  # uncomment to run on push for debugging your PR
+  push:
+    branches: [ 'bodobolero/sysbench_4_perf_runner' ]
+  workflow_dispatch:
+    inputs:
+      runner_labels_json:
+        description: JSON array of runner labels to test (e.g. ["small-amd64","large-amd64"]) 
+        required: false
+        default: '["unit-perf-aws-arm"]'
+
+defaults:
+  run:
+    shell: bash -euxo pipefail {0}
+
+concurrency:
+  group: sysbench-runner-perf
+  cancel-in-progress: true
+
+permissions:
+  contents: read
+
+jobs:
+  sysbench:
+    strategy:
+      fail-fast: false
+      matrix:
+        runner: ${{ fromJSON((github.event_name == 'workflow_dispatch' && inputs.runner_labels_json != '' && inputs.runner_labels_json) || '["unit-perf-aws-arm"]') }}
+    permissions:
+      id-token: write # aws-actions/configure-aws-credentials
+      statuses: write
+      contents: write
+      pull-requests: write
+    runs-on: ${{ matrix.runner }}
+    timeout-minutes: 120
+    container:
+      image: ghcr.io/neondatabase/build-tools:pinned-bookworm
+      credentials:
+        username: ${{ github.actor }}
+        password: ${{ secrets.GITHUB_TOKEN }}
+      # for changed limits, see comments on `options:` earlier in this file
+      options: --init --shm-size=512mb --ulimit memlock=67108864:67108864 --ulimit nofile=65536:65536 --security-opt seccomp=unconfined
+
+    steps:
+      - name: Checkout sysbench source
+        uses: actions/checkout@11bd71901bbe5b1630ceea73d27597364c9af683 # v4.2.2
+        with:
+          repository: akopytov/sysbench
+          ref: master
+          path: sysbench
+
+      - name: Build sysbench
+        run: |
+          cd "$GITHUB_WORKSPACE/sysbench"
+          ./autogen.sh
+          ./configure --without-mysql
+          make -j"$(nproc || sysctl -n hw.ncpu || echo 2)"
+          ./src/sysbench --version
+
+      - name: sysbench io prepare
+        run: |
+          "$GITHUB_WORKSPACE/sysbench/src/sysbench" fileio \
+            --file-total-size=2G \
+            --file-test-mode=rndrw \
+            --file-extra-flags=direct \
+            --file-fsync-freq=0 \
+            --threads=4 \
+            --time=60 prepare
+
+      - name: sysbench io run
+        run: |
+          "$GITHUB_WORKSPACE/sysbench/src/sysbench" fileio \
+            --file-total-size=2G \
+            --file-test-mode=rndrw \
+            --file-extra-flags=direct \
+            --file-fsync-freq=0 \
+            --threads=4 \
+            --time=60 run
+
+      - name: sysbench cpu
+        run: |
+          "$GITHUB_WORKSPACE/sysbench/src/sysbench" cpu \
+            --cpu-max-prime=200000 \
+            --threads=8 \
+            --time=60 run
+
+      - name: sysbench memory
+        run: |
+          "$GITHUB_WORKSPACE/sysbench/src/sysbench" memory \
+            --memory-block-size=1M \
+            --memory-total-size=0 \
+            --threads=8 \
+            --time=60 \
+            --memory-oper=write \
+            run
+
+

vendor/revisions.json

@@ -1,11 +1,11 @@
 {
   "v17": [
     "17.5",
-    "689f8b9978b7b1600bbd8501578c02f11152816e"
+    "1e01fcea2a6b38180021aa83e0051d95286d9096"
   ],
   "v16": [
     "16.9",
-    "78312c82f9061138cedcd8f935df24f00935ef55"
+    "a42351fcd41ea01edede1daed65f651e838988fc"
   ],
   "v15": [
     "15.13",