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 Shell Dump and Load Utilities vs mydumper

Compare MySQL Shell 26.10 dump and load with mydumper 1.0 on locking, chunking, managed targets, deferred indexes, resume, and GTIDs, with commands for each step.

MySQL17 minNov 7, 2026
Read

MySQL 26.7 and Calendar Versioning: Which MySQL Should You Run Now?

Learn how MySQL 26.7 and 26.10 calendar versions work, how LTS and Innovation tracks differ, which upgrade paths are allowed, and which MySQL version to run in 2026.

MySQL18 minOct 30, 2026
Read

MySQL INSTANT DDL: What Is Instant and What Still Copies the Table

Learn which ALTER TABLE changes are instant on MySQL 8.4 and 9.7, how to make MySQL refuse a silent table copy, and how to avoid metadata lock pileups.

MySQL18 minOct 29, 2026
Read

MySQL Clone Plugin: Provisioning Replicas Without a Backup Restore

Provision a MySQL 8.4 replica with the clone plugin: prerequisites, privileges, DDL and bandwidth settings, progress monitoring, and GTID replication after the clone.

MySQL18 minOct 29, 2026
Read

MySQL Invisible Indexes: Drop an Index Safely

Test an index drop on MySQL 8.4 before you commit to it: find unused candidates on every server, hide one with ALTER INDEX INVISIBLE, compare plans, and drop it with a rollback.

MySQL18 minOct 28, 2026
Read

Upgrading MySQL 8.4 LTS to 9.7 LTS: Path, Checks, and Rollback

Plan a MySQL 8.4 to 9.7 LTS upgrade: the supported path, the 9.0 to 9.6 removals to fix first, the upgrade checker run, a replica-first cutover, and rollback limits.

MySQL19 minOct 22, 2026
Read

MySQL 8.4 Authentication Errors: mysql_native_password and caching_sha2_password Fixes

Fix MySQL 8.4 authentication errors: why mysql_native_password is not loaded, what caching_sha2_password needs, which drivers work, and how to migrate before 9.x.

MySQL20 minOct 21, 2026
Read

MySQL Explained (2026): InnoDB, 8.4 LTS, Replication & Production Patterns

Everything you need to know about MySQL: storage engines, replication topologies, performance tuning, and cloud deployment. From basics to advanced optimization.

MySQL9 minMay 13, 2026
Read

MySQL "Communications Link Failure": Fix wait_timeout, HikariCP & All 8 Timeout Variables

MySQL wait_timeout, net_read_timeout, innodb_lock_wait_timeout and max_execution_time — production tuning rules and the HikariCP alignment trick that prevents 'communications link failure' errors.

MySQL6 minMay 9, 2026
Read

MySQL binlog Retention, Rotation & Purge: Production Guide (2026)

Configure MySQL binlog retention safely: binlog_expire_logs_seconds, manual purging rules, AWS RDS retention, and the disk-exhaustion failure mode you should monitor for.

MySQL10 minMay 9, 2026
Read

MySQL JSON Column Performance: Indexing, Querying, and Schema Design Trade-offs

Understand when MySQL JSON columns help and hurt performance. Learn functional indexes, JSON_TABLE, and when to migrate JSON to normalized columns.

MySQL6 minDec 3, 2025
Read

MySQL Foreign Keys: Evolution from 5.7 to 8.4

MySQL's foreign key implementation has evolved significantly from 5.7 through 8.4 — with changes to metadata locking, instant DDL interactions, and Group Replication behavior that every DBA needs to understand.

MySQL8 minNov 20, 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