Check TPC-C's consistency from one snapshot a side, and measure TPC-C on RAM and an SD card

2 files changed, 14 insertions, 0 deletions

diff --git a/research/experiments/018-tpcc/2026-09-28-tpcc-ram-linux-aarch64.jsonl b/research/experiments/018-tpcc/2026-09-28-tpcc-ram-linux-aarch64.jsonl
new file mode 100644
index 0000000..abd4870
--- /dev/null
+++ b/research/experiments/018-tpcc/2026-09-28-tpcc-ram-linux-aarch64.jsonl
@@ -0,0 +1,7 @@
+{"step": "load", "directory": "/dev/shm", "warehouses": 1, "rows": 568758, "generate_s": 0.55, "pure_load_s": 0.72, "sqlite_load_s": 1.56, "pure_resident_mib": 40.8, "sqlite_file_mib": 13.8}
+{"step": "same transactions", "transactions": 20000, "pure": {"new_order": 9036, "payment": 8518, "order_status": 811, "delivery": 796, "stock_level": 839}, "sqlite": {"new_order": 9036, "payment": 8518, "order_status": 811, "delivery": 796, "stock_level": 839}, "undone_new_orders": [90, 90], "failed": [0, 0], "differing": {}, "consistency_failures": []}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 16, "transactions_per_second": 35863, "new_orders_per_minute": 959979, "undone_new_orders": 3268, "errors": 0, "new_order": {"done": 323261, "failed": 0, "p50_us": 448, "p99_us": 1280}, "payment": {"done": 308146, "failed": 0, "p50_us": 416, "p99_us": 1216}, "order_status": {"done": 28732, "failed": 0, "p50_us": 96, "p99_us": 544}, "delivery": {"done": 28543, "failed": 0, "p50_us": 432, "p99_us": 1216}, "stock_level": {"done": 28586, "failed": 0, "p50_us": 144, "p99_us": 640}, "server_threads": "3", "cpu_us_per_transaction": 45.5, "resident_mib": 480.6, "consistency_failures": []}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 38564, "new_orders_per_minute": 1031566, "undone_new_orders": 3300, "errors": 0, "new_order": {"done": 347158, "failed": 0, "p50_us": 1664, "p99_us": 3840}, "payment": {"done": 331554, "failed": 0, "p50_us": 1600, "p99_us": 3840}, "order_status": {"done": 30996, "failed": 0, "p50_us": 272, "p99_us": 1792}, "delivery": {"done": 30934, "failed": 0, "p50_us": 1664, "p99_us": 3840}, "stock_level": {"done": 30644, "failed": 0, "p50_us": 304, "p99_us": 1920}, "server_threads": "3", "cpu_us_per_transaction": 48.7, "resident_mib": 892.9, "consistency_failures": []}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 128, "transactions_per_second": 39449, "new_orders_per_minute": 1052334, "undone_new_orders": 3568, "errors": 0, "new_order": {"done": 354349, "failed": 0, "p50_us": 3328, "p99_us": 7424}, "payment": {"done": 339392, "failed": 0, "p50_us": 3200, "p99_us": 7424}, "order_status": {"done": 31880, "failed": 0, "p50_us": 496, "p99_us": 2816}, "delivery": {"done": 31563, "failed": 0, "p50_us": 3200, "p99_us": 7424}, "stock_level": {"done": 31802, "failed": 0, "p50_us": 512, "p99_us": 3072}, "server_threads": "3", "cpu_us_per_transaction": 50.0, "resident_mib": 1282.7, "consistency_failures": []}
+{"step": "run", "system": "sqlite 3.46.1", "synchronous": "full", "warehouses": 1, "terminals": 1, "transactions_per_second": 9493, "new_orders_per_minute": 254310, "undone_new_orders": 894, "new_order": {"done": 85669, "failed": 0, "p50_us": 152, "p99_us": 1152}, "payment": {"done": 81386, "failed": 0, "p50_us": 25, "p99_us": 50}, "order_status": {"done": 7574, "failed": 0, "p50_us": 18, "p99_us": 31}, "delivery": {"done": 7659, "failed": 0, "p50_us": 60, "p99_us": 108}, "stock_level": {"done": 7579, "failed": 0, "p50_us": 272, "p99_us": 416}, "consistency_failures": []}
+{"step": "run", "system": "sqlite 3.46.1", "synchronous": "full", "warehouses": 1, "terminals": 4, "transactions_per_second": 9141, "new_orders_per_minute": 244796, "undone_new_orders": 865, "new_order": {"done": 82571, "failed": 0, "p50_us": 160, "p99_us": 1216}, "payment": {"done": 78584, "failed": 0, "p50_us": 25, "p99_us": 160}, "order_status": {"done": 7284, "failed": 0, "p50_us": 19, "p99_us": 38}, "delivery": {"done": 7320, "failed": 0, "p50_us": 62, "p99_us": 1024}, "stock_level": {"done": 7293, "failed": 0, "p50_us": 288, "p99_us": 608}, "consistency_failures": []}
diff --git a/research/experiments/018-tpcc/2026-09-28-tpcc-sd-linux-aarch64.jsonl b/research/experiments/018-tpcc/2026-09-28-tpcc-sd-linux-aarch64.jsonl
new file mode 100644
index 0000000..46bf04b
--- /dev/null
+++ b/research/experiments/018-tpcc/2026-09-28-tpcc-sd-linux-aarch64.jsonl
@@ -0,0 +1,7 @@
+{"step": "load", "directory": "/home/eunhhu/tpcc-sd", "warehouses": 1, "rows": 568758, "generate_s": 0.56, "pure_load_s": 6.31, "sqlite_load_s": 1.61, "pure_resident_mib": 40.8, "sqlite_file_mib": 13.8}
+{"step": "same transactions", "transactions": 2000, "pure": {"new_order": 887, "payment": 870, "order_status": 82, "delivery": 84, "stock_level": 77}, "sqlite": {"new_order": 887, "payment": 870, "order_status": 82, "delivery": 84, "stock_level": 77}, "undone_new_orders": [6, 6], "failed": [0, 0], "differing": {}, "consistency_failures": []}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 16, "transactions_per_second": 1465, "new_orders_per_minute": 39149, "undone_new_orders": 188, "errors": 0, "new_order": {"done": 19763, "failed": 0, "p50_us": 5632, "p99_us": 73728}, "payment": {"done": 18841, "failed": 0, "p50_us": 5632, "p99_us": 73728}, "order_status": {"done": 1759, "failed": 0, "p50_us": 128, "p99_us": 432}, "delivery": {"done": 1832, "failed": 0, "p50_us": 5632, "p99_us": 69632}, "stock_level": {"done": 1769, "failed": 0, "p50_us": 192, "p99_us": 480}, "server_threads": "3", "cpu_us_per_transaction": 61.2, "resident_mib": 67.7, "consistency_failures": []}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 64, "transactions_per_second": 3008, "new_orders_per_minute": 80545, "undone_new_orders": 401, "errors": 0, "new_order": {"done": 40685, "failed": 0, "p50_us": 8704, "p99_us": 221184}, "payment": {"done": 38759, "failed": 0, "p50_us": 8704, "p99_us": 212992}, "order_status": {"done": 3711, "failed": 0, "p50_us": 352, "p99_us": 1280}, "delivery": {"done": 3594, "failed": 0, "p50_us": 8704, "p99_us": 221184}, "stock_level": {"done": 3521, "failed": 0, "p50_us": 400, "p99_us": 1280}, "server_threads": "3", "cpu_us_per_transaction": 55.9, "resident_mib": 236.9, "consistency_failures": []}
+{"step": "run", "system": "pure", "warehouses": 1, "terminals": 128, "transactions_per_second": 3073, "new_orders_per_minute": 82063, "undone_new_orders": 405, "errors": 0, "new_order": {"done": 41521, "failed": 0, "p50_us": 11776, "p99_us": 622592}, "payment": {"done": 39762, "failed": 0, "p50_us": 11776, "p99_us": 622592}, "order_status": {"done": 3770, "failed": 0, "p50_us": 608, "p99_us": 2304}, "delivery": {"done": 3732, "failed": 0, "p50_us": 11264, "p99_us": 589824}, "stock_level": {"done": 3589, "failed": 0, "p50_us": 640, "p99_us": 2304}, "server_threads": "3", "cpu_us_per_transaction": 52.0, "resident_mib": 414.9, "consistency_failures": []}
+{"step": "run", "system": "sqlite 3.46.1", "synchronous": "full", "warehouses": 1, "terminals": 1, "transactions_per_second": 37, "new_orders_per_minute": 1012, "undone_new_orders": 6, "new_order": {"done": 512, "failed": 0, "p50_us": 5120, "p99_us": 557056}, "payment": {"done": 474, "failed": 0, "p50_us": 2432, "p99_us": 163840}, "order_status": {"done": 45, "failed": 0, "p50_us": 34, "p99_us": 64}, "delivery": {"done": 41, "failed": 0, "p50_us": 2432, "p99_us": 65536}, "stock_level": {"done": 53, "failed": 0, "p50_us": 464, "p99_us": 576}, "consistency_failures": []}
+{"step": "run", "system": "sqlite 3.46.1", "synchronous": "full", "warehouses": 1, "terminals": 4, "transactions_per_second": 55, "new_orders_per_minute": 1425, "undone_new_orders": 12, "new_order": {"done": 730, "failed": 0, "p50_us": 5120, "p99_us": 1245184}, "payment": {"done": 732, "failed": 0, "p50_us": 3072, "p99_us": 2621440}, "order_status": {"done": 65, "failed": 0, "p50_us": 34, "p99_us": 184}, "delivery": {"done": 69, "failed": 0, "p50_us": 4352, "p99_us": 491520}, "stock_level": {"done": 68, "failed": 0, "p50_us": 480, "p99_us": 928}, "consistency_failures": []}