diff options
Diffstat (limited to 'research')
62 files changed, 718 insertions, 0 deletions
diff --git a/research/experiments/025-i64-cost/2026-09-30-ab-one-process-linux-aarch64.txt b/research/experiments/025-i64-cost/2026-09-30-ab-one-process-linux-aarch64.txt new file mode 100644 index 0000000..910487d --- /dev/null +++ b/research/experiments/025-i64-cost/2026-09-30-ab-one-process-linux-aarch64.txt @@ -0,0 +1,6 @@ + 17:01:12 up 1 day, 20:13, 3 users, load average: 1.96, 2.72, 1.99 +{"query": "per_branch", "before_ms": 5.204, "after_ms": 5.284, "change_pct": 1.55, "rounds_after_slower": 10, "rounds": 12} +{"query": "in_credit", "before_ms": 0.812, "after_ms": 0.811, "change_pct": -0.13, "rounds_after_slower": 6, "rounds": 12} +{"query": "large", "before_ms": 0.366, "after_ms": 0.371, "change_pct": 1.44, "rounds_after_slower": 9, "rounds": 12} +{"query": "ranks", "before_ms": 6.589, "after_ms": 6.772, "change_pct": 2.76, "rounds_after_slower": 11, "rounds": 12} + 17:01:55 up 1 day, 20:14, 3 users, load average: 1.74, 2.57, 1.98 diff --git a/research/experiments/025-i64-cost/2026-09-30-ab-sessions-linux-aarch64.txt b/research/experiments/025-i64-cost/2026-09-30-ab-sessions-linux-aarch64.txt new file mode 100644 index 0000000..3cfc5d0 --- /dev/null +++ b/research/experiments/025-i64-cost/2026-09-30-ab-sessions-linux-aarch64.txt @@ -0,0 +1,41 @@ +== session 1 first=9a03e72 1.01 1.79 1.79 +{"query": "per_branch", "before_ms": 5.282, "after_ms": 5.335, "change_pct": 0.99, "rounds_after_slower": 4, "rounds": 6} +{"query": "in_credit", "before_ms": 0.848, "after_ms": 0.842, "change_pct": -0.66, "rounds_after_slower": 2, "rounds": 6} +{"query": "large", "before_ms": 0.375, "after_ms": 0.377, "change_pct": 0.58, "rounds_after_slower": 4, "rounds": 6} +{"query": "ranks", "before_ms": 6.708, "after_ms": 6.83, "change_pct": 1.82, "rounds_after_slower": 4, "rounds": 6} +== session 2 first=fc65d66 1.43 1.81 1.80 +{"query": "per_branch", "before_ms": 5.246, "after_ms": 5.308, "change_pct": 1.18, "rounds_after_slower": 5, "rounds": 6} +{"query": "in_credit", "before_ms": 0.83, "after_ms": 0.859, "change_pct": 3.54, "rounds_after_slower": 6, "rounds": 6} +{"query": "large", "before_ms": 0.374, "after_ms": 0.378, "change_pct": 1.01, "rounds_after_slower": 3, "rounds": 6} +{"query": "ranks", "before_ms": 6.841, "after_ms": 6.782, "change_pct": -0.87, "rounds_after_slower": 0, "rounds": 6} +== session 3 first=9a03e72 1.88 1.91 1.84 +{"query": "per_branch", "before_ms": 5.295, "after_ms": 5.374, "change_pct": 1.49, "rounds_after_slower": 5, "rounds": 6} +{"query": "in_credit", "before_ms": 0.853, "after_ms": 0.864, "change_pct": 1.26, "rounds_after_slower": 5, "rounds": 6} +{"query": "large", "before_ms": 0.369, "after_ms": 0.376, "change_pct": 1.97, "rounds_after_slower": 4, "rounds": 6} +{"query": "ranks", "before_ms": 6.702, "after_ms": 6.872, "change_pct": 2.53, "rounds_after_slower": 6, "rounds": 6} +== session 4 first=fc65d66 1.88 1.92 1.84 +{"query": "per_branch", "before_ms": 5.284, "after_ms": 5.333, "change_pct": 0.93, "rounds_after_slower": 5, "rounds": 6} +{"query": "in_credit", "before_ms": 0.833, "after_ms": 0.872, "change_pct": 4.6, "rounds_after_slower": 6, "rounds": 6} +{"query": "large", "before_ms": 0.377, "after_ms": 0.371, "change_pct": -1.52, "rounds_after_slower": 2, "rounds": 6} +{"query": "ranks", "before_ms": 6.873, "after_ms": 6.802, "change_pct": -1.04, "rounds_after_slower": 0, "rounds": 6} +== session 5 first=9a03e72 1.86 1.91 1.85 +{"query": "per_branch", "before_ms": 5.265, "after_ms": 5.289, "change_pct": 0.45, "rounds_after_slower": 4, "rounds": 6} +{"query": "in_credit", "before_ms": 0.843, "after_ms": 0.813, "change_pct": -3.62, "rounds_after_slower": 0, "rounds": 6} +{"query": "large", "before_ms": 0.368, "after_ms": 0.371, "change_pct": 0.65, "rounds_after_slower": 4, "rounds": 6} +{"query": "ranks", "before_ms": 6.715, "after_ms": 6.803, "change_pct": 1.32, "rounds_after_slower": 6, "rounds": 6} +== session 6 first=fc65d66 1.92 1.95 1.86 +{"query": "per_branch", "before_ms": 5.261, "after_ms": 5.323, "change_pct": 1.17, "rounds_after_slower": 6, "rounds": 6} +{"query": "in_credit", "before_ms": 0.828, "after_ms": 0.859, "change_pct": 3.78, "rounds_after_slower": 6, "rounds": 6} +{"query": "large", "before_ms": 0.375, "after_ms": 0.378, "change_pct": 0.84, "rounds_after_slower": 4, "rounds": 6} +{"query": "ranks", "before_ms": 6.81, "after_ms": 6.738, "change_pct": -1.05, "rounds_after_slower": 1, "rounds": 6} +== session 7 first=9a03e72 1.94 1.95 1.87 +{"query": "per_branch", "before_ms": 5.195, "after_ms": 5.265, "change_pct": 1.34, "rounds_after_slower": 6, "rounds": 6} +{"query": "in_credit", "before_ms": 0.842, "after_ms": 0.844, "change_pct": 0.26, "rounds_after_slower": 3, "rounds": 6} +{"query": "large", "before_ms": 0.368, "after_ms": 0.372, "change_pct": 1.02, "rounds_after_slower": 4, "rounds": 6} +{"query": "ranks", "before_ms": 6.646, "after_ms": 6.82, "change_pct": 2.61, "rounds_after_slower": 6, "rounds": 6} +== session 8 first=fc65d66 1.74 1.91 1.86 +{"query": "per_branch", "before_ms": 5.312, "after_ms": 5.352, "change_pct": 0.77, "rounds_after_slower": 3, "rounds": 6} +{"query": "in_credit", "before_ms": 0.838, "after_ms": 0.871, "change_pct": 3.95, "rounds_after_slower": 5, "rounds": 6} +{"query": "large", "before_ms": 0.376, "after_ms": 0.37, "change_pct": -1.62, "rounds_after_slower": 1, "rounds": 6} +{"query": "ranks", "before_ms": 6.838, "after_ms": 6.783, "change_pct": -0.8, "rounds_after_slower": 1, "rounds": 6} +== end diff --git a/research/experiments/025-i64-cost/2026-09-30-ab-three-builds-linux-aarch64.txt b/research/experiments/025-i64-cost/2026-09-30-ab-three-builds-linux-aarch64.txt new file mode 100644 index 0000000..55410e2 --- /dev/null +++ b/research/experiments/025-i64-cost/2026-09-30-ab-three-builds-linux-aarch64.txt @@ -0,0 +1,16 @@ +== 9a03e72 -> 600f576 17:03:17 up 1 day, 20:15, 3 users, load average: 0.86, 2.07, 1.85 +{"query": "per_branch", "before_ms": 5.347, "after_ms": 5.354, "change_pct": 0.13, "rounds_after_slower": 7, "rounds": 12} +{"query": "in_credit", "before_ms": 0.856, "after_ms": 0.896, "change_pct": 4.71, "rounds_after_slower": 11, "rounds": 12} +{"query": "large", "before_ms": 0.383, "after_ms": 0.371, "change_pct": -3.05, "rounds_after_slower": 3, "rounds": 12} +{"query": "ranks", "before_ms": 6.759, "after_ms": 6.866, "change_pct": 1.58, "rounds_after_slower": 12, "rounds": 12} +== 600f576 -> fc65d66 17:04:02 up 1 day, 20:16, 3 users, load average: 1.61, 2.10, 1.87 +{"query": "per_branch", "before_ms": 5.341, "after_ms": 5.342, "change_pct": 0.02, "rounds_after_slower": 5, "rounds": 12} +{"query": "in_credit", "before_ms": 0.906, "after_ms": 0.848, "change_pct": -6.45, "rounds_after_slower": 1, "rounds": 12} +{"query": "large", "before_ms": 0.374, "after_ms": 0.374, "change_pct": -0.04, "rounds_after_slower": 6, "rounds": 12} +{"query": "ranks", "before_ms": 6.938, "after_ms": 6.855, "change_pct": -1.21, "rounds_after_slower": 0, "rounds": 12} +== 9a03e72 -> fc65d66 17:04:46 up 1 day, 20:17, 3 users, load average: 1.55, 2.02, 1.86 +{"query": "per_branch", "before_ms": 5.226, "after_ms": 5.32, "change_pct": 1.82, "rounds_after_slower": 12, "rounds": 12} +{"query": "in_credit", "before_ms": 0.838, "after_ms": 0.844, "change_pct": 0.73, "rounds_after_slower": 6, "rounds": 12} +{"query": "large", "before_ms": 0.371, "after_ms": 0.377, "change_pct": 1.65, "rounds_after_slower": 11, "rounds": 12} +{"query": "ranks", "before_ms": 6.7, "after_ms": 6.89, "change_pct": 2.84, "rounds_after_slower": 11, "rounds": 12} +== end 17:05:29 up 1 day, 20:17, 3 users, load average: 1.77, 2.03, 1.87 diff --git a/research/experiments/025-i64-cost/2026-09-30-counts-linux-aarch64.jsonl b/research/experiments/025-i64-cost/2026-09-30-counts-linux-aarch64.jsonl new file mode 100644 index 0000000..a341c52 --- /dev/null +++ b/research/experiments/025-i64-cost/2026-09-30-counts-linux-aarch64.jsonl @@ -0,0 +1,6 @@ +{"serve": "pure-serve-9a03e72", "per_branch": {"instructions": 26573973, "cycles": 13283789}, "in_credit": {"instructions": 3426707, "cycles": 1712742}, "large": {"instructions": 1419697, "cycles": 664947}, "ranks": {"instructions": 24027052, "cycles": 16320291}, "none": {"instructions": 600426, "cycles": 202773}, "field": {"instructions": 8578787, "cycles": 3196185}, "found": {"instructions": 15444536, "cycles": 14268703}} +{"serve": "pure-serve-fc65d66", "per_branch": {"instructions": 27706898, "cycles": 13383953}, "in_credit": {"instructions": 3486089, "cycles": 1944712}, "large": {"instructions": 1451399, "cycles": 795160}, "ranks": {"instructions": 24209827, "cycles": 16308403}, "none": {"instructions": 607929, "cycles": 203740}, "field": {"instructions": 8778300, "cycles": 3246879}, "found": {"instructions": 15844580, "cycles": 15341799}} +{"serve": "pure-serve-fcc1f67", "per_branch": {"instructions": 27163122, "cycles": 12372129}, "in_credit": {"instructions": 3511620, "cycles": 1594933}, "large": {"instructions": 1438407, "cycles": 655665}, "ranks": {"instructions": 24255927, "cycles": 14812096}, "none": {"instructions": 606073, "cycles": 189986}, "field": {"instructions": 8694610, "cycles": 3130854}, "found": {"instructions": 15638800, "cycles": 12938040}} +{"serve": "pure-serve-9a03e72", "per_branch": {"instructions": 26762607, "cycles": 12258686}, "in_credit": {"instructions": 3468633, "cycles": 1793361}, "large": {"instructions": 1419641, "cycles": 659199}, "ranks": {"instructions": 24127370, "cycles": 14890261}, "none": {"instructions": 600426, "cycles": 186167}, "field": {"instructions": 8578786, "cycles": 3132990}, "found": {"instructions": 15440696, "cycles": 12612990}} +{"serve": "pure-serve-fc65d66", "per_branch": {"instructions": 27563165, "cycles": 12898144}, "in_credit": {"instructions": 3453795, "cycles": 1818227}, "large": {"instructions": 1451375, "cycles": 671523}, "ranks": {"instructions": 24131232, "cycles": 15789007}, "none": {"instructions": 607929, "cycles": 202387}, "field": {"instructions": 8778300, "cycles": 3242454}, "found": {"instructions": 15845125, "cycles": 13777877}} +{"serve": "pure-serve-fcc1f67", "per_branch": {"instructions": 26828366, "cycles": 12400976}, "in_credit": {"instructions": 3436980, "cycles": 1566243}, "large": {"instructions": 1438543, "cycles": 684671}, "ranks": {"instructions": 24074150, "cycles": 14881326}, "none": {"instructions": 606073, "cycles": 193328}, "field": {"instructions": 8694610, "cycles": 3131256}, "found": {"instructions": 15641865, "cycles": 12558933}} diff --git a/research/experiments/025-i64-cost/2026-09-30-counts-quiet-linux-aarch64.jsonl b/research/experiments/025-i64-cost/2026-09-30-counts-quiet-linux-aarch64.jsonl new file mode 100644 index 0000000..dfde39c --- /dev/null +++ b/research/experiments/025-i64-cost/2026-09-30-counts-quiet-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"serve": "pure-serve-9a03e72", "per_branch": {"instructions": 26808820, "cycles": 12306674}, "in_credit": {"instructions": 3478947, "cycles": 1693826}, "large": {"instructions": 1419714, "cycles": 662500}, "ranks": {"instructions": 24153397, "cycles": 14960333}} +{"serve": "pure-serve-fc65d66", "per_branch": {"instructions": 27783451, "cycles": 12224981}, "in_credit": {"instructions": 3503305, "cycles": 1661676}, "large": {"instructions": 1451296, "cycles": 650615}, "ranks": {"instructions": 24251536, "cycles": 15409967}} +{"serve": "pure-serve-9a03e72", "per_branch": {"instructions": 26518720, "cycles": 13204114}, "in_credit": {"instructions": 3414472, "cycles": 1663533}, "large": {"instructions": 1419706, "cycles": 651682}, "ranks": {"instructions": 23997212, "cycles": 15079308}} +{"serve": "pure-serve-fc65d66", "per_branch": {"instructions": 27813388, "cycles": 12169542}, "in_credit": {"instructions": 3510164, "cycles": 1718874}, "large": {"instructions": 1451416, "cycles": 648132}, "ranks": {"instructions": 24268857, "cycles": 15454473}} diff --git a/research/experiments/025-i64-cost/2026-09-30-profile-field-linux-aarch64.txt b/research/experiments/025-i64-cost/2026-09-30-profile-field-linux-aarch64.txt new file mode 100644 index 0000000..dd0d625 --- /dev/null +++ b/research/experiments/025-i64-cost/2026-09-30-profile-field-linux-aarch64.txt @@ -0,0 +1,25 @@ +function e-serve-9a03e72 e-serve-fc65d66 e-serve-fcc1f67 +run 20.26% 19.55% 19.29% +pure_format_number 17.71% 18.74% 18.46% +filtered 10.63% 10.25% 10.48% +evaluate 8.49% 8.45% 8.49% +put_bytes 8.58% 9.50% 7.20% +libc.so.6 7.12% 4.39% 6.29% +pure_app_row_item 5.23% 5.55% 5.83% +show_given 5.74% 5.03% 5.64% +pure_list_get 4.90% 3.82% 6.07% +pure_app_cell 4.49% 4.79% 4.63% +run_lanes 3.03% 3.67% 4.24% +_init 1.26% 1.04% 1.02% +keep_row 1.00% 1.01% 1.12% +cell_at 0.00% 2.98% 0.00% +pure_list_next 0.75% 0.63% 0.61% +pure_list_count 0.68% 0.47% 0.56% +open_run 0.00% 0.10% 0.05% +pure_app_read 0.09% 0.00% 0.00% +pure_list_run.part.0 0.00% 0.02% 0.00% +[other] 0.01% 0.00% 0.01% +pure_module_view 0.01% 0.00% 0.00% +start_request 0.00% 0.00% 0.01% +answer_applied 0.00% 0.00% 0.00% +serve_bursts 0.00% 0.00% 0.00% diff --git a/research/experiments/025-i64-cost/ab-sessions.sh b/research/experiments/025-i64-cost/ab-sessions.sh new file mode 100755 index 0000000..b4b5b1d --- /dev/null +++ b/research/experiments/025-i64-cost/ab-sessions.sh @@ -0,0 +1,13 @@ +#!/bin/zsh +# ab-sessions.sh DIR A B SESSIONS: ab.py on fresh processes each session, +# pure-serve-A and pure-serve-B from DIR, which starts first alternating; +# each session waits for a load average below 2. +here=${0:A:h} +dir=$1 a=$2 b=$3 n=$4 +for i in $(seq 1 $n); do + until [ "$(cut -d' ' -f1 /proc/loadavg | cut -d. -f1)" -lt 2 ]; do sleep 5; done + if (( i % 2 )); then first=$a second=$b; else first=$b second=$a; fi + echo "== session $i first=$first $(cut -d' ' -f1-3 /proc/loadavg)" + python3 $here/ab.py $dir/pure-serve-$first $dir/pure-serve-$second 6 30 2>&1 +done +echo "== end" diff --git a/research/experiments/025-i64-cost/ab.py b/research/experiments/025-i64-cost/ab.py new file mode 100755 index 0000000..a07ef72 --- /dev/null +++ b/research/experiments/025-i64-cost/ab.py @@ -0,0 +1,75 @@ +#!/usr/bin/env python3 +"""The bank's four queries on two pure-serves at once, the same rows loaded +into each, asked in turns (the order flipped every round): ab.py BEFORE AFTER +ROUNDS ASKS. Prints each query's median of the rounds' medians, and in how +many rounds AFTER was slower. One process a side: what differs between two +processes (where code and data land) stays in the comparison, so run it +again on fresh processes (ab-sessions.sh) before believing a percent.""" +import http.client, json, random, select, shutil, statistics, subprocess, sys, tempfile, time +from pathlib import Path +ROOT = Path(__file__).resolve().parents[3] +sys.path.insert(0, str(ROOT / 'benchmarks' / 'bank')) +import queries as q +aup = str(ROOT.parent / 'aup' / 'build' / 'aup') +serves = {'before': sys.argv[1], 'after': sys.argv[2]} +rounds, asks = int(sys.argv[3]), int(sys.argv[4]) +work = Path(tempfile.mkdtemp(prefix='pure-ab-', dir='/dev/shm')) +processes = {} +try: + module = work / 'bank.pmod' + subprocess.run([aup, 'build', str(q.HERE / 'bank.aup'), '-o', str(module)], check=True) + compiled = {} + for name, (view, _) in q.QUERIES.items(): + (work / f'{name}.aup').write_text(view) + subprocess.run([aup, 'query', str(q.HERE / 'bank.aup'), str(work / f'{name}.aup'), '-o', str(work / f'{name}.pmod')], check=True) + compiled[name] = (work / f'{name}.pmod').read_bytes() + ports = {} + for version, serve in serves.items(): + p = subprocess.Popen(['taskset', '-c', '0-2', serve, '--module', str(module), '--store', str(work / f'store-{version}'), + '--port', '0', '--timeout-ms', '600000'], stdout=subprocess.PIPE, stderr=subprocess.PIPE) + processes[version] = p + select.select([p.stdout], [], [], 10) + ports[version] = json.loads(p.stdout.readline())['port'] + accounts, branches, transfers_n = 100000, 10, 20000 + rng = random.Random(9) + tellers = 10 * branches + transfers = [(rng.randint(1, accounts), rng.randint(1, tellers), rng.randint(1, branches), rng.randint(-5000, 5000)) + for _ in range(transfers_n)] + for version, port in ports.items(): + q.post_all(port, '/inputs/branch', [json.dumps({'bid': b}).encode() for b in range(1, branches + 1)], 1) + q.post_all(port, '/inputs/teller', [json.dumps({'tid': t, 'bid': (t - 1) // 10 + 1}).encode() for t in range(1, tellers + 1)], 1) + q.post_all(port, '/inputs/account', [json.dumps({'aid': a, 'bid': (a - 1) % branches + 1}).encode() + for a in range(1, accounts + 1)]) + q.post_all(port, '/inputs/transfer', [json.dumps({'aid': a, 'tid': t, 'bid': b, 'delta': d}).encode() + for a, t, b, d in transfers], 1) + clients = {v: http.client.HTTPConnection('127.0.0.1', port, timeout=120) for v, port in ports.items()} + for v, client in clients.items(): + for name, data in compiled.items(): + client.request('PUT', f'/queries/{name}', data) + r = client.getresponse(); r.read(); assert r.status == 200 + answers = {} + medians = {v: {name: [] for name in q.QUERIES} for v in serves} + for r in range(rounds): + order = ['before', 'after'] if r % 2 == 0 else ['after', 'before'] + for name in q.QUERIES: + for v in order: + times = [] + for _ in range(asks): + began = time.perf_counter() + clients[v].request('GET', f'/queries/{name}') + res = clients[v].getresponse(); data = res.read() + times.append(time.perf_counter() - began) + assert res.status == 200 + answers.setdefault(name, data) + assert answers[name] == data, name # both answer alike + medians[v][name].append(statistics.median(times) * 1e3) + for name in q.QUERIES: + b, a = medians['before'][name], medians['after'][name] + wins = sum(1 for x, y in zip(b, a) if y > x) + print(json.dumps({'query': name, 'before_ms': round(statistics.median(b), 3), 'after_ms': round(statistics.median(a), 3), + 'change_pct': round((statistics.median(a) / statistics.median(b) - 1) * 100, 2), + 'rounds_after_slower': wins, 'rounds': len(b)}), flush=True) +finally: + for p in processes.values(): + p.terminate(); p.communicate(timeout=60) + shutil.rmtree(work) diff --git a/research/experiments/025-i64-cost/count.py b/research/experiments/025-i64-cost/count.py new file mode 100755 index 0000000..aa4f1c7 --- /dev/null +++ b/research/experiments/025-i64-cost/count.py @@ -0,0 +1,159 @@ +#!/usr/bin/env python3 +"""User-mode instructions and cycles per ask of queries over the bank +(benchmarks/bank, 100,000 accounts), on fresh pure-serves: the bank's four +queries and three tables over its 20,000 transfers (none kept, one field a +row, a row's account found by key). Each server is loaded alike, warmed, +then counted over ASKS asks per query with pcount (perf_event_open, every +thread of the server). Instructions are what a change adds or takes away; +cycles move with where code and data land, too. + + count.py [--profile QUERY] serve [serve ...] + +With --profile, psample samples QUERY's instruction pointers (one per +20,011 instructions) and the shares of the functions are printed instead. +""" +import argparse, bisect, collections, http.client, json, random, select, shutil, subprocess, sys, tempfile +from pathlib import Path + +HERE = Path(__file__).resolve().parent +ROOT = HERE.parents[2] +sys.path.insert(0, str(ROOT / 'benchmarks' / 'bank')) +import queries as bank # noqa: E402 + +TABLES = { + 'none': 'view none = each h in history where h.delta > 5000 {\n aid = h.aid\n}\n', + 'field': 'view field = each h in history where h.delta > 0 {\n aid = h.aid\n}\n', + 'found': 'view found = each h in history where h.delta > 0 {\n account = accounts[h.aid].balance\n}\n', +} +ASKS = 60 + + +def load(port): + rng = random.Random(9) + transfers = [(rng.randint(1, 100000), rng.randint(1, 100), rng.randint(1, 10), rng.randint(-5000, 5000)) + for _ in range(20000)] + bank.post_all(port, '/inputs/branch', [json.dumps({'bid': b}).encode() for b in range(1, 11)], 1) + bank.post_all(port, '/inputs/teller', [json.dumps({'tid': t, 'bid': (t - 1) // 10 + 1}).encode() for t in range(1, 101)], 1) + bank.post_all(port, '/inputs/account', [json.dumps({'aid': a, 'bid': (a - 1) % 10 + 1}).encode() + for a in range(1, 100001)]) + bank.post_all(port, '/inputs/transfer', [json.dumps({'aid': a, 'tid': t, 'bid': b, 'delta': d}).encode() + for a, t, b, d in transfers], 1) + + +def functions(binary, maps, samples): + """Samples by function: the binary's by its symbols, others by their file.""" + listed = subprocess.run(['nm', '-n', '--defined-only', binary], capture_output=True, text=True, check=True).stdout + starts, names = [], [] + for line in listed.splitlines(): + parts = line.split() + if len(parts) == 3 and parts[1] in 'tTwW': + starts.append(int(parts[0], 16)) + names.append(parts[2]) + ranges = [] + for line in maps.splitlines(): + parts = line.split() + if len(parts) >= 6 and 'x' in parts[1]: + low, high = (int(x, 16) for x in parts[0].split('-')) + ranges.append((low, high, int(parts[2], 16), parts[5])) + counts = collections.Counter() + for ip in samples: + for low, high, offset, path in ranges: + if low <= ip < high: + if path == binary: + i = bisect.bisect_right(starts, ip - low + offset) - 1 + counts[names[i] if i >= 0 else '?'] += 1 + else: + counts[Path(path).name] += 1 + break + else: + counts['[other]'] += 1 + return counts + + +def main(): + parser = argparse.ArgumentParser() + parser.add_argument('--aup', type=Path, default=ROOT.parent / 'aup' / 'build' / 'aup') + parser.add_argument('--profile', help='a query to sample instead of counting') + parser.add_argument('--asks', type=int, default=ASKS) + parser.add_argument('serves', nargs='+', type=Path) + args = parser.parse_args() + views = {name: view for name, (view, _) in bank.QUERIES.items()} | TABLES + if args.profile: + views = {args.profile: views[args.profile]} + work = Path(tempfile.mkdtemp(prefix='pure-count-', dir='/dev/shm')) + try: + for tool in ('pcount', 'psample'): + subprocess.run(['cc', '-O2', '-Wall', '-o', str(work / tool), str(HERE / f'{tool}.c')], check=True) + module = work / 'bank.pmod' + subprocess.run([str(args.aup), 'build', str(bank.HERE / 'bank.aup'), '-o', str(module)], check=True) + compiled = {} + for name, view in views.items(): + (work / f'{name}.aup').write_text(view) + subprocess.run([str(args.aup), 'query', str(bank.HERE / 'bank.aup'), str(work / f'{name}.aup'), '-o', + str(work / f'{name}.pmod')], check=True) + compiled[name] = (work / f'{name}.pmod').read_bytes() + profiles = {} + for k, serve in enumerate(args.serves): + serve = serve.resolve() + process = subprocess.Popen(['taskset', '-c', '0-2', str(serve), '--module', str(module), '--store', + str(work / f'store-{k}'), '--port', '0', '--timeout-ms', '600000'], + stdout=subprocess.PIPE, stderr=subprocess.PIPE) + try: + select.select([process.stdout], [], [], 10) + port = json.loads(process.stdout.readline())['port'] + load(port) + client = http.client.HTTPConnection('127.0.0.1', port, timeout=120) + + def ask(method, path, body=None): + client.request(method, path, body) + answer = client.getresponse() + data = answer.read() + assert answer.status == 200, (path, answer.status) + return data + + for name, bytes_ in compiled.items(): + ask('PUT', f'/queries/{name}', bytes_) + for _ in range(5): + ask('GET', f'/queries/{name}') + if args.profile: + maps = Path(f'/proc/{process.pid}/maps').read_text() + sampler = subprocess.Popen([str(work / 'psample'), str(process.pid), '20011'], stdin=subprocess.PIPE, + stdout=subprocess.PIPE, stderr=subprocess.PIPE, text=True) + assert sampler.stderr.readline().strip() == 'ready' + for _ in range(args.asks): + ask('GET', f'/queries/{args.profile}') + out, _ = sampler.communicate('') + samples = [int(line, 16) for line in out.splitlines() if not line.startswith('lost')] + profiles[serve.name] = (len(samples), functions(str(serve), maps, samples)) + else: + result = {'serve': serve.name} + for name in compiled: + counter = subprocess.Popen([str(work / 'pcount'), str(process.pid)], stdin=subprocess.PIPE, + stdout=subprocess.PIPE, stderr=subprocess.PIPE, text=True) + assert counter.stderr.readline().strip() == 'ready' + for _ in range(args.asks): + ask('GET', f'/queries/{name}') + counts = json.loads(counter.communicate('')[0]) + result[name] = {'instructions': round(counts['instructions'] / args.asks), + 'cycles': round(counts['cycles'] / args.asks)} + print(json.dumps(result), flush=True) + client.close() + finally: + process.terminate() + process.communicate(timeout=60) + if profiles: + labels = list(profiles) + shares = collections.Counter() + for total, counts in profiles.values(): + for name, count in counts.items(): + shares[name] += count / total + print('%-32s' % 'function' + ''.join('%16s' % label[-15:] for label in labels)) + for name, _ in shares.most_common(24): + print('%-32s' % name[:32] + ''.join('%15.2f%%' % (100 * profiles[label][1][name] / profiles[label][0]) + for label in labels)) + finally: + shutil.rmtree(work) + + +if __name__ == '__main__': + main() diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-load.txt b/research/experiments/025-i64-cost/fc65d66/2026-09-30-load.txt new file mode 100644 index 0000000..961d1b7 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-load.txt @@ -0,0 +1,12 @@ +1 before 16:39:53 up 1 day, 19:52, 3 users, load average: 0.37, 0.47, 1.03 +1 after 16:41:20 up 1 day, 19:53, 3 users, load average: 0.90, 0.64, 1.04 +2 after 16:42:47 up 1 day, 19:55, 3 users, load average: 1.35, 0.91, 1.10 +2 before 16:44:13 up 1 day, 19:56, 3 users, load average: 1.46, 1.12, 1.16 +3 before 16:45:39 up 1 day, 19:58, 3 users, load average: 1.51, 1.27, 1.21 +3 after 16:47:05 up 1 day, 19:59, 3 users, load average: 1.57, 1.41, 1.27 +4 after 16:48:31 up 1 day, 20:00, 3 users, load average: 1.63, 1.54, 1.33 +4 before 16:49:58 up 1 day, 20:02, 3 users, load average: 1.77, 1.62, 1.38 +5 before 16:51:25 up 1 day, 20:03, 3 users, load average: 1.38, 1.57, 1.38 +5 after 16:52:51 up 1 day, 20:05, 3 users, load average: 1.39, 1.57, 1.40 +6 after 16:54:17 up 1 day, 20:06, 3 users, load average: 1.43, 1.58, 1.42 +6 before 16:55:43 up 1 day, 20:08, 3 users, load average: 1.70, 1.67, 1.47 diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-1-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-1-linux-aarch64.jsonl new file mode 100644 index 0000000..b7ac04d --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-1-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.32, "pure_fastest_ms": 5.23, "sqlite_median_ms": 45.37, "sqlite_fastest_ms": 45.16, "sqlite_indexed_median_ms": 14.14, "sqlite_indexed_fastest_ms": 14.09} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.83, "pure_fastest_ms": 0.8, "sqlite_median_ms": 5.91, "sqlite_fastest_ms": 5.87, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.39, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.85, "pure_fastest_ms": 6.79, "sqlite_median_ms": 2833.5, "sqlite_fastest_ms": 2830.55, "sqlite_indexed_median_ms": 7.55, "sqlite_indexed_fastest_ms": 7.5} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-2-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-2-linux-aarch64.jsonl new file mode 100644 index 0000000..3ddcd9b --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-2-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.19, "pure_fastest_ms": 5.15, "sqlite_median_ms": 45.26, "sqlite_fastest_ms": 45.13, "sqlite_indexed_median_ms": 14.13, "sqlite_indexed_fastest_ms": 14.05} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.84, "pure_fastest_ms": 0.8, "sqlite_median_ms": 5.9, "sqlite_fastest_ms": 5.87, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.39, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.48} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.73, "pure_fastest_ms": 6.69, "sqlite_median_ms": 2836.32, "sqlite_fastest_ms": 2829.35, "sqlite_indexed_median_ms": 7.55, "sqlite_indexed_fastest_ms": 7.5} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-3-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-3-linux-aarch64.jsonl new file mode 100644 index 0000000..2e2f3bb --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-3-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.22, "pure_fastest_ms": 5.14, "sqlite_median_ms": 45.04, "sqlite_fastest_ms": 44.92, "sqlite_indexed_median_ms": 13.94, "sqlite_indexed_fastest_ms": 13.93} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.8, "pure_fastest_ms": 0.78, "sqlite_median_ms": 5.89, "sqlite_fastest_ms": 5.86, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.38, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.47, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.47, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.82, "pure_fastest_ms": 6.76, "sqlite_median_ms": 2831.03, "sqlite_fastest_ms": 2829.06, "sqlite_indexed_median_ms": 7.56, "sqlite_indexed_fastest_ms": 7.5} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-4-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-4-linux-aarch64.jsonl new file mode 100644 index 0000000..d19011b --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-4-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.28, "pure_fastest_ms": 5.24, "sqlite_median_ms": 45.33, "sqlite_fastest_ms": 45.1, "sqlite_indexed_median_ms": 14.09, "sqlite_indexed_fastest_ms": 14.04} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.87, "pure_fastest_ms": 0.83, "sqlite_median_ms": 5.88, "sqlite_fastest_ms": 5.86, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.15} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.39, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.51, "sqlite_indexed_fastest_ms": 1.48} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.85, "pure_fastest_ms": 6.77, "sqlite_median_ms": 2835.63, "sqlite_fastest_ms": 2831.04, "sqlite_indexed_median_ms": 7.6, "sqlite_indexed_fastest_ms": 7.51} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-5-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-5-linux-aarch64.jsonl new file mode 100644 index 0000000..89036cb --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-5-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.41, "pure_fastest_ms": 5.29, "sqlite_median_ms": 44.93, "sqlite_fastest_ms": 44.86, "sqlite_indexed_median_ms": 14.05, "sqlite_indexed_fastest_ms": 14.03} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.84, "pure_fastest_ms": 0.81, "sqlite_median_ms": 5.88, "sqlite_fastest_ms": 5.87, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.38, "pure_fastest_ms": 0.36, "sqlite_median_ms": 1.47, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.51, "sqlite_indexed_fastest_ms": 1.49} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.76, "pure_fastest_ms": 6.72, "sqlite_median_ms": 2832.88, "sqlite_fastest_ms": 2828.84, "sqlite_indexed_median_ms": 7.52, "sqlite_indexed_fastest_ms": 7.49} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-6-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-6-linux-aarch64.jsonl new file mode 100644 index 0000000..3bff479 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-after-6-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.33, "pure_fastest_ms": 5.25, "sqlite_median_ms": 44.94, "sqlite_fastest_ms": 44.7, "sqlite_indexed_median_ms": 14.06, "sqlite_indexed_fastest_ms": 14.03} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.95, "pure_fastest_ms": 0.84, "sqlite_median_ms": 7.83, "sqlite_fastest_ms": 5.88, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.38, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.48, "sqlite_indexed_median_ms": 1.49, "sqlite_indexed_fastest_ms": 1.49} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.86, "pure_fastest_ms": 6.75, "sqlite_median_ms": 2836.5, "sqlite_fastest_ms": 2829.49, "sqlite_indexed_median_ms": 7.59, "sqlite_indexed_fastest_ms": 7.53} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-1-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-1-linux-aarch64.jsonl new file mode 100644 index 0000000..2e99769 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-1-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.28, "pure_fastest_ms": 5.21, "sqlite_median_ms": 45.38, "sqlite_fastest_ms": 45.26, "sqlite_indexed_median_ms": 14.14, "sqlite_indexed_fastest_ms": 14.1} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.86, "pure_fastest_ms": 0.81, "sqlite_median_ms": 5.91, "sqlite_fastest_ms": 5.87, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.37, "pure_fastest_ms": 0.36, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.47, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.72, "pure_fastest_ms": 6.66, "sqlite_median_ms": 2841.33, "sqlite_fastest_ms": 2833.37, "sqlite_indexed_median_ms": 7.56, "sqlite_indexed_fastest_ms": 7.5} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-2-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-2-linux-aarch64.jsonl new file mode 100644 index 0000000..9a42524 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-2-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.33, "pure_fastest_ms": 5.19, "sqlite_median_ms": 45.31, "sqlite_fastest_ms": 45.15, "sqlite_indexed_median_ms": 14.0, "sqlite_indexed_fastest_ms": 13.97} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.85, "pure_fastest_ms": 0.81, "sqlite_median_ms": 5.9, "sqlite_fastest_ms": 5.86, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.38, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.7, "pure_fastest_ms": 6.63, "sqlite_median_ms": 2832.6, "sqlite_fastest_ms": 2831.26, "sqlite_indexed_median_ms": 7.52, "sqlite_indexed_fastest_ms": 7.49} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-3-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-3-linux-aarch64.jsonl new file mode 100644 index 0000000..6760f3e --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-3-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.21, "pure_fastest_ms": 5.13, "sqlite_median_ms": 44.96, "sqlite_fastest_ms": 44.82, "sqlite_indexed_median_ms": 14.04, "sqlite_indexed_fastest_ms": 14.01} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.83, "pure_fastest_ms": 0.8, "sqlite_median_ms": 5.88, "sqlite_fastest_ms": 5.86, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.39, "pure_fastest_ms": 0.36, "sqlite_median_ms": 1.47, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.47, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.68, "pure_fastest_ms": 6.62, "sqlite_median_ms": 2830.7, "sqlite_fastest_ms": 2828.39, "sqlite_indexed_median_ms": 7.52, "sqlite_indexed_fastest_ms": 7.49} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-4-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-4-linux-aarch64.jsonl new file mode 100644 index 0000000..d5984c6 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-4-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.3, "pure_fastest_ms": 5.23, "sqlite_median_ms": 45.27, "sqlite_fastest_ms": 45.16, "sqlite_indexed_median_ms": 14.05, "sqlite_indexed_fastest_ms": 13.94} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.86, "pure_fastest_ms": 0.82, "sqlite_median_ms": 5.87, "sqlite_fastest_ms": 5.85, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.38, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.47, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.67, "pure_fastest_ms": 6.57, "sqlite_median_ms": 2829.96, "sqlite_fastest_ms": 2827.42, "sqlite_indexed_median_ms": 7.59, "sqlite_indexed_fastest_ms": 7.55} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-5-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-5-linux-aarch64.jsonl new file mode 100644 index 0000000..f62b096 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-5-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.12, "pure_fastest_ms": 5.06, "sqlite_median_ms": 45.26, "sqlite_fastest_ms": 45.11, "sqlite_indexed_median_ms": 14.14, "sqlite_indexed_fastest_ms": 14.1} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.82, "pure_fastest_ms": 0.8, "sqlite_median_ms": 5.86, "sqlite_fastest_ms": 5.86, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.37, "pure_fastest_ms": 0.36, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.5, "sqlite_indexed_fastest_ms": 1.49} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.75, "pure_fastest_ms": 6.57, "sqlite_median_ms": 2830.31, "sqlite_fastest_ms": 2828.07, "sqlite_indexed_median_ms": 7.63, "sqlite_indexed_fastest_ms": 7.6} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-6-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-6-linux-aarch64.jsonl new file mode 100644 index 0000000..22125d5 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-queries-before-6-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.26, "pure_fastest_ms": 5.2, "sqlite_median_ms": 45.24, "sqlite_fastest_ms": 45.15, "sqlite_indexed_median_ms": 13.96, "sqlite_indexed_fastest_ms": 13.91} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.83, "pure_fastest_ms": 0.82, "sqlite_median_ms": 5.88, "sqlite_fastest_ms": 5.86, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.4, "pure_fastest_ms": 0.36, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.47, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.66, "pure_fastest_ms": 6.62, "sqlite_median_ms": 2829.63, "sqlite_fastest_ms": 2827.5, "sqlite_indexed_median_ms": 7.57, "sqlite_indexed_fastest_ms": 7.52} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-1-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-1-linux-aarch64.jsonl new file mode 100644 index 0000000..b44ef51 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-1-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.73, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 42974, "new_orders_per_minute": 1149903, "undone_new_orders": 3672, "errors": 0, "new_order": {"done": 386978, "failed": 0, "p50_us": 1472, "p99_us": 3456}, "payment": {"done": 369343, "failed": 0, "p50_us": 1472, "p99_us": 3328}, "order_status": {"done": 34499, "failed": 0, "p50_us": 256, "p99_us": 1408}, "delivery": {"done": 34435, "failed": 0, "p50_us": 1472, "p99_us": 3456}, "stock_level": {"done": 34246, "failed": 0, "p50_us": 304, "p99_us": 1408}, "server_threads": "3", "cpu_us_per_transaction": 44.9, "core_shares": {"pure-owner": 0.9, "pure-checkpoint": 0.01}, "resident_mib": 450.6, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 450.6, "pure_state_mib": 229.3, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26442, "burst_events": 787169, "checkpoints": 38}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-2-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-2-linux-aarch64.jsonl new file mode 100644 index 0000000..64c22fd --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-2-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.73, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43683, "new_orders_per_minute": 1168830, "undone_new_orders": 3742, "errors": 0, "new_order": {"done": 393352, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "payment": {"done": 375476, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "order_status": {"done": 35039, "failed": 0, "p50_us": 256, "p99_us": 1088}, "delivery": {"done": 34980, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "stock_level": {"done": 34816, "failed": 0, "p50_us": 288, "p99_us": 1152}, "server_threads": "3", "cpu_us_per_transaction": 43.7, "core_shares": {"pure-owner": 0.91, "pure-checkpoint": 0.01}, "resident_mib": 457.2, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 457.2, "pure_state_mib": 232.7, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26166, "burst_events": 800149, "checkpoints": 39}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-3-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-3-linux-aarch64.jsonl new file mode 100644 index 0000000..6c8ba8f --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-3-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.74, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44502, "new_orders_per_minute": 1190503, "undone_new_orders": 3819, "errors": 0, "new_order": {"done": 400657, "failed": 0, "p50_us": 1472, "p99_us": 2816}, "payment": {"done": 382580, "failed": 0, "p50_us": 1472, "p99_us": 2816}, "order_status": {"done": 35684, "failed": 0, "p50_us": 256, "p99_us": 1088}, "delivery": {"done": 35645, "failed": 0, "p50_us": 1472, "p99_us": 2816}, "stock_level": {"done": 35486, "failed": 0, "p50_us": 288, "p99_us": 1152}, "server_threads": "3", "cpu_us_per_transaction": 44.0, "core_shares": {"pure-owner": 0.92, "pure-checkpoint": 0.01}, "resident_mib": 464.9, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 464.9, "pure_state_mib": 236.6, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26922, "burst_events": 815146, "checkpoints": 40}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-4-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-4-linux-aarch64.jsonl new file mode 100644 index 0000000..f0664d4 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-4-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.73, "sqlite_load_s": 1.57, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43816, "new_orders_per_minute": 1172616, "undone_new_orders": 3747, "errors": 0, "new_order": {"done": 394622, "failed": 0, "p50_us": 1472, "p99_us": 2944}, "payment": {"done": 376572, "failed": 0, "p50_us": 1472, "p99_us": 2944}, "order_status": {"done": 35112, "failed": 0, "p50_us": 256, "p99_us": 1152}, "delivery": {"done": 35080, "failed": 0, "p50_us": 1472, "p99_us": 2816}, "stock_level": {"done": 34945, "failed": 0, "p50_us": 288, "p99_us": 1216}, "server_threads": "3", "cpu_us_per_transaction": 44.5, "core_shares": {"pure-owner": 0.91, "pure-checkpoint": 0.01}, "resident_mib": 458.6, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 458.6, "pure_state_mib": 233.4, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26449, "burst_events": 802612, "checkpoints": 39}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-5-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-5-linux-aarch64.jsonl new file mode 100644 index 0000000..cc47846 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-5-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.73, "sqlite_load_s": 1.62, "sqlite_page_size": 4096, "pure_resident_mib": 38.9, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43592, "new_orders_per_minute": 1166465, "undone_new_orders": 3728, "errors": 0, "new_order": {"done": 392550, "failed": 0, "p50_us": 1472, "p99_us": 3200}, "payment": {"done": 374699, "failed": 0, "p50_us": 1472, "p99_us": 3200}, "order_status": {"done": 34950, "failed": 0, "p50_us": 256, "p99_us": 1216}, "delivery": {"done": 34905, "failed": 0, "p50_us": 1472, "p99_us": 3200}, "stock_level": {"done": 34737, "failed": 0, "p50_us": 288, "p99_us": 1344}, "server_threads": "3", "cpu_us_per_transaction": 44.6, "core_shares": {"pure-owner": 0.91, "pure-checkpoint": 0.01}, "resident_mib": 458.0, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 458.0, "pure_state_mib": 232.3, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26417, "burst_events": 798505, "checkpoints": 39}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-6-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-6-linux-aarch64.jsonl new file mode 100644 index 0000000..46b1321 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-after-6-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.73, "sqlite_load_s": 1.6, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44342, "new_orders_per_minute": 1186477, "undone_new_orders": 3797, "errors": 0, "new_order": {"done": 399291, "failed": 0, "p50_us": 1472, "p99_us": 2816}, "payment": {"done": 381121, "failed": 0, "p50_us": 1472, "p99_us": 2688}, "order_status": {"done": 35570, "failed": 0, "p50_us": 256, "p99_us": 1088}, "delivery": {"done": 35482, "failed": 0, "p50_us": 1472, "p99_us": 2688}, "stock_level": {"done": 35370, "failed": 0, "p50_us": 288, "p99_us": 1152}, "server_threads": "3", "cpu_us_per_transaction": 43.9, "core_shares": {"pure-owner": 0.91, "pure-checkpoint": 0.01}, "resident_mib": 464.0, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 464.0, "pure_state_mib": 235.9, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26550, "burst_events": 812182, "checkpoints": 40}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-1-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-1-linux-aarch64.jsonl new file mode 100644 index 0000000..32c80d5 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-1-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.73, "sqlite_load_s": 1.57, "sqlite_page_size": 4096, "pure_resident_mib": 38.9, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 42603, "new_orders_per_minute": 1139756, "undone_new_orders": 3639, "errors": 0, "new_order": {"done": 383561, "failed": 0, "p50_us": 1472, "p99_us": 3584}, "payment": {"done": 366218, "failed": 0, "p50_us": 1472, "p99_us": 3584}, "order_status": {"done": 34220, "failed": 0, "p50_us": 256, "p99_us": 1280}, "delivery": {"done": 34112, "failed": 0, "p50_us": 1472, "p99_us": 3328}, "stock_level": {"done": 33955, "failed": 0, "p50_us": 288, "p99_us": 1408}, "server_threads": "3", "cpu_us_per_transaction": 44.2, "core_shares": {"pure-owner": 0.9, "pure-checkpoint": 0.01}, "resident_mib": 447.9, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 447.9, "pure_state_mib": 227.4, "pure_store_mib": 230.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 25994, "burst_events": 780336, "checkpoints": 38}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-2-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-2-linux-aarch64.jsonl new file mode 100644 index 0000000..f604356 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-2-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.71, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44695, "new_orders_per_minute": 1195757, "undone_new_orders": 3831, "errors": 0, "new_order": {"done": 402423, "failed": 0, "p50_us": 1472, "p99_us": 2688}, "payment": {"done": 384189, "failed": 0, "p50_us": 1472, "p99_us": 2688}, "order_status": {"done": 35860, "failed": 0, "p50_us": 256, "p99_us": 992}, "delivery": {"done": 35797, "failed": 0, "p50_us": 1472, "p99_us": 2688}, "stock_level": {"done": 35652, "failed": 0, "p50_us": 288, "p99_us": 1024}, "server_threads": "3", "cpu_us_per_transaction": 43.3, "core_shares": {"pure-owner": 0.92, "pure-checkpoint": 0.01}, "resident_mib": 466.1, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 466.1, "pure_state_mib": 237.5, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26716, "burst_events": 818664, "checkpoints": 40}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-3-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-3-linux-aarch64.jsonl new file mode 100644 index 0000000..f4bc7e0 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-3-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.71, "sqlite_load_s": 1.58, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43401, "new_orders_per_minute": 1161269, "undone_new_orders": 3714, "errors": 0, "new_order": {"done": 390809, "failed": 0, "p50_us": 1472, "p99_us": 3456}, "payment": {"done": 373024, "failed": 0, "p50_us": 1472, "p99_us": 3328}, "order_status": {"done": 34840, "failed": 0, "p50_us": 256, "p99_us": 1216}, "delivery": {"done": 34749, "failed": 0, "p50_us": 1472, "p99_us": 3328}, "stock_level": {"done": 34616, "failed": 0, "p50_us": 304, "p99_us": 1280}, "server_threads": "3", "cpu_us_per_transaction": 44.4, "core_shares": {"pure-owner": 0.9, "pure-checkpoint": 0.01}, "resident_mib": 454.3, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 454.3, "pure_state_mib": 231.3, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26213, "burst_events": 794954, "checkpoints": 38}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-4-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-4-linux-aarch64.jsonl new file mode 100644 index 0000000..7d2d521 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-4-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.71, "sqlite_load_s": 1.58, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44200, "new_orders_per_minute": 1182404, "undone_new_orders": 3789, "errors": 0, "new_order": {"done": 397924, "failed": 0, "p50_us": 1472, "p99_us": 3328}, "payment": {"done": 379945, "failed": 0, "p50_us": 1408, "p99_us": 3328}, "order_status": {"done": 35457, "failed": 0, "p50_us": 248, "p99_us": 1088}, "delivery": {"done": 35437, "failed": 0, "p50_us": 1408, "p99_us": 3200}, "stock_level": {"done": 35245, "failed": 0, "p50_us": 272, "p99_us": 1216}, "server_threads": "3", "cpu_us_per_transaction": 43.0, "core_shares": {"pure-owner": 0.9, "pure-checkpoint": 0.01}, "resident_mib": 461.9, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 461.9, "pure_state_mib": 235.1, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26618, "burst_events": 809602, "checkpoints": 40}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-5-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-5-linux-aarch64.jsonl new file mode 100644 index 0000000..9bc6157 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-5-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.71, "sqlite_load_s": 1.59, "sqlite_page_size": 4096, "pure_resident_mib": 38.9, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44277, "new_orders_per_minute": 1184600, "undone_new_orders": 3801, "errors": 0, "new_order": {"done": 398668, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "payment": {"done": 380671, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "order_status": {"done": 35491, "failed": 0, "p50_us": 256, "p99_us": 1088}, "delivery": {"done": 35426, "failed": 0, "p50_us": 1472, "p99_us": 2944}, "stock_level": {"done": 35289, "failed": 0, "p50_us": 288, "p99_us": 1216}, "server_threads": "3", "cpu_us_per_transaction": 44.1, "core_shares": {"pure-owner": 0.91, "pure-checkpoint": 0.01}, "resident_mib": 463.5, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 463.5, "pure_state_mib": 235.5, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26815, "burst_events": 811039, "checkpoints": 40}} diff --git a/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-6-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-6-linux-aarch64.jsonl new file mode 100644 index 0000000..7ac5094 --- /dev/null +++ b/research/experiments/025-i64-cost/fc65d66/2026-09-30-tpcc-before-6-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.72, "sqlite_load_s": 1.56, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43843, "new_orders_per_minute": 1172899, "undone_new_orders": 3755, "errors": 0, "new_order": {"done": 394728, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "payment": {"done": 376930, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "order_status": {"done": 35183, "failed": 0, "p50_us": 256, "p99_us": 1088}, "delivery": {"done": 35075, "failed": 0, "p50_us": 1472, "p99_us": 3072}, "stock_level": {"done": 34959, "failed": 0, "p50_us": 288, "p99_us": 1152}, "server_threads": "3", "cpu_us_per_transaction": 43.7, "core_shares": {"pure-owner": 0.91, "pure-checkpoint": 0.01}, "resident_mib": 458.0, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 458.0, "pure_state_mib": 233.4, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26180, "burst_events": 803062, "checkpoints": 39}} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-load.txt b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-load.txt new file mode 100644 index 0000000..18be78e --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-load.txt @@ -0,0 +1,12 @@ +1 before 17:28:01 up 1 day, 20:40, 3 users, load average: 1.22, 1.28, 1.47 +1 after 17:29:29 up 1 day, 20:41, 3 users, load average: 1.65, 1.44, 1.52 +2 after 17:31:00 up 1 day, 20:43, 3 users, load average: 3.61, 2.19, 1.78 +2 before 17:33:15 up 1 day, 20:45, 3 users, load average: 11.75, 5.91, 3.21 +3 before 17:35:20 up 1 day, 20:47, 3 users, load average: 5.84, 6.06, 3.64 +3 after 17:37:08 up 1 day, 20:49, 3 users, load average: 4.27, 5.38, 3.66 +4 after 17:38:53 up 1 day, 20:51, 3 users, load average: 4.34, 5.13, 3.76 +4 before 17:40:37 up 1 day, 20:53, 3 users, load average: 10.08, 6.81, 4.51 +5 before 17:42:16 up 1 day, 20:54, 3 users, load average: 11.89, 8.36, 5.29 +5 after 17:44:43 up 1 day, 20:57, 3 users, load average: 5.86, 8.35, 5.84 +6 after 17:46:14 up 1 day, 20:58, 3 users, load average: 3.61, 6.97, 5.58 +6 before 17:48:14 up 1 day, 21:00, 3 users, load average: 5.43, 6.50, 5.57 diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-1-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-1-linux-aarch64.jsonl new file mode 100644 index 0000000..21f445d --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-1-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.14, "pure_fastest_ms": 5.07, "sqlite_median_ms": 45.02, "sqlite_fastest_ms": 44.9, "sqlite_indexed_median_ms": 14.54, "sqlite_indexed_fastest_ms": 14.04} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 1.02, "pure_fastest_ms": 0.79, "sqlite_median_ms": 5.89, "sqlite_fastest_ms": 5.87, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.52, "pure_fastest_ms": 0.44, "sqlite_median_ms": 1.5, "sqlite_fastest_ms": 1.49, "sqlite_indexed_median_ms": 1.59, "sqlite_indexed_fastest_ms": 1.49} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.65, "pure_fastest_ms": 6.57, "sqlite_median_ms": 2850.79, "sqlite_fastest_ms": 2838.99, "sqlite_indexed_median_ms": 7.94, "sqlite_indexed_fastest_ms": 7.88} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-2-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-2-linux-aarch64.jsonl new file mode 100644 index 0000000..6ea83dd --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-2-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.32, "pure_fastest_ms": 5.17, "sqlite_median_ms": 45.2, "sqlite_fastest_ms": 44.93, "sqlite_indexed_median_ms": 14.16, "sqlite_indexed_fastest_ms": 14.05} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.86, "pure_fastest_ms": 0.81, "sqlite_median_ms": 5.98, "sqlite_fastest_ms": 5.93, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.47, "pure_fastest_ms": 0.38, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.5, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 7.24, "pure_fastest_ms": 6.91, "sqlite_median_ms": 2856.36, "sqlite_fastest_ms": 2838.18, "sqlite_indexed_median_ms": 7.61, "sqlite_indexed_fastest_ms": 7.52} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-3-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-3-linux-aarch64.jsonl new file mode 100644 index 0000000..f009b94 --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-3-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.77, "pure_fastest_ms": 5.49, "sqlite_median_ms": 46.27, "sqlite_fastest_ms": 45.63, "sqlite_indexed_median_ms": 14.36, "sqlite_indexed_fastest_ms": 14.28} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 1.06, "pure_fastest_ms": 0.86, "sqlite_median_ms": 6.08, "sqlite_fastest_ms": 6.03, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.49, "pure_fastest_ms": 0.47, "sqlite_median_ms": 1.73, "sqlite_fastest_ms": 1.63, "sqlite_indexed_median_ms": 1.51, "sqlite_indexed_fastest_ms": 1.49} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 7.93, "pure_fastest_ms": 7.88, "sqlite_median_ms": 2912.0, "sqlite_fastest_ms": 2863.43, "sqlite_indexed_median_ms": 7.69, "sqlite_indexed_fastest_ms": 7.56} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-4-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-4-linux-aarch64.jsonl new file mode 100644 index 0000000..13c382c --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-4-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.22, "pure_fastest_ms": 5.13, "sqlite_median_ms": 45.31, "sqlite_fastest_ms": 45.15, "sqlite_indexed_median_ms": 14.12, "sqlite_indexed_fastest_ms": 14.1} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.91, "pure_fastest_ms": 0.78, "sqlite_median_ms": 5.91, "sqlite_fastest_ms": 5.87, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.41, "pure_fastest_ms": 0.38, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.49, "sqlite_indexed_fastest_ms": 1.48} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.69, "pure_fastest_ms": 6.65, "sqlite_median_ms": 2881.62, "sqlite_fastest_ms": 2836.28, "sqlite_indexed_median_ms": 7.57, "sqlite_indexed_fastest_ms": 7.52} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-5-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-5-linux-aarch64.jsonl new file mode 100644 index 0000000..8177645 --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-5-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.34, "pure_fastest_ms": 5.13, "sqlite_median_ms": 45.81, "sqlite_fastest_ms": 45.33, "sqlite_indexed_median_ms": 14.21, "sqlite_indexed_fastest_ms": 14.12} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.95, "pure_fastest_ms": 0.92, "sqlite_median_ms": 6.18, "sqlite_fastest_ms": 6.05, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.44, "pure_fastest_ms": 0.41, "sqlite_median_ms": 1.57, "sqlite_fastest_ms": 1.51, "sqlite_indexed_median_ms": 1.59, "sqlite_indexed_fastest_ms": 1.5} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.99, "pure_fastest_ms": 6.74, "sqlite_median_ms": 2860.8, "sqlite_fastest_ms": 2841.58, "sqlite_indexed_median_ms": 7.94, "sqlite_indexed_fastest_ms": 7.78} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-6-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-6-linux-aarch64.jsonl new file mode 100644 index 0000000..6e3234c --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-after-6-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.17, "pure_fastest_ms": 5.12, "sqlite_median_ms": 45.17, "sqlite_fastest_ms": 44.91, "sqlite_indexed_median_ms": 14.06, "sqlite_indexed_fastest_ms": 14.02} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.82, "pure_fastest_ms": 0.78, "sqlite_median_ms": 6.01, "sqlite_fastest_ms": 5.93, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.4, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.5, "sqlite_fastest_ms": 1.48, "sqlite_indexed_median_ms": 1.49, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.7, "pure_fastest_ms": 6.63, "sqlite_median_ms": 2858.9, "sqlite_fastest_ms": 2838.92, "sqlite_indexed_median_ms": 7.6, "sqlite_indexed_fastest_ms": 7.53} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-1-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-1-linux-aarch64.jsonl new file mode 100644 index 0000000..7b5acdf --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-1-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.39, "pure_fastest_ms": 5.25, "sqlite_median_ms": 45.61, "sqlite_fastest_ms": 45.42, "sqlite_indexed_median_ms": 14.21, "sqlite_indexed_fastest_ms": 14.09} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.84, "pure_fastest_ms": 0.81, "sqlite_median_ms": 5.91, "sqlite_fastest_ms": 5.88, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.39, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.47} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.79, "pure_fastest_ms": 6.7, "sqlite_median_ms": 2850.71, "sqlite_fastest_ms": 2844.46, "sqlite_indexed_median_ms": 7.66, "sqlite_indexed_fastest_ms": 7.56} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-2-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-2-linux-aarch64.jsonl new file mode 100644 index 0000000..0fbf875 --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-2-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.63, "pure_fastest_ms": 5.41, "sqlite_median_ms": 46.0, "sqlite_fastest_ms": 44.93, "sqlite_indexed_median_ms": 14.14, "sqlite_indexed_fastest_ms": 14.05} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 1.15, "pure_fastest_ms": 0.91, "sqlite_median_ms": 6.31, "sqlite_fastest_ms": 6.16, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.64, "pure_fastest_ms": 0.59, "sqlite_median_ms": 1.68, "sqlite_fastest_ms": 1.63, "sqlite_indexed_median_ms": 1.5, "sqlite_indexed_fastest_ms": 1.49} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 8.22, "pure_fastest_ms": 7.72, "sqlite_median_ms": 2873.66, "sqlite_fastest_ms": 2840.34, "sqlite_indexed_median_ms": 7.62, "sqlite_indexed_fastest_ms": 7.53} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-3-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-3-linux-aarch64.jsonl new file mode 100644 index 0000000..d5e1a37 --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-3-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.3, "pure_fastest_ms": 5.17, "sqlite_median_ms": 45.31, "sqlite_fastest_ms": 45.13, "sqlite_indexed_median_ms": 14.12, "sqlite_indexed_fastest_ms": 14.09} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.86, "pure_fastest_ms": 0.82, "sqlite_median_ms": 5.91, "sqlite_fastest_ms": 5.86, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.38, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.5, "sqlite_indexed_fastest_ms": 1.49} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.63, "pure_fastest_ms": 6.56, "sqlite_median_ms": 2858.86, "sqlite_fastest_ms": 2842.01, "sqlite_indexed_median_ms": 7.85, "sqlite_indexed_fastest_ms": 7.71} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-4-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-4-linux-aarch64.jsonl new file mode 100644 index 0000000..228261c --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-4-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.37, "pure_fastest_ms": 5.24, "sqlite_median_ms": 45.51, "sqlite_fastest_ms": 45.01, "sqlite_indexed_median_ms": 14.16, "sqlite_indexed_fastest_ms": 14.11} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.92, "pure_fastest_ms": 0.86, "sqlite_median_ms": 5.92, "sqlite_fastest_ms": 5.91, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.43, "pure_fastest_ms": 0.38, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.48, "sqlite_indexed_median_ms": 1.64, "sqlite_indexed_fastest_ms": 1.61} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.73, "pure_fastest_ms": 6.67, "sqlite_median_ms": 2883.43, "sqlite_fastest_ms": 2847.44, "sqlite_indexed_median_ms": 7.88, "sqlite_indexed_fastest_ms": 7.77} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-5-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-5-linux-aarch64.jsonl new file mode 100644 index 0000000..adac6d4 --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-5-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.4, "pure_fastest_ms": 5.3, "sqlite_median_ms": 45.52, "sqlite_fastest_ms": 45.3, "sqlite_indexed_median_ms": 14.09, "sqlite_indexed_fastest_ms": 14.05} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.92, "pure_fastest_ms": 0.86, "sqlite_median_ms": 5.94, "sqlite_fastest_ms": 5.88, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.39, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.5, "sqlite_indexed_fastest_ms": 1.49} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.75, "pure_fastest_ms": 6.71, "sqlite_median_ms": 2877.23, "sqlite_fastest_ms": 2841.11, "sqlite_indexed_median_ms": 7.84, "sqlite_indexed_fastest_ms": 7.57} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-6-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-6-linux-aarch64.jsonl new file mode 100644 index 0000000..0bfcc62 --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-queries-before-6-linux-aarch64.jsonl @@ -0,0 +1,4 @@ +{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.31, "pure_fastest_ms": 5.18, "sqlite_median_ms": 45.42, "sqlite_fastest_ms": 45.12, "sqlite_indexed_median_ms": 14.35, "sqlite_indexed_fastest_ms": 14.23} +{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.91, "pure_fastest_ms": 0.84, "sqlite_median_ms": 5.91, "sqlite_fastest_ms": 5.87, "sqlite_indexed_median_ms": 0.16, "sqlite_indexed_fastest_ms": 0.16} +{"query": "large", "rows": 212, "accounts": 100000, "pure_median_ms": 0.48, "pure_fastest_ms": 0.41, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.93, "sqlite_indexed_fastest_ms": 1.65} +{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 7.85, "pure_fastest_ms": 6.64, "sqlite_median_ms": 2842.07, "sqlite_fastest_ms": 2836.26, "sqlite_indexed_median_ms": 7.83, "sqlite_indexed_fastest_ms": 7.7} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-1-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-1-linux-aarch64.jsonl new file mode 100644 index 0000000..46623e4 --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-1-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.57, "pure_load_s": 0.75, "sqlite_load_s": 1.65, "sqlite_page_size": 4096, "pure_resident_mib": 38.9, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 37837, "new_orders_per_minute": 1012069, "undone_new_orders": 3237, "errors": 0, "new_order": {"done": 340594, "failed": 0, "p50_us": 1536, "p99_us": 5376}, "payment": {"done": 325321, "failed": 0, "p50_us": 1536, "p99_us": 5120}, "order_status": {"done": 30380, "failed": 0, "p50_us": 272, "p99_us": 2432}, "delivery": {"done": 30342, "failed": 0, "p50_us": 1536, "p99_us": 5120}, "stock_level": {"done": 30112, "failed": 0, "p50_us": 320, "p99_us": 2816}, "server_threads": "3", "cpu_us_per_transaction": 46.5, "core_shares": {"pure-owner": 0.83, "pure-checkpoint": 0.01}, "resident_mib": 405.1, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 405.1, "pure_state_mib": 204.5, "pure_store_mib": 206.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 23913, "burst_events": 693102, "checkpoints": 33}} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-2-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-2-linux-aarch64.jsonl new file mode 100644 index 0000000..18ee306 --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-2-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.67, "pure_load_s": 0.74, "sqlite_load_s": 1.66, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 36146, "new_orders_per_minute": 966609, "undone_new_orders": 3096, "errors": 0, "new_order": {"done": 325300, "failed": 0, "p50_us": 1664, "p99_us": 5632}, "payment": {"done": 310838, "failed": 0, "p50_us": 1600, "p99_us": 5632}, "order_status": {"done": 29022, "failed": 0, "p50_us": 304, "p99_us": 2816}, "delivery": {"done": 28989, "failed": 0, "p50_us": 1600, "p99_us": 5632}, "stock_level": {"done": 28776, "failed": 0, "p50_us": 352, "p99_us": 2944}, "server_threads": "3", "cpu_us_per_transaction": 49.3, "core_shares": {"pure-owner": 0.84, "pure-checkpoint": 0.01}, "resident_mib": 387.1, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 387.1, "pure_state_mib": 196.3, "pure_store_mib": 198.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 23500, "burst_events": 662117, "checkpoints": 32}} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-3-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-3-linux-aarch64.jsonl new file mode 100644 index 0000000..13890e1 --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-3-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.57, "pure_load_s": 0.73, "sqlite_load_s": 1.6, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 34588, "new_orders_per_minute": 924640, "undone_new_orders": 2956, "errors": 0, "new_order": {"done": 311171, "failed": 0, "p50_us": 1600, "p99_us": 5888}, "payment": {"done": 297582, "failed": 0, "p50_us": 1600, "p99_us": 5888}, "order_status": {"done": 27786, "failed": 0, "p50_us": 288, "p99_us": 3072}, "delivery": {"done": 27748, "failed": 0, "p50_us": 1600, "p99_us": 5888}, "stock_level": {"done": 27470, "failed": 0, "p50_us": 336, "p99_us": 3200}, "server_threads": "3", "cpu_us_per_transaction": 47.3, "core_shares": {"pure-owner": 0.78, "pure-checkpoint": 0.01}, "resident_mib": 375.0, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 375.0, "pure_state_mib": 188.7, "pure_store_mib": 190.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 22257, "burst_events": 633630, "checkpoints": 31}} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-4-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-4-linux-aarch64.jsonl new file mode 100644 index 0000000..261b9db --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-4-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.72, "sqlite_load_s": 1.58, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 28157, "new_orders_per_minute": 751842, "undone_new_orders": 2367, "errors": 0, "new_order": {"done": 252995, "failed": 0, "p50_us": 1728, "p99_us": 8192}, "payment": {"done": 242605, "failed": 0, "p50_us": 1728, "p99_us": 8192}, "order_status": {"done": 22728, "failed": 0, "p50_us": 336, "p99_us": 4352}, "delivery": {"done": 22547, "failed": 0, "p50_us": 1728, "p99_us": 8192}, "stock_level": {"done": 22305, "failed": 0, "p50_us": 384, "p99_us": 4352}, "server_threads": "3", "cpu_us_per_transaction": 50.1, "core_shares": {"pure-owner": 0.67, "pure-checkpoint": 0.0}, "resident_mib": 313.5, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 313.5, "pure_state_mib": 157.7, "pure_store_mib": 158.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 17919, "burst_events": 515863, "checkpoints": 24}} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-5-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-5-linux-aarch64.jsonl new file mode 100644 index 0000000..37154f5 --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-5-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.71, "sqlite_load_s": 1.58, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43823, "new_orders_per_minute": 1172693, "undone_new_orders": 3757, "errors": 0, "new_order": {"done": 394664, "failed": 0, "p50_us": 1472, "p99_us": 3840}, "payment": {"done": 376673, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "order_status": {"done": 35130, "failed": 0, "p50_us": 256, "p99_us": 1472}, "delivery": {"done": 35099, "failed": 0, "p50_us": 1408, "p99_us": 3840}, "stock_level": {"done": 34917, "failed": 0, "p50_us": 288, "p99_us": 1664}, "server_threads": "3", "cpu_us_per_transaction": 42.9, "core_shares": {"pure-owner": 0.89, "pure-checkpoint": 0.01}, "resident_mib": 459.0, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 459.1, "pure_state_mib": 233.4, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26806, "burst_events": 802763, "checkpoints": 39}} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-6-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-6-linux-aarch64.jsonl new file mode 100644 index 0000000..8c556d4 --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-after-6-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.57, "pure_load_s": 0.73, "sqlite_load_s": 1.59, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 41686, "new_orders_per_minute": 1115636, "undone_new_orders": 3564, "errors": 0, "new_order": {"done": 375443, "failed": 0, "p50_us": 1472, "p99_us": 4096}, "payment": {"done": 358220, "failed": 0, "p50_us": 1472, "p99_us": 4096}, "order_status": {"done": 33501, "failed": 0, "p50_us": 256, "p99_us": 1728}, "delivery": {"done": 33370, "failed": 0, "p50_us": 1472, "p99_us": 4096}, "stock_level": {"done": 33182, "failed": 0, "p50_us": 288, "p99_us": 1792}, "server_threads": "3", "cpu_us_per_transaction": 43.7, "core_shares": {"pure-owner": 0.87, "pure-checkpoint": 0.01}, "resident_mib": 439.4, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 439.4, "pure_state_mib": 223.1, "pure_store_mib": 230.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 25909, "burst_events": 763549, "checkpoints": 37}} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-1-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-1-linux-aarch64.jsonl new file mode 100644 index 0000000..6024920 --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-1-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.58, "pure_load_s": 0.71, "sqlite_load_s": 1.58, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 40700, "new_orders_per_minute": 1088938, "undone_new_orders": 3487, "errors": 0, "new_order": {"done": 366467, "failed": 0, "p50_us": 1536, "p99_us": 4352}, "payment": {"done": 349811, "failed": 0, "p50_us": 1472, "p99_us": 4352}, "order_status": {"done": 32722, "failed": 0, "p50_us": 272, "p99_us": 1664}, "delivery": {"done": 32601, "failed": 0, "p50_us": 1472, "p99_us": 4352}, "stock_level": {"done": 32399, "failed": 0, "p50_us": 304, "p99_us": 1728}, "server_threads": "3", "cpu_us_per_transaction": 45.6, "core_shares": {"pure-owner": 0.86, "pure-checkpoint": 0.01}, "resident_mib": 430.4, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 430.4, "pure_state_mib": 218.3, "pure_store_mib": 222.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 25167, "burst_events": 745472, "checkpoints": 37}} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-2-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-2-linux-aarch64.jsonl new file mode 100644 index 0000000..51e2915 --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-2-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.59, "pure_load_s": 0.78, "sqlite_load_s": 1.71, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 39649, "new_orders_per_minute": 1060828, "undone_new_orders": 3395, "errors": 0, "new_order": {"done": 357005, "failed": 0, "p50_us": 1536, "p99_us": 4352}, "payment": {"done": 340774, "failed": 0, "p50_us": 1536, "p99_us": 4352}, "order_status": {"done": 31844, "failed": 0, "p50_us": 272, "p99_us": 2176}, "delivery": {"done": 31796, "failed": 0, "p50_us": 1536, "p99_us": 4352}, "stock_level": {"done": 31554, "failed": 0, "p50_us": 320, "p99_us": 2304}, "server_threads": "3", "cpu_us_per_transaction": 45.5, "core_shares": {"pure-owner": 0.86, "pure-checkpoint": 0.01}, "resident_mib": 421.2, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 421.2, "pure_state_mib": 213.3, "pure_store_mib": 222.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 25650, "burst_events": 726265, "checkpoints": 35}} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-3-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-3-linux-aarch64.jsonl new file mode 100644 index 0000000..b2565fd --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-3-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.57, "pure_load_s": 0.71, "sqlite_load_s": 1.64, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 42428, "new_orders_per_minute": 1135298, "undone_new_orders": 3614, "errors": 0, "new_order": {"done": 382047, "failed": 0, "p50_us": 1472, "p99_us": 4096}, "payment": {"done": 364676, "failed": 0, "p50_us": 1408, "p99_us": 4096}, "order_status": {"done": 34066, "failed": 0, "p50_us": 256, "p99_us": 1728}, "delivery": {"done": 33979, "failed": 0, "p50_us": 1472, "p99_us": 4096}, "stock_level": {"done": 33800, "failed": 0, "p50_us": 288, "p99_us": 1984}, "server_threads": "3", "cpu_us_per_transaction": 44.0, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 447.0, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 447.0, "pure_state_mib": 226.7, "pure_store_mib": 230.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26642, "burst_events": 777167, "checkpoints": 38}} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-4-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-4-linux-aarch64.jsonl new file mode 100644 index 0000000..d5977ae --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-4-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.58, "pure_load_s": 0.74, "sqlite_load_s": 1.57, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 39841, "new_orders_per_minute": 1066005, "undone_new_orders": 3417, "errors": 0, "new_order": {"done": 358754, "failed": 0, "p50_us": 1536, "p99_us": 4096}, "payment": {"done": 342430, "failed": 0, "p50_us": 1472, "p99_us": 4096}, "order_status": {"done": 32010, "failed": 0, "p50_us": 272, "p99_us": 2048}, "delivery": {"done": 31934, "failed": 0, "p50_us": 1472, "p99_us": 4096}, "stock_level": {"done": 31688, "failed": 0, "p50_us": 304, "p99_us": 2176}, "server_threads": "3", "cpu_us_per_transaction": 45.3, "core_shares": {"pure-owner": 0.83, "pure-checkpoint": 0.01}, "resident_mib": 423.8, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 423.8, "pure_state_mib": 214.2, "pure_store_mib": 222.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 25506, "burst_events": 729779, "checkpoints": 36}} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-5-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-5-linux-aarch64.jsonl new file mode 100644 index 0000000..1e30077 --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-5-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.59, "pure_load_s": 0.7, "sqlite_load_s": 1.57, "sqlite_page_size": 4096, "pure_resident_mib": 38.9, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 24333, "new_orders_per_minute": 649704, "undone_new_orders": 2056, "errors": 0, "new_order": {"done": 218624, "failed": 0, "p50_us": 2432, "p99_us": 7680}, "payment": {"done": 209566, "failed": 0, "p50_us": 2304, "p99_us": 7680}, "order_status": {"done": 19728, "failed": 0, "p50_us": 400, "p99_us": 4352}, "delivery": {"done": 19451, "failed": 0, "p50_us": 2432, "p99_us": 7424}, "stock_level": {"done": 19288, "failed": 0, "p50_us": 448, "p99_us": 4608}, "server_threads": "3", "cpu_us_per_transaction": 47.4, "core_shares": {"pure-owner": 0.55, "pure-checkpoint": 0.0}, "resident_mib": 280.8, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 280.8, "pure_state_mib": 139.3, "pure_store_mib": 142.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 13031, "burst_events": 445668, "checkpoints": 22}} diff --git a/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-6-linux-aarch64.jsonl b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-6-linux-aarch64.jsonl new file mode 100644 index 0000000..e87e036 --- /dev/null +++ b/research/experiments/025-i64-cost/fcc1f67-interfered/2026-09-30-tpcc-before-6-linux-aarch64.jsonl @@ -0,0 +1,3 @@ +{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 0.76, "sqlite_load_s": 1.6, "sqlite_page_size": 4096, "pure_resident_mib": 38.2, "sqlite_file_mib": 13.8} +{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 37869, "new_orders_per_minute": 1012778, "undone_new_orders": 3256, "errors": 0, "new_order": {"done": 340877, "failed": 0, "p50_us": 1536, "p99_us": 5120}, "payment": {"done": 325683, "failed": 0, "p50_us": 1536, "p99_us": 4864}, "order_status": {"done": 30408, "failed": 0, "p50_us": 288, "p99_us": 2688}, "delivery": {"done": 30373, "failed": 0, "p50_us": 1536, "p99_us": 4864}, "stock_level": {"done": 30100, "failed": 0, "p50_us": 336, "p99_us": 2816}, "server_threads": "3", "cpu_us_per_transaction": 46.2, "core_shares": {"pure-owner": 0.84, "pure-checkpoint": 0.01}, "resident_mib": 405.1, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []} +{"step": "end", "pure_resident_mib": 405.1, "pure_state_mib": 204.6, "pure_store_mib": 206.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 24735, "burst_events": 693700, "checkpoints": 33}} diff --git a/research/experiments/025-i64-cost/pcount.c b/research/experiments/025-i64-cost/pcount.c new file mode 100644 index 0000000..77519b2 --- /dev/null +++ b/research/experiments/025-i64-cost/pcount.c @@ -0,0 +1,58 @@ +/* pcount PID: count user-mode instructions and cycles of every thread of + * PID from "ready" (on stderr) until stdin closes; prints them as JSON. + * perf_event_open alone: a perf_event_paranoid of 2 allows it for one's own + * processes, and no perf tool is needed. */ +#define _GNU_SOURCE +#include <dirent.h> +#include <linux/perf_event.h> +#include <stdint.h> +#include <stdio.h> +#include <stdlib.h> +#include <string.h> +#include <sys/ioctl.h> +#include <sys/syscall.h> +#include <unistd.h> + +static int open_counter(pid_t tid, uint64_t config) { + struct perf_event_attr attr; + memset(&attr, 0, sizeof(attr)); + attr.size = sizeof(attr); + attr.type = PERF_TYPE_HARDWARE; + attr.config = config; + attr.disabled = 1; + attr.exclude_kernel = 1; + attr.exclude_hv = 1; + return (int)syscall(SYS_perf_event_open, &attr, tid, -1, -1, 0); +} + +int main(int argc, char **argv) { + if (argc != 2) return 2; + char path[64]; + snprintf(path, sizeof(path), "/proc/%s/task", argv[1]); + DIR *dir = opendir(path); + if (!dir) { perror("opendir"); return 1; } + int fds[512][2], n = 0; + struct dirent *e; + while ((e = readdir(dir)) && n < 512) { + if (e->d_name[0] == '.') continue; + pid_t tid = atoi(e->d_name); + fds[n][0] = open_counter(tid, PERF_COUNT_HW_INSTRUCTIONS); + fds[n][1] = open_counter(tid, PERF_COUNT_HW_CPU_CYCLES); + if (fds[n][0] < 0 || fds[n][1] < 0) { perror("perf_event_open"); return 1; } + ++n; + } + closedir(dir); + for (int i = 0; i < n; ++i) for (int k = 0; k < 2; ++k) ioctl(fds[i][k], PERF_EVENT_IOC_RESET, 0), ioctl(fds[i][k], PERF_EVENT_IOC_ENABLE, 0); + fprintf(stderr, "ready\n"); + char buffer[64]; + while (fread(buffer, 1, sizeof(buffer), stdin) > 0) {} + uint64_t total[2] = {0, 0}; + for (int i = 0; i < n; ++i) + for (int k = 0; k < 2; ++k) { + uint64_t v = 0; + ioctl(fds[i][k], PERF_EVENT_IOC_DISABLE, 0); + if (read(fds[i][k], &v, sizeof(v)) == sizeof(v)) total[k] += v; + } + printf("{\"threads\": %d, \"instructions\": %llu, \"cycles\": %llu}\n", n, (unsigned long long)total[0], (unsigned long long)total[1]); + return 0; +} diff --git a/research/experiments/025-i64-cost/psample.c b/research/experiments/025-i64-cost/psample.c new file mode 100644 index 0000000..308e8ff --- /dev/null +++ b/research/experiments/025-i64-cost/psample.c @@ -0,0 +1,94 @@ +/* psample PID PERIOD: sample the user-mode instruction pointer of every + * thread of PID once per PERIOD instructions, from "ready" (on stderr) until + * stdin closes; prints one hex address per sample, then "lost N". Like + * pcount, perf_event_open alone (the threads PID has when it starts). */ +#define _GNU_SOURCE +#include <dirent.h> +#include <linux/perf_event.h> +#include <poll.h> +#include <stdint.h> +#include <stdio.h> +#include <stdlib.h> +#include <string.h> +#include <sys/ioctl.h> +#include <sys/mman.h> +#include <sys/syscall.h> +#include <unistd.h> + +enum { PAGES = 64, MAX_THREADS = 256 }; +static size_t page; +static uint64_t lost; + +typedef struct { int fd; struct perf_event_mmap_page *meta; unsigned char *data; } Ring; + +static void drain(Ring *r, FILE *out) { + uint64_t head = __atomic_load_n(&r->meta->data_head, __ATOMIC_ACQUIRE), tail = r->meta->data_tail; + size_t size = PAGES * page; + while (tail < head) { + struct perf_event_header h; + unsigned char record[256]; + for (size_t i = 0; i < sizeof(h); ++i) ((unsigned char *)&h)[i] = r->data[(tail + i) % size]; + if (h.size > sizeof(record) || h.size < sizeof(h)) break; + for (size_t i = 0; i < h.size; ++i) record[i] = r->data[(tail + i) % size]; + if (h.type == PERF_RECORD_SAMPLE) { + uint64_t ip; + memcpy(&ip, record + sizeof(h), sizeof(ip)); + fprintf(out, "%llx\n", (unsigned long long)ip); + } else if (h.type == PERF_RECORD_LOST) { + uint64_t n; + memcpy(&n, record + sizeof(h) + 8, sizeof(n)); + lost += n; + } + tail += h.size; + } + __atomic_store_n(&r->meta->data_tail, tail, __ATOMIC_RELEASE); +} + +int main(int argc, char **argv) { + if (argc != 3) return 2; + page = (size_t)sysconf(_SC_PAGESIZE); + char path[64]; + snprintf(path, sizeof(path), "/proc/%s/task", argv[1]); + DIR *dir = opendir(path); + if (!dir) { perror("opendir"); return 1; } + Ring rings[MAX_THREADS]; + int n = 0; + struct dirent *e; + while ((e = readdir(dir)) && n < MAX_THREADS) { + if (e->d_name[0] == '.') continue; + struct perf_event_attr attr; + memset(&attr, 0, sizeof(attr)); + attr.size = sizeof(attr); + attr.type = PERF_TYPE_HARDWARE; + attr.config = PERF_COUNT_HW_INSTRUCTIONS; + attr.sample_period = strtoull(argv[2], NULL, 10); + attr.sample_type = PERF_SAMPLE_IP; + attr.disabled = 1; + attr.exclude_kernel = 1; + attr.exclude_hv = 1; + attr.wakeup_events = 1; + int fd = (int)syscall(SYS_perf_event_open, &attr, atoi(e->d_name), -1, -1, 0); + if (fd < 0) { perror("perf_event_open"); return 1; } + void *map = mmap(NULL, (PAGES + 1) * page, PROT_READ | PROT_WRITE, MAP_SHARED, fd, 0); + if (map == MAP_FAILED) { perror("mmap"); return 1; } + rings[n++] = (Ring){fd, map, (unsigned char *)map + page}; + } + closedir(dir); + FILE *out = stdout; + for (int i = 0; i < n; ++i) ioctl(rings[i].fd, PERF_EVENT_IOC_ENABLE, 0); + fprintf(stderr, "ready\n"); + struct pollfd fds[MAX_THREADS + 1]; + for (;;) { + fds[0] = (struct pollfd){.fd = 0, .events = POLLIN}; + for (int i = 0; i < n; ++i) fds[i + 1] = (struct pollfd){.fd = rings[i].fd, .events = POLLIN}; + poll(fds, (nfds_t)n + 1, 100); + for (int i = 0; i < n; ++i) drain(&rings[i], out); + if (fds[0].revents) { + char buffer[64]; + if (read(0, buffer, sizeof(buffer)) <= 0) break; + } + } + for (int i = 0; i < n; ++i) ioctl(rings[i].fd, PERF_EVENT_IOC_DISABLE, 0), drain(&rings[i], out); + fprintf(out, "lost %llu\n", (unsigned long long)lost); + return 0; +} diff --git a/research/experiments/025-i64-cost/runs.sh b/research/experiments/025-i64-cost/runs.sh new file mode 100755 index 0000000..328e11f --- /dev/null +++ b/research/experiments/025-i64-cost/runs.sh @@ -0,0 +1,29 @@ +#!/bin/sh +# The runs of docs/design/016's second stage, from the repository's root: +# pure-serve before i64 (9a03e72, built in a scratch worktree) and after (the +# tree as it is), in turns: TPC-C in RAM (W=1, 64 terminals), then the bank's +# queries, six rounds, the order flipped every other round. The modules are +# the same bytes on both sides (aup before and after i64 builds tpcc.aup, +# bank.aup and the four queries alike), so only the runtime differs. The +# results go to a directory named for the after commit: runs.sh fc65d66. +set -e +out=research/experiments/025-i64-cost/$1 +mkdir -p $out +work=$(mktemp -d) +git worktree add -q --detach $work/tree 9a03e72 +make -C $work/tree -s build/pure-serve +cp $work/tree/build/pure-serve $work/pure-serve-before +git worktree remove --force $work/tree +make -s build/pure-serve +cp build/pure-serve $work/pure-serve-after +for round in 1 2 3 4 5 6; do + first=before second=after + if [ $((round % 2)) = 0 ]; then first=after second=before; fi + for version in $first $second; do + echo "$round $version $(uptime)" >> $out/2026-09-30-load.txt + python3 benchmarks/tpcc/run.py --serve $work/pure-serve-$version --warehouses 1 --check 0 --terminals 64 \ + --sqlite-threads '' --sqlite-group '' --seconds 20 > $out/2026-09-30-tpcc-$version-$round-linux-aarch64.jsonl + python3 benchmarks/bank/queries.py --serve $work/pure-serve-$version \ + > $out/2026-09-30-queries-$version-$round-linux-aarch64.jsonl + done +done |