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.

50 canonical articlesBrowse the complete archive

Popular Searches

MySQL Articles

← Clear filter

Showing 12 of 50 articles

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.

MySQL9 minNov 17, 2025
Read

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.

MySQL1 minNov 10, 2025
Read

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.

MySQL5 minOct 27, 2025
Read

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.

MySQL5 minOct 22, 2025
Read

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.

MySQL4 minOct 21, 2025
Read

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.

MySQL8 minOct 13, 2025
Read

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.

MySQL5 minSep 12, 2025
Read

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.

MySQL1 minAug 20, 2025
Read

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.

MySQL5 minAug 4, 2025
Read

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.

MySQL10 minJul 15, 2025
Read

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.

MySQL4 minJul 4, 2025
Read

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.

MySQL8 minMay 12, 2025
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