BestHub
Sign in
Tagged articles

INSTANT

7 articles · Page 1 of 1
IoT Full-Stack Technology
IoT Full-Stack Technology
Aug 17, 2026 · Databases

Does Adding an Index Lock the Table? JD Interview Deep Dive (Full Score Edition)

The article explains that whether adding an index locks a MySQL table depends on the version and DDL algorithm—MySQL 5.5 and earlier lock the whole table, 5.6‑5.7 use Online DDL with brief metadata locks, and 8.0+ can create secondary indexes instantly without locking, while primary, unique, and full‑text indexes always require locking.

COPYINPLACEINSTANT
0 likes · 10 min read
Does Adding an Index Lock the Table? JD Interview Deep Dive (Full Score Edition)
The Dominant Programmer
The Dominant Programmer
Nov 1, 2022 · Fundamentals

Common Java 8 Date and Time APIs: Getting Today’s Date and More

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.

INSTANTJavaJava 8
0 likes · 10 min read
Common Java 8 Date and Time APIs: Getting Today’s Date and More
Programmer DD
Programmer DD
May 7, 2021 · Fundamentals

Master Java 8 Date & Time API: Practical Examples and Tips

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.

INSTANTJavaJava 8
0 likes · 20 min read
Master Java 8 Date & Time API: Practical Examples and Tips
NetEase Game Operations Platform
NetEase Game Operations Platform
Apr 20, 2019 · Databases

Understanding MySQL DDL Algorithms and How to Minimize Their Impact

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.

COPYDDLINPLACE
0 likes · 13 min read
Understanding MySQL DDL Algorithms and How to Minimize Their Impact
dbaplus Community
dbaplus Community
Apr 18, 2019 · Databases

Mastering MySQL DDL: Algorithms, Tools, and Performance Tips

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.

DDLINPLACEINSTANT
0 likes · 15 min read
Mastering MySQL DDL: Algorithms, Tools, and Performance Tips