https://www.memcp.org/index.php?action=history&feed=atom&title=Dashboard_and_Operations 2026-10-09T23:56:44Z Revision history for this page on the wiki MediaWiki 1.39.1 https://www.memcp.org/index.php?title=Dashboard_and_Operations&diff=300&oldid=prev 2026-08-28T09:59:18Z

<p>Refresh MemCP documentation: accuracy, operational guidance, performance profile and maintained API reference</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:59, 28 August 2026</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">The </del>&lt;<del style="font-weight: bold; text-decoration: none;">code</del>&gt;<del style="font-weight: bold; text-decoration: none;">/dashboard</del>&lt;<del style="font-weight: bold; text-decoration: none;">/code</del>&gt; <del style="font-weight: bold; text-decoration: none;">interface provides CPU/memory/request metrics, database and table browsing, shard/compression details, SQL/Scheme consoles, users and grants, runtime settings, process inspection, service state, </del>and <del style="font-weight: bold; text-decoration: none;">configured logs.</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&lt;<ins style="font-weight: bold; text-decoration: none;">!-- Copyright (C) 2026 Carl-Philip Haensch --</ins>&gt;</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>&lt;<ins style="font-weight: bold; text-decoration: none;">!-- SPDX-License-Identifier: GPL-3.0-or-later --</ins>&gt;</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">= Dashboard </ins>and <ins style="font-weight: bold; text-decoration: none;">Operations =</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&lt;code&gt;<del style="font-weight: bold; text-decoration: none;">SHOW [FULL] PROCESSLIST</del>&lt;/code&gt;, <del style="font-weight: bold; text-decoration: none;">dashboard process controls</del>, <del style="font-weight: bold; text-decoration: none;">&lt;code&gt;KILL QUERY&lt;/code&gt;</del>, and <del style="font-weight: bold; text-decoration: none;">&lt;code&gt;KILL CONNECTION&lt;/code&gt; expose </del>active <del style="font-weight: bold; text-decoration: none;">work </del>and <del style="font-weight: bold; text-decoration: none;">cancellation. Graceful shutdown stops new requests and waits up to &lt;code&gt;ShutdownDrainSeconds&lt;/code&gt; for in-flight work</del>.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">The built-in </ins>&lt;code&gt;<ins style="font-weight: bold; text-decoration: none;">/dashboard</ins>&lt;/code&gt; <ins style="font-weight: bold; text-decoration: none;">interface brings together the operational views needed to understand a running MemCP instance: CPU and memory metrics</ins>, <ins style="font-weight: bold; text-decoration: none;">requests, databases and tables, shard and compression details</ins>, <ins style="font-weight: bold; text-decoration: none;">SQL and Scheme consoles</ins>, <ins style="font-weight: bold; text-decoration: none;">users </ins>and <ins style="font-weight: bold; text-decoration: none;">grants, runtime settings, </ins>active <ins style="font-weight: bold; text-decoration: none;">processes, service state, </ins>and <ins style="font-weight: bold; text-decoration: none;">configured logs</ins>.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">Optional &lt;code&gt;MetricsTracing&lt;/code&gt; writes periodic samples. &lt;code&gt;ErrorQueryLog&lt;/code&gt; </del>and <del style="font-weight: bold; text-decoration: none;">&lt;code&gt;PrintLog&lt;/code&gt; store failed SQL and Scheme print/time output with configurable retention limits. These logs may contain SQL text or application data; restrict access and set appropriate limits.</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">== Inspecting </ins>and <ins style="font-weight: bold; text-decoration: none;">stopping work ==</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Protect the dashboard with a <del style="font-weight: bold; text-decoration: none;">strong password </del>and network controls. <del style="font-weight: bold; text-decoration: none;">Do </del>not <del style="font-weight: bold; text-decoration: none;">use it as </del>a <del style="font-weight: bold; text-decoration: none;">substitute </del>for backups, external health checks, alerting, or <del style="font-weight: bold; text-decoration: none;">backend monitoring</del>. <del style="font-weight: bold; text-decoration: none;">Watch memory budgets</del>, <del style="font-weight: bold; text-decoration: none;">errors</del>, <del style="font-weight: bold; text-decoration: none;">active requests, WAL/rebuild behavior, remote-storage latency</del>, and <del style="font-weight: bold; text-decoration: none;">restart validation</del>.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Use &lt;code&gt;SHOW PROCESSLIST&lt;/code&gt; or &lt;code&gt;SHOW FULL PROCESSLIST&lt;/code&gt; from SQL to inspect current connections and queries. &lt;code&gt;KILL QUERY&lt;/code&gt; cancels a running statement while leaving its connection available; &lt;code&gt;KILL CONNECTION&lt;/code&gt; closes the session. The dashboard exposes the same operational controls.</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Cancellation is cooperative. A query must reach a cancellation-aware planner or storage boundary before it stops. During graceful shutdown MemCP rejects new work and waits up to &lt;code&gt;ShutdownDrainSeconds&lt;/code&gt; for in-flight requests.</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">== Metrics and logs ==</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Optional &lt;code&gt;MetricsTracing&lt;/code&gt; records periodic runtime samples. &lt;code&gt;ErrorQueryLog&lt;/code&gt; stores failed SQL and &lt;code&gt;PrintLog&lt;/code&gt; captures Scheme print/time output; both have configurable retention limits. Because SQL text, parameters, identifiers, or application data can occur in these logs, restrict access and choose limits appropriate to the workload.</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Monitor at least:</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* current memory use versus total and persistent-data budgets;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* eviction and cold-column reload activity;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* active and failed requests, latency, and cancellations;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* WAL, rebuild, checkpoint, and restart behavior;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* local or remote storage latency and errors;</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* connection count and long-running transactions.</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">== Production boundaries ==</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Protect the dashboard with <ins style="font-weight: bold; text-decoration: none;">strong credentials, TLS at </ins>a <ins style="font-weight: bold; text-decoration: none;">trusted proxy, </ins>and network controls. <ins style="font-weight: bold; text-decoration: none;">It is an inspection surface, </ins>not a <ins style="font-weight: bold; text-decoration: none;">replacement </ins>for backups, external health checks, alerting<ins style="font-weight: bold; text-decoration: none;">, capacity planning</ins>, or <ins style="font-weight: bold; text-decoration: none;">restore tests</ins>. <ins style="font-weight: bold; text-decoration: none;">See [[Settings]]</ins>, <ins style="font-weight: bold; text-decoration: none;">[[Security and Authentication]]</ins>, <ins style="font-weight: bold; text-decoration: none;">[[Memory Management and Eviction]]</ins>, and <ins style="font-weight: bold; text-decoration: none;">[[Performance Measurement]]</ins>.</div></td></tr> <!-- diff cache key memcp_wiki-mediawiki-:diff::1.12:old-268:rev-300 --> </table>

Wikiservice https://www.memcp.org/index.php?title=Dashboard_and_Operations&diff=268&oldid=prev 2026-08-21T11:04:48Z

<p>Created page with &quot;The &lt;code&gt;/dashboard&lt;/code&gt; interface provides CPU/memory/request metrics, database and table browsing, shard/compression details, SQL/Scheme consoles, users and grants, runtime settings, process inspection, service state, and configured logs. &lt;code&gt;SHOW [FULL] PROCESSLIST&lt;/code&gt;, dashboard process controls, &lt;code&gt;KILL QUERY&lt;/code&gt;, and &lt;code&gt;KILL CONNECTION&lt;/code&gt; expose active work and cancellation. Graceful shutdown stops new requests and waits up to &lt;code&gt;ShutdownDr...&quot;</p> <p><b>New page</b></p><div>The &lt;code&gt;/dashboard&lt;/code&gt; interface provides CPU/memory/request metrics, database and table browsing, shard/compression details, SQL/Scheme consoles, users and grants, runtime settings, process inspection, service state, and configured logs.<br /> <br /> &lt;code&gt;SHOW [FULL] PROCESSLIST&lt;/code&gt;, dashboard process controls, &lt;code&gt;KILL QUERY&lt;/code&gt;, and &lt;code&gt;KILL CONNECTION&lt;/code&gt; expose active work and cancellation. Graceful shutdown stops new requests and waits up to &lt;code&gt;ShutdownDrainSeconds&lt;/code&gt; for in-flight work.<br /> <br /> Optional &lt;code&gt;MetricsTracing&lt;/code&gt; writes periodic samples. &lt;code&gt;ErrorQueryLog&lt;/code&gt; and &lt;code&gt;PrintLog&lt;/code&gt; store failed SQL and Scheme print/time output with configurable retention limits. These logs may contain SQL text or application data; restrict access and set appropriate limits.<br /> <br /> Protect the dashboard with a strong password and network controls. Do not use it as a substitute for backups, external health checks, alerting, or backend monitoring. Watch memory budgets, errors, active requests, WAL/rebuild behavior, remote-storage latency, and restart validation.</div>

Carli