Dashboard and Operations

From MemCP
Revision as of 13:04, 21 August 2026 by Carli (talk | contribs) (Created page with "The <code>/dashboard</code> 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. <code>SHOW [FULL] PROCESSLIST</code>, dashboard process controls, <code>KILL QUERY</code>, and <code>KILL CONNECTION</code> expose active work and cancellation. Graceful shutdown stops new requests and waits up to <code>ShutdownDr...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

The /dashboard 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.

SHOW [FULL] PROCESSLIST, dashboard process controls, KILL QUERY, and KILL CONNECTION expose active work and cancellation. Graceful shutdown stops new requests and waits up to ShutdownDrainSeconds for in-flight work.

Optional MetricsTracing writes periodic samples. ErrorQueryLog and PrintLog 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.

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.