aboutsummaryrefslogtreecommitdiffstats
path: root/research/experiments/026-apps-on-one-host/41502b9
diff options
context:
space:
mode:
authoreunhhu <[email protected]>2026-10-01 06:25:21 +0100
committereunhhu <[email protected]>2026-10-01 06:25:21 +0100
commitddcc1202daa7de84f13ff712fdb5ad12159facc1 (patch)
tree47deddd3c047df16c3c94d8a2ea9f4724a852083 /research/experiments/026-apps-on-one-host/41502b9
parentbe297ead16b41938e84bcc3f1be628bc8725f2f4 (diff)
downloadpure-ddcc1202daa7de84f13ff712fdb5ad12159facc1.tar.gz
pure-ddcc1202daa7de84f13ff712fdb5ad12159facc1.zip
Measure one host of many apps against a process each (111)
017's first stage met its four criteria on the Pi (RAM stores, five rounds, the order of the ways turned): app B's 99th percentile while app A is flooded by 64 connections is 168 us, half of two processes' 336 us; the two apps busy together write 146.1k a second against 146.2k, with the same 1.4 ms tail; an app costs a host 120 KiB of its own memory (a process: 1,311 KiB PSS) and 100 apps still run on three threads; a host of one app keeps its speed (TPC-C +1.2% at the median of six pairs, two of them interfered and kept; the bank's queries within 2.6%) and its instructions (+0.94% at most). On the way: apps hopped between workers each turn (fixed in db4ee9c), connections of one app spread over all connection threads made the host a third more expensive a request and its tail a kernel tick (fixed by home threads, d24881d), and the work budget's counting cost every table row 26 instructions (fixed in be297ea). The earlier runs are kept apart (db4ee9c's isolation, d24881d's pairs and counts, the interrupted first try).
Diffstat (limited to 'research/experiments/026-apps-on-one-host/41502b9')
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-counts-linux-aarch64.jsonl4
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-after-1-linux-aarch64.jsonl4
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-after-2-linux-aarch64.jsonl4
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-after-3-linux-aarch64.jsonl4
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-after-4-linux-aarch64.jsonl4
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-before-1-linux-aarch64.jsonl4
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-before-2-linux-aarch64.jsonl4
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-before-3-linux-aarch64.jsonl4
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-before-4-linux-aarch64.jsonl4
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-after-1-linux-aarch64.jsonl3
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-after-2-linux-aarch64.jsonl3
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-after-3-linux-aarch64.jsonl3
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-after-4-linux-aarch64.jsonl3
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-before-1-linux-aarch64.jsonl3
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-before-2-linux-aarch64.jsonl3
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-before-3-linux-aarch64.jsonl3
-rw-r--r--research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-before-4-linux-aarch64.jsonl3
17 files changed, 60 insertions, 0 deletions
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-counts-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-counts-linux-aarch64.jsonl
new file mode 100644
index 0000000..f7bf178
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-counts-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"serve": "pure-serve-before", "per_branch": {"instructions": 27109423, "cycles": 12757041}, "in_credit": {"instructions": 3499810, "cycles": 2146697}, "large": {"instructions": 1438407, "cycles": 850712}, "ranks": {"instructions": 24227804, "cycles": 15945967}, "none": {"instructions": 606073, "cycles": 194426}, "field": {"instructions": 8694610, "cycles": 3145065}, "found": {"instructions": 15638649, "cycles": 13033209}}
+{"serve": "pure-serve-after", "per_branch": {"instructions": 26996283, "cycles": 13168408}, "in_credit": {"instructions": 3477936, "cycles": 1655777}, "large": {"instructions": 1459696, "cycles": 651809}, "ranks": {"instructions": 24206932, "cycles": 14923305}, "none": {"instructions": 606880, "cycles": 187469}, "field": {"instructions": 8957359, "cycles": 3247129}, "found": {"instructions": 15861958, "cycles": 12598700}}
+{"serve": "pure-serve-before", "per_branch": {"instructions": 27095339, "cycles": 14076035}, "in_credit": {"instructions": 3496516, "cycles": 2165470}, "large": {"instructions": 1438463, "cycles": 743626}, "ranks": {"instructions": 24218824, "cycles": 15054854}, "none": {"instructions": 606073, "cycles": 189148}, "field": {"instructions": 8694610, "cycles": 3118100}, "found": {"instructions": 15639737, "cycles": 12589382}}
+{"serve": "pure-serve-after", "per_branch": {"instructions": 27007923, "cycles": 12183472}, "in_credit": {"instructions": 3480622, "cycles": 1618130}, "large": {"instructions": 1459624, "cycles": 664277}, "ranks": {"instructions": 24213384, "cycles": 14884807}, "none": {"instructions": 606880, "cycles": 191854}, "field": {"instructions": 8957359, "cycles": 3276233}, "found": {"instructions": 15861974, "cycles": 14008038}}
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-after-1-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-after-1-linux-aarch64.jsonl
new file mode 100644
index 0000000..1a805d7
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-after-1-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.2, "pure_fastest_ms": 5.14, "sqlite_median_ms": 45.15, "sqlite_fastest_ms": 45.07, "sqlite_indexed_median_ms": 14.13, "sqlite_indexed_fastest_ms": 14.09}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.84, "pure_fastest_ms": 0.79, "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.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.65, "pure_fastest_ms": 6.58, "sqlite_median_ms": 2831.82, "sqlite_fastest_ms": 2829.74, "sqlite_indexed_median_ms": 7.56, "sqlite_indexed_fastest_ms": 7.5}
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-after-2-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-after-2-linux-aarch64.jsonl
new file mode 100644
index 0000000..cfd7cc0
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-after-2-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.29, "pure_fastest_ms": 5.22, "sqlite_median_ms": 45.0, "sqlite_fastest_ms": 44.91, "sqlite_indexed_median_ms": 13.98, "sqlite_indexed_fastest_ms": 13.97}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.83, "pure_fastest_ms": 0.79, "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.39, "pure_fastest_ms": 0.36, "sqlite_median_ms": 1.49, "sqlite_fastest_ms": 1.48, "sqlite_indexed_median_ms": 1.49, "sqlite_indexed_fastest_ms": 1.48}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.73, "pure_fastest_ms": 6.63, "sqlite_median_ms": 2842.66, "sqlite_fastest_ms": 2830.25, "sqlite_indexed_median_ms": 7.62, "sqlite_indexed_fastest_ms": 7.53}
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-after-3-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-after-3-linux-aarch64.jsonl
new file mode 100644
index 0000000..de1abb1
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-after-3-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.06, "sqlite_fastest_ms": 44.85, "sqlite_indexed_median_ms": 14.16, "sqlite_indexed_fastest_ms": 14.07}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.87, "pure_fastest_ms": 0.81, "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.37, "sqlite_median_ms": 1.47, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.63, "sqlite_indexed_fastest_ms": 1.6}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.73, "pure_fastest_ms": 6.62, "sqlite_median_ms": 2836.71, "sqlite_fastest_ms": 2832.09, "sqlite_indexed_median_ms": 7.83, "sqlite_indexed_fastest_ms": 7.75}
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-after-4-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-after-4-linux-aarch64.jsonl
new file mode 100644
index 0000000..040db79
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-after-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.35, "sqlite_fastest_ms": 45.24, "sqlite_indexed_median_ms": 14.1, "sqlite_indexed_fastest_ms": 14.07}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.89, "pure_fastest_ms": 0.79, "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.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": 7.69, "pure_fastest_ms": 6.95, "sqlite_median_ms": 2837.18, "sqlite_fastest_ms": 2833.15, "sqlite_indexed_median_ms": 7.57, "sqlite_indexed_fastest_ms": 7.5}
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-before-1-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-before-1-linux-aarch64.jsonl
new file mode 100644
index 0000000..8056b77
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-before-1-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.14, "pure_fastest_ms": 5.04, "sqlite_median_ms": 45.25, "sqlite_fastest_ms": 45.12, "sqlite_indexed_median_ms": 14.11, "sqlite_indexed_fastest_ms": 14.07}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.79, "pure_fastest_ms": 0.76, "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.48, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.64, "pure_fastest_ms": 6.53, "sqlite_median_ms": 2832.44, "sqlite_fastest_ms": 2830.87, "sqlite_indexed_median_ms": 7.57, "sqlite_indexed_fastest_ms": 7.49}
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-before-2-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-before-2-linux-aarch64.jsonl
new file mode 100644
index 0000000..684f23f
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-before-2-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.12, "pure_fastest_ms": 5.08, "sqlite_median_ms": 45.31, "sqlite_fastest_ms": 45.21, "sqlite_indexed_median_ms": 14.08, "sqlite_indexed_fastest_ms": 14.05}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.8, "pure_fastest_ms": 0.77, "sqlite_median_ms": 5.86, "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.39, "pure_fastest_ms": 0.36, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.48, "sqlite_indexed_fastest_ms": 1.46}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.62, "pure_fastest_ms": 6.57, "sqlite_median_ms": 2831.21, "sqlite_fastest_ms": 2828.9, "sqlite_indexed_median_ms": 7.59, "sqlite_indexed_fastest_ms": 7.53}
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-before-3-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-before-3-linux-aarch64.jsonl
new file mode 100644
index 0000000..d9a4f14
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-before-3-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.01, "pure_fastest_ms": 4.91, "sqlite_median_ms": 45.4, "sqlite_fastest_ms": 45.19, "sqlite_indexed_median_ms": 14.18, "sqlite_indexed_fastest_ms": 14.1}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.81, "pure_fastest_ms": 0.78, "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.48, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.65, "pure_fastest_ms": 6.6, "sqlite_median_ms": 2834.53, "sqlite_fastest_ms": 2828.33, "sqlite_indexed_median_ms": 7.57, "sqlite_indexed_fastest_ms": 7.53}
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-before-4-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-before-4-linux-aarch64.jsonl
new file mode 100644
index 0000000..9d8a715
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-queries-before-4-linux-aarch64.jsonl
@@ -0,0 +1,4 @@
+{"query": "per_branch", "rows": 10, "accounts": 100000, "pure_median_ms": 5.1, "pure_fastest_ms": 5.04, "sqlite_median_ms": 45.36, "sqlite_fastest_ms": 45.19, "sqlite_indexed_median_ms": 14.14, "sqlite_indexed_fastest_ms": 14.07}
+{"query": "in_credit", "rows": 1, "accounts": 100000, "pure_median_ms": 0.87, "pure_fastest_ms": 0.8, "sqlite_median_ms": 5.97, "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.39, "pure_fastest_ms": 0.37, "sqlite_median_ms": 1.48, "sqlite_fastest_ms": 1.47, "sqlite_indexed_median_ms": 1.49, "sqlite_indexed_fastest_ms": 1.47}
+{"query": "ranks", "rows": 404, "accounts": 100000, "pure_median_ms": 6.64, "pure_fastest_ms": 6.56, "sqlite_median_ms": 2840.1, "sqlite_fastest_ms": 2835.52, "sqlite_indexed_median_ms": 7.6, "sqlite_indexed_fastest_ms": 7.5}
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-after-1-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-after-1-linux-aarch64.jsonl
new file mode 100644
index 0000000..b86020a
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-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.71, "sqlite_load_s": 1.54, "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": 45418, "new_orders_per_minute": 1214970, "undone_new_orders": 3903, "errors": 0, "new_order": {"done": 408893, "failed": 0, "p50_us": 1408, "p99_us": 2816}, "payment": {"done": 390468, "failed": 0, "p50_us": 1408, "p99_us": 2816}, "order_status": {"done": 36403, "failed": 0, "p50_us": 248, "p99_us": 1088}, "delivery": {"done": 36383, "failed": 0, "p50_us": 1408, "p99_us": 2816}, "stock_level": {"done": 36206, "failed": 0, "p50_us": 272, "p99_us": 1152}, "server_threads": "3", "cpu_us_per_transaction": 42.5, "core_shares": {"pure-owner": 0.92, "pure-checkpoint": 0.01}, "resident_mib": 473.0, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 473.0, "pure_state_mib": 241.0, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27563, "burst_events": 831923, "checkpoints": 40}}
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-after-2-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-after-2-linux-aarch64.jsonl
new file mode 100644
index 0000000..afd2e64
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-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.71, "sqlite_load_s": 1.57, "sqlite_page_size": 4096, "pure_resident_mib": 39.0, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 44696, "new_orders_per_minute": 1195823, "undone_new_orders": 3839, "errors": 0, "new_order": {"done": 402447, "failed": 0, "p50_us": 1472, "p99_us": 3328}, "payment": {"done": 384199, "failed": 0, "p50_us": 1408, "p99_us": 3328}, "order_status": {"done": 35824, "failed": 0, "p50_us": 248, "p99_us": 1152}, "delivery": {"done": 35800, "failed": 0, "p50_us": 1408, "p99_us": 3328}, "stock_level": {"done": 35643, "failed": 0, "p50_us": 272, "p99_us": 1152}, "server_threads": "3", "cpu_us_per_transaction": 42.6, "core_shares": {"pure-owner": 0.9, "pure-checkpoint": 0.01}, "resident_mib": 467.7, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 467.7, "pure_state_mib": 237.5, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26689, "burst_events": 818687, "checkpoints": 40}}
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-after-3-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-after-3-linux-aarch64.jsonl
new file mode 100644
index 0000000..70753d1
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-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.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": 44008, "new_orders_per_minute": 1177625, "undone_new_orders": 3772, "errors": 0, "new_order": {"done": 396314, "failed": 0, "p50_us": 1472, "p99_us": 3456}, "payment": {"done": 378248, "failed": 0, "p50_us": 1408, "p99_us": 3456}, "order_status": {"done": 35282, "failed": 0, "p50_us": 248, "p99_us": 1280}, "delivery": {"done": 35232, "failed": 0, "p50_us": 1408, "p99_us": 3456}, "stock_level": {"done": 35084, "failed": 0, "p50_us": 272, "p99_us": 1280}, "server_threads": "3", "cpu_us_per_transaction": 42.9, "core_shares": {"pure-owner": 0.89, "pure-checkpoint": 0.01}, "resident_mib": 461.0, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 461.0, "pure_state_mib": 234.3, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26570, "burst_events": 806106, "checkpoints": 39}}
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-after-4-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-after-4-linux-aarch64.jsonl
new file mode 100644
index 0000000..ad39c5f
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-after-4-linux-aarch64.jsonl
@@ -0,0 +1,3 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.57, "pure_load_s": 0.72, "sqlite_load_s": 1.55, "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": 44435, "new_orders_per_minute": 1188830, "undone_new_orders": 3810, "errors": 0, "new_order": {"done": 400088, "failed": 0, "p50_us": 1472, "p99_us": 3456}, "payment": {"done": 382016, "failed": 0, "p50_us": 1408, "p99_us": 3328}, "order_status": {"done": 35618, "failed": 0, "p50_us": 248, "p99_us": 1216}, "delivery": {"done": 35570, "failed": 0, "p50_us": 1408, "p99_us": 3328}, "stock_level": {"done": 35406, "failed": 0, "p50_us": 272, "p99_us": 1280}, "server_threads": "3", "cpu_us_per_transaction": 42.3, "core_shares": {"pure-owner": 0.9, "pure-checkpoint": 0.01}, "resident_mib": 464.5, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 464.5, "pure_state_mib": 236.3, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26850, "burst_events": 813948, "checkpoints": 40}}
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-before-1-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-before-1-linux-aarch64.jsonl
new file mode 100644
index 0000000..d55c812
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-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.2, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 46010, "new_orders_per_minute": 1230854, "undone_new_orders": 3952, "errors": 0, "new_order": {"done": 414237, "failed": 0, "p50_us": 1408, "p99_us": 2688}, "payment": {"done": 395530, "failed": 0, "p50_us": 1408, "p99_us": 2688}, "order_status": {"done": 36927, "failed": 0, "p50_us": 240, "p99_us": 960}, "delivery": {"done": 36850, "failed": 0, "p50_us": 1408, "p99_us": 2688}, "stock_level": {"done": 36663, "failed": 0, "p50_us": 272, "p99_us": 1024}, "server_threads": "3", "cpu_us_per_transaction": 41.7, "core_shares": {"pure-owner": 0.91, "pure-checkpoint": 0.01}, "resident_mib": 478.5, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 478.5, "pure_state_mib": 243.8, "pure_store_mib": 254.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27357, "burst_events": 842750, "checkpoints": 41}}
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-before-2-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-before-2-linux-aarch64.jsonl
new file mode 100644
index 0000000..913f138
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-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.9, "sqlite_file_mib": 13.8}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 43437, "new_orders_per_minute": 1162146, "undone_new_orders": 3712, "errors": 0, "new_order": {"done": 391094, "failed": 0, "p50_us": 1472, "p99_us": 3712}, "payment": {"done": 373444, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "order_status": {"done": 34810, "failed": 0, "p50_us": 256, "p99_us": 1600}, "delivery": {"done": 34796, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "stock_level": {"done": 34602, "failed": 0, "p50_us": 288, "p99_us": 1728}, "server_threads": "3", "cpu_us_per_transaction": 43.5, "core_shares": {"pure-owner": 0.89, "pure-checkpoint": 0.01}, "resident_mib": 456.2, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 456.2, "pure_state_mib": 231.5, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27180, "burst_events": 795704, "checkpoints": 39}}
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-before-3-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-before-3-linux-aarch64.jsonl
new file mode 100644
index 0000000..8f7e189
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-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.67, "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": 43382, "new_orders_per_minute": 1160820, "undone_new_orders": 3704, "errors": 0, "new_order": {"done": 390644, "failed": 0, "p50_us": 1408, "p99_us": 4096}, "payment": {"done": 372875, "failed": 0, "p50_us": 1408, "p99_us": 4096}, "order_status": {"done": 34808, "failed": 0, "p50_us": 256, "p99_us": 1536}, "delivery": {"done": 34745, "failed": 0, "p50_us": 1408, "p99_us": 4096}, "stock_level": {"done": 34574, "failed": 0, "p50_us": 272, "p99_us": 1856}, "server_threads": "3", "cpu_us_per_transaction": 42.6, "core_shares": {"pure-owner": 0.88, "pure-checkpoint": 0.01}, "resident_mib": 454.7, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 454.7, "pure_state_mib": 231.2, "pure_store_mib": 238.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 26395, "burst_events": 794640, "checkpoints": 38}}
diff --git a/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-before-4-linux-aarch64.jsonl b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-before-4-linux-aarch64.jsonl
new file mode 100644
index 0000000..a155378
--- /dev/null
+++ b/research/experiments/026-apps-on-one-host/41502b9/2026-10-01-tpcc-before-4-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.55, "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": 44310, "new_orders_per_minute": 1185677, "undone_new_orders": 3802, "errors": 0, "new_order": {"done": 399031, "failed": 0, "p50_us": 1408, "p99_us": 3584}, "payment": {"done": 380835, "failed": 0, "p50_us": 1408, "p99_us": 3584}, "order_status": {"done": 35528, "failed": 0, "p50_us": 256, "p99_us": 1280}, "delivery": {"done": 35481, "failed": 0, "p50_us": 1408, "p99_us": 3712}, "stock_level": {"done": 35336, "failed": 0, "p50_us": 288, "p99_us": 1472}, "server_threads": "3", "cpu_us_per_transaction": 42.7, "core_shares": {"pure-owner": 0.9, "pure-checkpoint": 0.01}, "resident_mib": 463.8, "written_bytes_per_transaction": 0.0, "device_bytes_per_transaction": null, "consistency_failures": []}
+{"step": "end", "pure_resident_mib": 463.8, "pure_state_mib": 235.7, "pure_store_mib": 246.7, "sqlite_files_mib": 13.8, "grouped_sqlite_files_mib": 0.0, "pure_counts": {"bursts": 27382, "burst_events": 811631, "checkpoints": 40}}