OptimizeTable

Qunar Tech Salon

Oct 30, 2015 · Databases

MySQL Partitioning Hash Changes, GTID Replication Bugs, Client Crash, and TokuDB Optimize Table Analysis

This article examines how differing key‑hash algorithms in MySQL 5.1 versus 5.5/5.6 cause data loss in partitioned tables, describes compatibility fixes with ALTER TABLE … ALGORITHM=1, analyzes a MySQL client crash caused by mis‑redirected dump output, explores GTID_PURGED replication issues and replicate‑do‑db filtering gaps, and evaluates the behavior of OPTIMIZE TABLE on TokuDB tables.