The JusDB Database Engineering Blog

Choose Redis 8 or Valkey 8 from licensing, feature, managed-service, and operational requirements, then migrate within the documented compatibility boundary.

Master MySQL performance optimization with this comprehensive 2025 guide. Learn expert techniques for query tuning, indexing strategies, memory configuration, and InnoDB optimization to achieve 10x database performance improvements.

MySQL 8.4 LTS introduces production-optimized InnoDB defaults out of the box. Learn new default values, performance implications, and upgrade considerations.

PostgreSQL's pg_stat_activity view exposes every connection's state — but understanding what 'idle in transaction' means and why it's dangerous requires knowing the full lifecycle of a PostgreSQL backend process.

MongoDB's indexing system supports single-field, compound, multikey, text, geospatial, and partial indexes. Choosing the right index type and key order determines whether your queries use microseconds or seconds.

A detailed comparison of PgBouncer, Odyssey, and pgcat for PostgreSQL connection pooling — architecture differences, threading models, pool modes, TLS support, and decision criteria for each workload type.

Compare Elasticsearch, Typesense, and Meilisearch — relevance, speed, operational complexity, and when to use each

How to size your database connection pool correctly — the HikariCP formula, the variables that determine optimal pool size, and the mistakes that cause connection exhaustion or underutilization.

MySQL 8.0 introduced EXPLAIN FORMAT=TREE — a hierarchical, human-readable query plan format that reveals join order, access methods, and cost estimates in a way that the traditional tabular EXPLAIN cannot.

MySQL 8.0 introduced multi-valued indexes — allowing you to index individual elements of a JSON array so queries using MEMBER OF or JSON_OVERLAPS can use an index.

UUIDs as primary keys can destroy database performance. Learn why 50M rows went from 0.5ms to 2.3ms inserts, and how to fix it with hybrid approaches.

Detect query plan regressions in PostgreSQL using auto_explain, pg_hint_plan, and plan baseline management