Performance Benchmarking Guide

<h2 id="performance-benchmarking-guide" class="position-relative d-flex align-items-center group"> Performance Benchmarking Guide <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="performance-benchmarking-guide" aria-haspopup="dialog" aria-label="Share link: Performance Benchmarking Guide"> Share link </button> </h2><div id="headingShareModal" class="heading-share-modal" role="dialog" aria-modal="true" aria-labelledby="headingShareTitle" hidden> <div class="hsm-dialog" role="document"> <div class="hsm-header"> <h2 id="headingShareTitle" class="h6 mb-0 fw-bold">Share this section</h2> <button type="button" class="hsm-close" aria-label="Close"> </button> </div> <div class="hsm-body"> <label for="headingShareInput" class="form-label small text-muted mb-1 text-uppercase fw-bold" style="font-size: 0.7rem; letter-spacing: 0.5px;">Permalink</label> <div class="input-group mb-4 hsm-url-group"> <input id="headingShareInput" type="text" class="form-control font-monospace" readonly aria-readonly="true" style="font-size: 0.85rem;" /> <button class="btn btn-primary hsm-copy" type="button" aria-label="Copy" title="Copy"> </button> </div> <div class="small fw-bold mb-2 text-muted text-uppercase" style="font-size: 0.7rem; letter-spacing: 0.5px;">Share via</div> <div class="hsm-share-grid"> <a id="share-twitter" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Twitter </a> <a id="share-linkedin" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> LinkedIn </a> <a id="share-facebook" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> Facebook </a> </div> </div> </div> </div> <style> .heading-share-modal { position: fixed; inset: 0; display: flex; justify-content: center; align-items: center; background: rgba(0, 0, 0, 0.6); z-index: 1050; padding: 1rem; backdrop-filter: blur(4px); -webkit-backdrop-filter: blur(4px); } .heading-share-modal[hidden] { display: none !important; } .hsm-dialog { max-width: 420px; width: 100%; background: var(--bs-body-bg, #fff); color: var(--bs-body-color, #212529); border: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); border-radius: 1rem; box-shadow: 0 25px 50px -12px rgba(0, 0, 0, 0.25); overflow: hidden; animation: hsm-fade-in 0.2s ease-out; } @keyframes hsm-fade-in { from { opacity: 0; transform: scale(0.95); } to { opacity: 1; transform: scale(1); } } [data-bs-theme="dark"] .hsm-dialog { background: #1e293b; border-color: rgba(255,255,255,0.1); color: #f8f9fa; } .hsm-header { display: flex; justify-content: space-between; align-items: center; padding: 1rem 1.5rem; border-bottom: 1px solid var(--bs-border-color, rgba(0,0,0,0.1)); background: rgba(0,0,0,0.02); } [data-bs-theme="dark"] .hsm-header { background: rgba(255,255,255,0.02); border-color: rgba(255,255,255,0.1); } .hsm-close { background: transparent; border: none; color: inherit; opacity: 0.5; padding: 0.25rem 0.5rem; border-radius: 0.25rem; font-size: 1.2rem; line-height: 1; transition: opacity 0.2s; } .hsm-close:hover { opacity: 1; } .hsm-body { padding: 1.5rem; } .hsm-url-group { display: flex !important; align-items: stretch; } .hsm-url-group .form-control { flex: 1; min-width: 0; margin: 0; background: var(--bs-secondary-bg, #f8f9fa); border-color: var(--bs-border-color, #dee2e6); border-top-right-radius: 0; border-bottom-right-radius: 0; height: 42px; } .hsm-url-group .btn { flex: 0 0 auto; margin: 0; margin-left: -1px; border-top-left-radius: 0; border-bottom-left-radius: 0; height: 42px; display: flex; align-items: center; justify-content: center; padding: 0 1.25rem; z-index: 2; } [data-bs-theme="dark"] .hsm-url-group .form-control { background: #0f172a; border-color: #334155; color: #e2e8f0; } .hsm-share-grid { display: flex; flex-direction: column; gap: 0.5rem; } .hsm-share-grid .btn { display: flex; align-items: center; justify-content: center; font-size: 0.9rem; padding: 0.6rem; border-color: var(--bs-border-color); width: 100%; } [data-bs-theme="dark"] .hsm-share-grid .btn { color: #e2e8f0; border-color: #475569; } [data-bs-theme="dark"] .hsm-share-grid .btn:hover { background: #334155; border-color: #cbd5e1; } </style> <script> (function(){ const modal = document.getElementById('headingShareModal'); if(!modal) return; const input = modal.querySelector('#headingShareInput'); const copyBtn = modal.querySelector('.hsm-copy'); const twitter = modal.querySelector('#share-twitter'); const linkedin = modal.querySelector('#share-linkedin'); const facebook = modal.querySelector('#share-facebook'); const closeBtn = modal.querySelector('.hsm-close'); let lastFocus=null; let trapBound=false; function buildUrl(id){ return window.location.origin + window.location.pathname + '#' + id; } function isOpen(){ return !modal.hasAttribute('hidden'); } function hydrate(id){ const url=buildUrl(id); input.value=url; const enc=encodeURIComponent(url); const text=encodeURIComponent(document.title); if(twitter) twitter.href=`https://twitter.com/intent/tweet?url=${enc}&text=${text}`; if(linkedin) linkedin.href=`https://www.linkedin.com/sharing/share-offsite/?url=${enc}`; if(facebook) facebook.href=`https://www.facebook.com/sharer/sharer.php?u=${enc}`; } function openModal(id){ lastFocus=document.activeElement; hydrate(id); if(!isOpen()){ modal.removeAttribute('hidden'); } requestAnimationFrame(()=>{ input.focus(); }); trapFocus(); } function closeModal(){ if(!isOpen()) return; modal.setAttribute('hidden',''); if(lastFocus && typeof lastFocus.focus==='function') lastFocus.focus(); } function copyCurrent(){ try{ navigator.clipboard.writeText(input.value).then(()=>feedback(true),()=>fallback()); } catch(e){ fallback(); } } function fallback(){ input.select(); try{ document.execCommand('copy'); feedback(true);}catch(e){ feedback(false);} } function feedback(ok){ if(!copyBtn) return; const icon=copyBtn.querySelector('i'); if(!icon) return; const prev=copyBtn.getAttribute('data-prev')||icon.className; if(!copyBtn.getAttribute('data-prev')) copyBtn.setAttribute('data-prev',prev); icon.className= ok ? 'fa-duotone fa-clipboard-check':'fa-duotone fa-circle-exclamation'; setTimeout(()=>{ icon.className=prev; },1800); } function handleShareClick(e){ e.preventDefault(); const btn=e.currentTarget; const id=btn.getAttribute('data-share-target'); if(id) openModal(id); } function bindShareButtons(){ document.querySelectorAll('.h-share').forEach(btn=>{ if(!btn.dataset.hShareBound){ btn.addEventListener('click', handleShareClick); btn.dataset.hShareBound='1'; } }); } bindShareButtons(); if(document.readyState==='loading'){ document.addEventListener('DOMContentLoaded', bindShareButtons); } else { requestAnimationFrame(bindShareButtons); } document.addEventListener('click', function(e){ const shareBtn=e.target.closest && e.target.closest('.h-share'); if(shareBtn && !shareBtn.dataset.hShareBound){ handleShareClick.call(shareBtn, e); } }, true); document.addEventListener('click', e=>{ if(e.target===modal) closeModal(); if(e.target.closest && e.target.closest('.hsm-close')){ e.preventDefault(); closeModal(); } if(copyBtn && (e.target===copyBtn || (e.target.closest && e.target.closest('.hsm-copy')))) { e.preventDefault(); copyCurrent(); } }); document.addEventListener('keydown', e=>{ if(e.key==='Escape' && isOpen()) closeModal(); }); function trapFocus(){ if(trapBound) return; trapBound=true; modal.addEventListener('keydown', f=>{ if(f.key==='Tab' && isOpen()){ const focusable=[...modal.querySelectorAll('a[href],button,input,textarea,select,[tabindex]:not([tabindex="-1"])')].filter(el=>!el.hasAttribute('disabled')); if(!focusable.length) return; const first=focusable[0]; const last=focusable[focusable.length-1]; if(f.shiftKey && document.activeElement===first){ f.preventDefault(); last.focus(); } else if(!f.shiftKey && document.activeElement===last){ f.preventDefault(); first.focus(); } } }); } if(closeBtn) closeBtn.addEventListener('click', e=>{ e.preventDefault(); closeModal(); }); })(); </script>Measure and optimize Geode performance with comprehensive benchmarking and profiling techniques. <h3 id="overview" class="position-relative d-flex align-items-center group"> Overview <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="overview" aria-haspopup="dialog" aria-label="Share link: Overview"> Share link </button> </h3>Benchmarking helps you: <ul> <li>Establish baselines: Measure current performance</li> <li>Track improvements: Verify optimizations work</li> <li>Identify bottlenecks: Find performance issues</li> <li>Capacity planning: Determine hardware requirements</li> <li>Compare configurations: Test different settings</li> </ul> <h3 id="benchmark-types" class="position-relative d-flex align-items-center group"> Benchmark Types <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="benchmark-types" aria-haspopup="dialog" aria-label="Share link: Benchmark Types"> Share link </button> </h3> <h4 id="1-microbenchmarks" class="position-relative d-flex align-items-center group"> 1. Microbenchmarks <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="1-microbenchmarks" aria-haspopup="dialog" aria-label="Share link: 1. Microbenchmarks"> Share link </button> </h4>Test specific operations in isolation Examples: <ul> <li>Single query latency</li> <li>Vector distance calculation speed</li> <li>Index lookup performance</li> <li>MVCC transaction overhead</li> </ul> <h4 id="2-workload-benchmarks" class="position-relative d-flex align-items-center group"> 2. Workload Benchmarks <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="2-workload-benchmarks" aria-haspopup="dialog" aria-label="Share link: 2. Workload Benchmarks"> Share link </button> </h4>Simulate realistic usage patterns Examples: <ul> <li>OLTP (transactional workload)</li> <li>OLAP (analytical queries)</li> <li>Mixed read/write workload</li> <li>Graph traversal patterns</li> </ul> <h4 id="3-stress-tests" class="position-relative d-flex align-items-center group"> 3. Stress Tests <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="3-stress-tests" aria-haspopup="dialog" aria-label="Share link: 3. Stress Tests"> Share link </button> </h4>Test system limits and behavior under extreme load Examples: <ul> <li>Maximum concurrent connections</li> <li>Sustained high throughput</li> <li>Large dataset queries</li> <li>Memory pressure scenarios</li> </ul> <h4 id="4-endurance-tests" class="position-relative d-flex align-items-center group"> 4. Endurance Tests <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="4-endurance-tests" aria-haspopup="dialog" aria-label="Share link: 4. Endurance Tests"> Share link </button> </h4>Long-running tests for stability Examples: <ul> <li>24-hour continuous load</li> <li>Memory leak detection</li> <li>Performance degradation over time</li> <li>Resource cleanup verification</li> </ul> <h3 id="setup" class="position-relative d-flex align-items-center group"> Setup <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="setup" aria-haspopup="dialog" aria-label="Share link: Setup"> Share link </button> </h3> <h4 id="hardware-recommendations" class="position-relative d-flex align-items-center group"> Hardware Recommendations <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="hardware-recommendations" aria-haspopup="dialog" aria-label="Share link: Hardware Recommendations"> Share link </button> </h4>Minimum (Development): <ul> <li>CPU: 4 cores</li> <li>RAM: 8GB</li> <li>Storage: 50GB SSD</li> <li>Network: 1Gbps</li> </ul> Recommended (Production Benchmarking): <ul> <li>CPU: 16+ cores</li> <li>RAM: 32GB+</li> <li>Storage: 500GB NVMe SSD</li> <li>Network: 10Gbps</li> </ul> <h4 id="software-requirements" class="position-relative d-flex align-items-center group"> Software Requirements <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="software-requirements" aria-haspopup="dialog" aria-label="Share link: Software Requirements"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Install Geode git clone https://github.com/codeprosorg/geode cd geode make build # Install benchmark tools pip install locust geode-client # Install monitoring tools # Prometheus, Grafana (optional) </code></pre></div> <h4 id="system-tuning" class="position-relative d-flex align-items-center group"> System Tuning <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="system-tuning" aria-haspopup="dialog" aria-label="Share link: System Tuning"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Increase file descriptor limit ulimit -n 65536 # Disable swap for consistent performance sudo swapoff -a # Set CPU governor to performance mode echo performance | sudo tee /sys/devices/system/cpu/cpu*/cpufreq/scaling_governor # Disable CPU frequency scaling sudo cpupower frequency-set -g performance </code></pre></div> <h3 id="built-in-benchmarks" class="position-relative d-flex align-items-center group"> Built-in Benchmarks <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="built-in-benchmarks" aria-haspopup="dialog" aria-label="Share link: Built-in Benchmarks"> Share link </button> </h3> <h4 id="run-native-benchmarks" class="position-relative d-flex align-items-center group"> Run Native Benchmarks <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="run-native-benchmarks" aria-haspopup="dialog" aria-label="Share link: Run Native Benchmarks"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Run all benchmarks cd geode zig build bench # Run specific benchmark category zig build bench -- --filter "PageRank" zig build bench -- --filter "Storage" zig build bench -- --filter "HNSW" </code></pre></div>Categories: <ul> <li><code>Storage</code>: Page manager, WAL, cache</li> <li><code>Query</code>: Pattern matching, aggregations</li> <li><code>Index</code>: B-tree, HNSW, full-text search</li> <li><code>Vector</code>: Distance calculations, HNSW search</li> <li><code>Graph</code>: PageRank, shortest path, centrality</li> <li><code>Transaction</code>: MVCC, isolation, deadlock detection</li> </ul> <h4 id="interpret-benchmark-output" class="position-relative d-flex align-items-center group"> Interpret Benchmark Output <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="interpret-benchmark-output" aria-haspopup="dialog" aria-label="Share link: Interpret Benchmark Output"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">Benchmark: PageRank (100 nodes, 500 edges) Iterations: 20 Damping factor: 0.85 Time: 15.23ms Throughput: 65.7 iterations/sec Memory: 2.4MB Baseline: 18.50ms Improvement: 17.7% </code></pre></div>Key Metrics: <ul> <li>Time: Average execution time</li> <li>Throughput: Operations per second</li> <li>Memory: Peak memory usage</li> <li>Baseline: Previous performance</li> <li>Improvement: Percent change from baseline</li> </ul> <h3 id="query-benchmarking" class="position-relative d-flex align-items-center group"> Query Benchmarking <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="query-benchmarking" aria-haspopup="dialog" aria-label="Share link: Query Benchmarking"> Share link </button> </h3> <h4 id="explain-and-profile" class="position-relative d-flex align-items-center group"> EXPLAIN and PROFILE <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="explain-and-profile" aria-haspopup="dialog" aria-label="Share link: EXPLAIN and PROFILE"> Share link </button> </h4> <h5 id="explain-plan-only" class="position-relative d-flex align-items-center group"> EXPLAIN (Plan Only) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="explain-plan-only" aria-haspopup="dialog" aria-label="Share link: EXPLAIN (Plan Only)"> Share link </button> </h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">EXPLAIN MATCH (p:Person)-[:KNOWS*2]-(fof:Person) WHERE p.name = 'Alice' AND fof <> p RETURN DISTINCT fof.name; </code></pre></div>Output: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">QUERY PLAN: ┌─ Project [fof.name] └─ Distinct └─ Filter [fof <> p] └─ VarLengthExpand [KNOWS*2] └─ IndexScan [person_name_idx] Condition: name = 'Alice' Estimated rows: 1 Estimated cost: 2.5 </code></pre></div> <h5 id="profile-execute-and-measure" class="position-relative d-flex align-items-center group"> PROFILE (Execute and Measure) <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="profile-execute-and-measure" aria-haspopup="dialog" aria-label="Share link: PROFILE (Execute and Measure)"> Share link </button> </h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">PROFILE MATCH (p:Person)-[:KNOWS*2]-(fof:Person) WHERE p.name = 'Alice' AND fof <> p RETURN DISTINCT fof.name; </code></pre></div>Output: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">PROFILE RESULTS: Operation: Project Rows: 5 Time: 0.12ms Operation: Distinct Rows in: 8 Rows out: 5 Time: 0.08ms Operation: Filter [fof <> p] Rows in: 10 Rows out: 8 Time: 0.05ms Operation: VarLengthExpand [KNOWS*2] Rows: 10 Time: 1.25ms Relationships traversed: 45 Operation: IndexScan [person_name_idx] Rows: 1 Time: 0.02ms Index: person_name_idx (hash) Total Time: 1.52ms Peak Memory: 1.2MB </code></pre></div> <h4 id="benchmark-individual-queries" class="position-relative d-flex align-items-center group"> Benchmark Individual Queries <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="benchmark-individual-queries" aria-haspopup="dialog" aria-label="Share link: Benchmark Individual Queries"> Share link </button> </h4> <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Python script - Query benchmarking (async) import asyncio import statistics import time from geode_client import Client async def benchmark_query(conn, query, params=None, iterations=100): """Benchmark a single query""" times = [] # Warmup for _ in range(10): await conn.query(query, params) # Measure for _ in range(iterations): start = time.perf_counter() await conn.query(query, params) end = time.perf_counter() times.append((end - start) * 1000) # Convert to ms return { 'mean': statistics.mean(times), 'median': statistics.median(times), 'p95': sorted(times)[int(len(times) * 0.95)], 'p99': sorted(times)[int(len(times) * 0.99)], 'min': min(times), 'max': max(times), 'stdev': statistics.stdev(times) } async def main(): client = Client(host="localhost", port=3141) async with client.connection() as conn: query = """ MATCH (p:Person) WHERE p.age > 30 RETURN p.name, p.age ORDER BY p.age DESC LIMIT 10 """ results = await benchmark_query(conn, query, iterations=1000) print("Query Performance (1000 iterations):") print(f" Mean: {results['mean']:.2f}ms") print(f" Median: {results['median']:.2f}ms") print(f" P95: {results['p95']:.2f}ms") print(f" P99: {results['p99']:.2f}ms") print(f" Range: {results['min']:.2f}ms - {results['max']:.2f}ms") print(f" StdDev: {results['stdev']:.2f}ms") asyncio.run(main()) </code></pre></div> <h3 id="load-testing-with-locust" class="position-relative d-flex align-items-center group"> Load Testing with Locust <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="load-testing-with-locust" aria-haspopup="dialog" aria-label="Share link: Load Testing with Locust"> Share link </button> </h3> <h4 id="install-locust" class="position-relative d-flex align-items-center group"> Install Locust <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="install-locust" aria-haspopup="dialog" aria-label="Share link: Install Locust"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash">pip install locust geode-client </code></pre></div> <h4 id="create-load-test-script" class="position-relative d-flex align-items-center group"> Create Load Test Script <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="create-load-test-script" aria-haspopup="dialog" aria-label="Share link: Create Load Test Script"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># locustfile.py from locust import User, task, between from geode_client import Client import asyncio import random class GeodeUser(User): wait_time = between(0.1, 0.5) # Wait 0.1-0.5s between requests def on_start(self): """Initialize connection""" self.loop = asyncio.new_event_loop() asyncio.set_event_loop(self.loop) self.client = Client(host="localhost", port=3141) self.conn = self.loop.run_until_complete(self.client.connect()) def on_stop(self): self.loop.run_until_complete(self.conn.close()) self.loop.close() def _run(self, coro): return self.loop.run_until_complete(coro) @task(weight=70) def read_person(self): """Read operation (70% of requests)""" name = f"Person_{random.randint(1, 1000)}" self._run(self.conn.query(""" MATCH (p:Person {name: $name}) RETURN p """, {'name': name})) @task(weight=20) def search_by_age(self): """Range query (20% of requests)""" min_age = random.randint(20, 60) self._run(self.conn.query(""" MATCH (p:Person) WHERE p.age >= $min_age RETURN p.name, p.age LIMIT 10 """, {'min_age': min_age})) @task(weight=10) def create_person(self): """Write operation (10% of requests)""" person_id = random.randint(1, 10000) self._run(self.conn.query(""" MERGE (p:Person {id: $id}) SET p.name = $name, p.age = $age """, { 'id': person_id, 'name': f"Person_{person_id}", 'age': random.randint(18, 80) })) </code></pre></div> <h4 id="run-load-test" class="position-relative d-flex align-items-center group"> Run Load Test <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="run-load-test" aria-haspopup="dialog" aria-label="Share link: Run Load Test"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Run with web UI locust -f locustfile.py --host=localhost:3141 # Run headless (100 users, 10 users/sec spawn rate, 5 min) locust -f locustfile.py \ --host=localhost:3141 \ --users 100 \ --spawn-rate 10 \ --run-time 5m \ --headless # Generate report locust -f locustfile.py \ --host=localhost:3141 \ --users 500 \ --spawn-rate 50 \ --run-time 10m \ --headless \ --html report.html </code></pre></div> <h4 id="interpret-locust-results" class="position-relative d-flex align-items-center group"> Interpret Locust Results <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="interpret-locust-results" aria-haspopup="dialog" aria-label="Share link: Interpret Locust Results"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">Name # Requests # Fails Avg Min Max Median RPS Failures/s ---------------------------------------------------------------------------------------- POST /query/read_person 7000 0 5 2 45 4 116.7 0.0 POST /query/search_age 2000 0 8 3 62 7 33.3 0.0 POST /query/create_person 1000 0 12 4 98 10 16.7 0.0 ---------------------------------------------------------------------------------------- Aggregated 10000 0 6 2 98 5 166.7 0.0 </code></pre></div>Key Metrics: <ul> <li>RPS: Requests per second (throughput)</li> <li>Avg/Median: Average and median latency</li> <li>Max: Worst-case latency (outliers)</li> <li>Failures: Error rate</li> <li>P95/P99: 95th and 99th percentile latency</li> </ul> <h3 id="monitoring--profiling" class="position-relative d-flex align-items-center group"> Monitoring &amp; Profiling <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="monitoring--profiling" aria-haspopup="dialog" aria-label="Share link: Monitoring &amp; Profiling"> Share link </button> </h3> <h4 id="prometheus-metrics" class="position-relative d-flex align-items-center group"> Prometheus Metrics <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="prometheus-metrics" aria-haspopup="dialog" aria-label="Share link: Prometheus Metrics"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Query Prometheus metrics endpoint curl http://localhost:9090/metrics # Key metrics: # - geode_query_duration_seconds (histogram) # - geode_query_total (counter) # - geode_connections_active (gauge) # - geode_storage_page_cache_hit_rate (gauge) # - geode_index_lookups_total (counter) </code></pre></div> <h4 id="grafana-dashboards" class="position-relative d-flex align-items-center group"> Grafana Dashboards <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="grafana-dashboards" aria-haspopup="dialog" aria-label="Share link: Grafana Dashboards"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># Import Geode dashboard { "dashboard": { "title": "Geode Performance", "panels": [ { "title": "Query Latency (P95)", "targets": [ { "expr": "histogram_quantile(0.95, geode_query_duration_seconds)" } ] }, { "title": "Throughput (Queries/sec)", "targets": [ { "expr": "rate(geode_query_total[1m])" } ] }, { "title": "Cache Hit Rate", "targets": [ { "expr": "geode_storage_page_cache_hit_rate" } ] } ] } } </code></pre></div> <h4 id="system-monitoring" class="position-relative d-flex align-items-center group"> System Monitoring <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="system-monitoring" aria-haspopup="dialog" aria-label="Share link: System Monitoring"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># CPU usage top -p $(pgrep geode) # Memory usage ps aux | grep geode # I/O statistics iostat -x 1 # Network bandwidth iftop -i eth0 # Continuous monitoring watch -n 1 'ps aux | grep geode | head -1' </code></pre></div> <h3 id="benchmark-scenarios" class="position-relative d-flex align-items-center group"> Benchmark Scenarios <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="benchmark-scenarios" aria-haspopup="dialog" aria-label="Share link: Benchmark Scenarios"> Share link </button> </h3> <h4 id="scenario-1-oltp-workload" class="position-relative d-flex align-items-center group"> Scenario 1: OLTP Workload <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="scenario-1-oltp-workload" aria-haspopup="dialog" aria-label="Share link: Scenario 1: OLTP Workload"> Share link </button> </h4>Characteristics: High concurrency, short transactions, mixed read/write <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># OLTP benchmark from locust import User, task, between from geode_client import Client import asyncio import random import time class BaseGeodeUser(User): wait_time = between(0.01, 0.1) def on_start(self): self.loop = asyncio.new_event_loop() asyncio.set_event_loop(self.loop) self.client = Client(host="localhost", port=3141) self.conn = self.loop.run_until_complete(self.client.connect()) def on_stop(self): self.loop.run_until_complete(self.conn.close()) self.loop.close() def _run(self, coro): return self.loop.run_until_complete(coro) class OLTPUser(BaseGeodeUser): wait_time = between(0.01, 0.1) # Very short wait @task(weight=50) def read_account(self): account_id = random.randint(1, 100000) self._run(self.conn.query(""" MATCH (a:Account {id: $id}) RETURN a.balance """, {'id': account_id})) @task(weight=30) def transfer_funds(self): from_id = random.randint(1, 100000) to_id = random.randint(1, 100000) amount = random.randint(10, 1000) self._run(self.conn.begin()) try: self._run(self.conn.query(""" MATCH (from:Account {id: $from_id}) SET from.balance = from.balance - $amount """, {'from_id': from_id, 'amount': amount})) self._run(self.conn.query(""" MATCH (to:Account {id: $to_id}) SET to.balance = to.balance + $amount """, {'to_id': to_id, 'amount': amount})) self._run(self.conn.commit()) except Exception: self._run(self.conn.rollback()) raise @task(weight=20) def get_balance_history(self): account_id = random.randint(1, 100000) self._run(self.conn.query(""" MATCH (a:Account {id: $id})-[:TRANSACTION]->(t:Transaction) WHERE t.timestamp > $start_time RETURN t ORDER BY t.timestamp DESC LIMIT 10 """, {'id': account_id, 'start_time': int(time.time()) - 86400})) </code></pre></div> <h4 id="scenario-2-graph-analytics" class="position-relative d-flex align-items-center group"> Scenario 2: Graph Analytics <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="scenario-2-graph-analytics" aria-haspopup="dialog" aria-label="Share link: Scenario 2: Graph Analytics"> Share link </button> </h4>Characteristics: Complex traversals, aggregations, analytical queries <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Analytics benchmark class AnalyticsUser(BaseGeodeUser): wait_time = between(1, 3) # Longer wait for analytical queries @task(weight=40) def find_influencers(self): """PageRank-style influence analysis""" self._run(self.conn.query(""" MATCH (p:Person)-[:FOLLOWS]->(other:Person) WITH other, count(p) AS follower_count RETURN other.name, follower_count ORDER BY follower_count DESC LIMIT 20 """)) @task(weight=30) def community_detection(self): """Find communities""" self._run(self.conn.query(""" CALL graph.louvain('SocialNetwork', { relationship_type: 'FOLLOWS' }) YIELD node, community RETURN community, count(node) AS size ORDER BY size DESC """)) @task(weight=30) def shortest_path(self): """Find connection between random users""" user1 = random.randint(1, 1000) user2 = random.randint(1, 1000) self._run(self.conn.query(""" MATCH (a:Person {id: $id1}), (b:Person {id: $id2}), path = shortestPath((a)-[:FOLLOWS*]-(b)) RETURN length(path) AS degrees_of_separation """, {'id1': user1, 'id2': user2})) </code></pre></div> <h4 id="scenario-3-vector-search" class="position-relative d-flex align-items-center group"> Scenario 3: Vector Search <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="scenario-3-vector-search" aria-haspopup="dialog" aria-label="Share link: Scenario 3: Vector Search"> Share link </button> </h4>Characteristics: Embedding-based similarity search <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"># Vector search benchmark from sentence_transformers import SentenceTransformer model = SentenceTransformer('all-MiniLM-L6-v2') class VectorSearchUser(BaseGeodeUser): wait_time = between(0.1, 0.5) @task def semantic_search(self): """Find similar products""" # Random query queries = [ "wireless headphones", "running shoes", "laptop computer", "smart watch", "camera lens" ] query_text = random.choice(queries) query_vec = model.encode(query_text).tolist() self._run(self.conn.query(""" MATCH (p:Product) WHERE vector_distance_cosine(p.embedding, $query_vec) < 0.5 RETURN p.name, vector_distance_cosine(p.embedding, $query_vec) AS similarity ORDER BY similarity ASC LIMIT 10 """, {'query_vec': query_vec})) </code></pre></div> <h3 id="performance-tuning" class="position-relative d-flex align-items-center group"> Performance Tuning <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="performance-tuning" aria-haspopup="dialog" aria-label="Share link: Performance Tuning"> Share link </button> </h3> <h4 id="configuration-optimization" class="position-relative d-flex align-items-center group"> Configuration Optimization <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="configuration-optimization" aria-haspopup="dialog" aria-label="Share link: Configuration Optimization"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># geode.yaml - High-performance configuration storage: page_cache_size: '16GB' # 50-70% of RAM for read-heavy page_size: 16384 # Larger pages for sequential access wal_buffer_size: '64MB' wal_sync_interval: '500ms' # Balance durability vs performance optimizer: enabled: true statistics: auto_update: true update_interval: '30m' server: max_connections: 20000 connection_timeout: '60s' </code></pre></div> <h4 id="index-tuning" class="position-relative d-flex align-items-center group"> Index Tuning <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="index-tuning" aria-haspopup="dialog" aria-label="Share link: Index Tuning"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Ensure appropriate indexes exist SHOW INDEXES; -- Create composite indexes for common query patterns CREATE INDEX user_city_age_idx ON User(city, age) USING btree; -- Update statistics for accurate query planning ANALYZE User; </code></pre></div> <h3 id="benchmark-best-practices" class="position-relative d-flex align-items-center group"> Benchmark Best Practices <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="benchmark-best-practices" aria-haspopup="dialog" aria-label="Share link: Benchmark Best Practices"> Share link </button> </h3> <h4 id="dos" class="position-relative d-flex align-items-center group"> Do&rsquo;s <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="dos" aria-haspopup="dialog" aria-label="Share link: Dos"> Share link </button> </h4>✅ Warmup: Run queries multiple times before measuring ✅ Isolate: Close other applications during benchmarking ✅ Consistent: Use same hardware and configuration ✅ Realistic: Use production-like data volumes ✅ Monitor: Track system resources (CPU, memory, I/O) ✅ Document: Record all configuration parameters ✅ Repeat: Run multiple iterations for statistical significance <h4 id="donts" class="position-relative d-flex align-items-center group"> Don&rsquo;ts <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="donts" aria-haspopup="dialog" aria-label="Share link: Donts"> Share link </button> </h4>❌ Don’t benchmark on shared/virtualized hardware ❌ Don’t use trivial datasets (test with realistic size) ❌ Don’t ignore cache warmup effects ❌ Don’t benchmark with debug builds (use release builds) ❌ Don’t test a single query (use representative workload) ❌ Don’t ignore system resource contention <h3 id="interpreting-results" class="position-relative d-flex align-items-center group"> Interpreting Results <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="interpreting-results" aria-haspopup="dialog" aria-label="Share link: Interpreting Results"> Share link </button> </h3> <h4 id="latency-percentiles" class="position-relative d-flex align-items-center group"> Latency Percentiles <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="latency-percentiles" aria-haspopup="dialog" aria-label="Share link: Latency Percentiles"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">P50 (median): 5ms - Half of requests faster than this P95: 15ms - 95% of requests faster than this P99: 50ms - 99% of requests faster than this P999: 200ms - 99.9% of requests faster than this Max: 1000ms - Worst-case outlier </code></pre></div>Good Performance: <ul> <li>P50 < 10ms</li> <li>P95 < 50ms</li> <li>P99 < 100ms</li> <li>Max < 1000ms</li> </ul> <h4 id="throughput-analysis" class="position-relative d-flex align-items-center group"> Throughput Analysis <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="throughput-analysis" aria-haspopup="dialog" aria-label="Share link: Throughput Analysis"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gdscript3" data-lang="gdscript3">Throughput: 10,000 queries/sec Analysis: - Peak rate: 12,000 queries/sec - Sustained rate: 10,000 queries/sec - Degradation under load: 5% - Recommendation: Provision for 15,000 queries/sec (50% headroom) </code></pre></div> <h4 id="resource-utilization" class="position-relative d-flex align-items-center group"> Resource Utilization <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="resource-utilization" aria-haspopup="dialog" aria-label="Share link: Resource Utilization"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gdscript3" data-lang="gdscript3">CPU: 60% average, 85% peak Memory: 12GB / 32GB (38%) Disk: 200 IOPS (40% of SSD capacity) Network: 500 Mbps (5% of 10Gbps link) Bottleneck: None identified Recommendation: Current hardware adequate for 2x load </code></pre></div> <h3 id="next-steps" class="position-relative d-flex align-items-center group"> Next Steps <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="next-steps" aria-haspopup="dialog" aria-label="Share link: Next Steps"> Share link </button> </h3><ul> <li><a href="/docs/performance/" >Performance Tuning</a> - Optimization techniques</li> <li><a href="/docs/tutorials/indexing-tutorial/" >Indexing Tutorial</a> - Index optimization</li> <li><a href="/docs/query/performance-tuning/" >Query Optimization</a> - Query tuning</li> <li><a href="/docs/architecture/performance-and-scaling/" >Architecture Guide</a> - Scaling strategies</li> </ul> <h3 id="references" class="position-relative d-flex align-items-center group"> References <button type="button" class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1" data-share-target="references" aria-haspopup="dialog" aria-label="Share link: References"> Share link </button> </h3><ul> <li><a href="/docs/configuration/server-configuration/" >Server Configuration</a> - Configuration options</li> <li><a href="/docs/ops/observability/" >Monitoring</a> - Prometheus and Grafana setup</li> <li><a href="/docs/guides/testing-strategies/" >Testing Strategies</a> - Testing approaches</li> </ul> <hr> License: Apache License 2.0 Copyright: 2024-2025 CodePros Last Updated: January 2026