MySQL Replication Lag and Read-After-Write Consistency in Applications
Quick answer: MySQL replication is asynchronous by default, so a replica can lag behind the source and return stale data. Measure lag with a heartbeat rather...
Category
MySQL
Fixes for connection limits, query performance, and encoding issues in MySQL.
MySQL Online Schema Changes for Large Tables Without Long Locks
Quick answer: InnoDB supports many schema changes online, meaning reads and writes continue during the operation, but the exact behavior depends on the...
MySQL InnoDB Buffer Pool Sizing for Dedicated Database Servers
Quick answer: the InnoDB buffer pool caches table and index pages in memory and is the most important memory setting on a MySQL server. On a dedicated database...
MySQL Binary Logs for Point in Time Recovery Planning
Direct answer: Binary logs can replay changes after a consistent backup to a selected point. The correct decision about mysql binary log recovery requires...
MySQL Foreign Key Cascades and Their Write Lock Implications
Direct answer: Cascade actions can affect many dependent rows in one logical statement. The correct decision about mysql foreign key cascades requires clear...
MySQL EXPLAIN ANALYZE vs EXPLAIN for Query Optimization
Direct answer: EXPLAIN describes optimizer estimates without necessarily executing the query. The correct decision about mysql explain analyze comparison...
MySQL Transaction Isolation and Phantom Reads in Reporting Queries
Direct answer: A report may execute several reads while transactional data changes. Select an approach based on the service's required behavior and a realistic...
MySQL Invisible Indexes for Safe Query Tuning Experiments
Direct answer: Invisible indexes are maintained but generally excluded from optimizer plans. Select an approach based on the service's required behavior and a...
MySQL Generated Columns vs Application Maintained Derived Fields
Direct answer: Generated columns keep derived values tied to database expressions. Select an approach based on the service's required behavior and a realistic...