JusDB
Free DB Audit

The JusDB Database Engineering Blog

Deep dives on PostgreSQL, MySQL, MongoDB and more — performance tuning, high availability, migrations and production war stories from our DBAs.

404 canonical articlesBrowse the complete archive

Popular Searches

Featured Articles

Hand-picked by our editors

Analytics & OLAP· Featured

StarRocks Monitoring & Alerting: The Complete Production Guide

Complete guide to StarRocks monitoring with Prometheus and Grafana. Covers resource saturation, cluster health, and application availability alerts with PromQL expressions and runbooks.

StarRocks14 minMar 24, 2026
Read

Latest Articles

Showing 12 of 404 articles

Valkey vs Memcached in 2026: Threads, Memory Overhead, and When Each Fits

Compare Valkey 9.1 and Memcached 1.6.45 on threading, memory per key, eviction, persistence, replication, and ElastiCache support, then benchmark both with memtier_benchmark.

Redis20 minOct 27, 2026
Read

Valkey Cluster vs Sentinel: Choosing an HA Topology

Decide between Valkey Sentinel and Valkey Cluster on Valkey 9: data size limits, hash tags, numbered databases, client support, failover timing, and a migration runbook.

Redis20 minOct 27, 2026
Read

PostgreSQL Lock Waits: How to Find the Blocking Query and Fix It

Find the session behind a PostgreSQL lock wait with pg_blocking_pids, see why a waiting ALTER TABLE stalls every SELECT, and choose between cancel, terminate, and timeouts.

PostgreSQL18 minOct 27, 2026
Read

PostgreSQL Advisory Locks: Patterns and Pitfalls

Use PostgreSQL advisory locks safely: session vs transaction locks, key choice, singleton jobs, leader election, and the PgBouncer, LIMIT, and lock-table traps.

PostgreSQL18 minOct 27, 2026
Read

PostgreSQL BRIN Indexes for Time-Ordered Tables

Decide when a BRIN index can replace a B-tree on a time-ordered PostgreSQL table: check correlation, choose pages_per_range and an operator class, and roll it out safely.

PostgreSQL18 minOct 26, 2026
Read

PostgreSQL pg_stat_io: Reading I/O by Backend Type

Use pg_stat_io in PostgreSQL 16 to 18 to see whether client backends or the checkpointer do the writes, and to measure ring buffer, vacuum, extend, and WAL I/O.

PostgreSQL18 minOct 26, 2026
Read

MongoDB Change Streams in Production: Resume Tokens and the Oplog Window

Run MongoDB change streams in production: store resume tokens durably, size the oplog window, recover from ChangeStreamHistoryLost, and choose updateLookup or pre-images.

MongoDB19 minOct 25, 2026
Read

MongoDB Oplog Sizing and the Replication Window

Measure your MongoDB oplog window and write churn, find what fills the oplog, size it with a worked example, and resize it safely on every member or on Atlas.

MongoDB17 minOct 25, 2026
Read

ClickHouse Dictionaries: Replacing JOINs with In-Memory Lookups

Replace ClickHouse dimension JOINs with dictionaries: choose a layout, set LIFETIME refresh, use dictGet or a direct JOIN, size memory, and catch failed reloads.

ClickHouse18 minOct 24, 2026
Read

MongoDB WiredTiger Cache Tuning: Eviction, Dirty Data, and Memory Limits

Size the MongoDB WiredTiger cache for VMs and containers, read the eviction thresholds in serverStatus, and decide when to resize the cache and when to fix queries and indexes.

MongoDB19 minOct 24, 2026
Read

SQL Server 2025 for DBAs: Features That Change Day-to-Day Operations

See what SQL Server 2025 changes for DBAs: optimized locking, tempdb caps, ZSTD and immutable backups, AG changes, breaking changes, and a safe compatibility level 170 rollout.

SQL Server19 minOct 23, 2026
Read

OpenSearch on Kubernetes with the OpenSearch Operator

Deploy OpenSearch on Kubernetes with operator 3.0.0: design node pools, size heap against memory limits, set up TLS, run rolling upgrades, and back up to S3.

20 minOct 22, 2026
Read
Newsletter

Get the latest database insights and expert tips delivered to your inbox.

Stay Connected

Subscribe to our RSS feed for instant updates.

RSS Feed