This article chronicles a decade of MySQL Online DDL improvements—from the painful COPY operations of 5.5 to the near‑zero‑impact INSTANT algorithm in 8.0—while exposing hidden costs, MDL lock pitfalls, and practical best‑practice checklists for safe schema changes.
This article demonstrates how to use Java 8’s java.time package to obtain the current date and time, extract components, create specific dates, compare dates, handle periodic dates, compute future and past dates, retrieve timestamps, check leap years, calculate differences, and format/parse date strings, with concrete code examples.
This article demonstrates how MySQL 8.0.29’s ALGORITHM=INSTANT enables instant column addition, deletion, and row‑size checks at any position in large tables, compares performance with previous versions, and discusses related XtraBackup backup considerations.
This article introduces Java 8's new date‑time API, explains its advantages over the old java.util.Date and SimpleDateFormat, lists the essential classes such as Instant, LocalDate, LocalTime, ZonedDateTime, and provides step‑by‑step code examples for common operations like getting the current date, manipulating specific dates, handling time zones, and formatting.
This article explains the three MySQL DDL algorithms (COPY, INPLACE, INSTANT), compares third‑party tools like pt‑online‑schema‑change and gh‑ost, and provides practical guidance on selecting algorithms, using ALGORITHM clauses, monitoring progress, and handling performance, space, replication lag, and metadata lock issues.
This article explains the challenges of MySQL DDL on large tables, details the built‑in COPY, INPLACE, and INSTANT algorithms, compares third‑party tools like pt‑online‑schema‑change and gh‑ost, and provides practical guidance on minimizing impact, monitoring progress, and handling metadata locks.
