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.
Popular Searches
MySQL InnoDB Buffer Pool: Deep Dive into Pages, Chunks, and Eviction
Master InnoDB buffer pool internals: page management, chunk allocation, LRU algorithm, and tuning strategies for maximum cache efficiency.
MySQL 8.0 Generated Columns: Virtual, Stored, and JSON Index Extraction
Use MySQL 8.0 generated columns to index computed values, JSON paths, and date parts. Covers virtual vs stored tradeoffs and functional index patterns.
MySQL Optimizer Hints: INDEX, JOIN_ORDER, and MAX_EXECUTION_TIME
Guide MySQL query execution with optimizer hints. Covers INDEX, NO_INDEX, JOIN_ORDER, MAX_EXECUTION_TIME, and query block naming for subquery hint targeting.
MySQL 8.0 Window Functions: ROW_NUMBER, LAG, LEAD, and Running Totals
Master MySQL 8.0 window functions for analytical queries. Covers ROW_NUMBER, RANK, LAG/LEAD for period comparison, running totals with SUM OVER, and NTILE quartiles.
MySQL InnoDB Redo Log Tuning: Sizing for Production Write Throughput
The InnoDB redo log default of 100MB is dangerously undersized for production. Learn to measure your write throughput, size innodb_redo_log_capacity correctly, and monitor checkpoint pressure before write stalls occur.
MySQL 8.4 Audit Log Filter: Selective Logging for Compliance
MySQL 8.4's audit log filter system lets you capture exactly the events your compliance framework requires — filtering by user, schema, event class, and severity to reduce audit log volume.
MySQL InnoDB Lock Monitoring: Detecting and Killing Blocking Transactions
Monitor InnoDB lock contention with performance_schema.data_locks, find blocking transactions, kill them safely, and prevent escalation with short transactions and proper timeouts.
MySQL Query Cache Removal: Why It Was Removed and Modern Alternatives
Understand why MySQL removed the query cache in 8.0 and what to use instead: application-level Redis caching, ProxySQL query cache, and pre-computed summary tables.
InnoDB Buffer Pool Tuning: Sizing, Hit Ratio, and Warm-Up Strategies
Size and tune the MySQL 8.4 InnoDB buffer pool from a complete memory budget, measured I/O and latency, safe resize tests, and restart warm-up behavior.
Diagnosing and Fixing MySQL Binlog Replication Failures
MySQL replication errors 1062 and 1032 stop your replica SQL thread silently. Learn to diagnose binlog failures, fix data drift with pt-table-sync, and configure GTID-safe replication.
MySQL JSON Columns: Operators, Generated Column Indexes, and Partial Updates
Use MySQL JSON columns effectively with path operators, functional indexes via generated columns, JSON_CONTAINS filtering, and partial updates with JSON_SET.
Password Management in MySQL 8: Policies, Reuse, and Dual Passwords
MySQL 8 introduced comprehensive password management — password validation policies, reuse history, expiration, and dual passwords for zero-downtime credential rotation.
Get the latest database insights and expert tips delivered to your inbox.
Subscribe to our RSS feed for instant updates.
RSS Feed