Tagged articles
3 articles
Page 1 of 1
Efficient Ops
Efficient Ops
Dec 11, 2023 · Operations

How a Simple System‑Time Change Sparked a Massive Outage

A junior ops engineer mistakenly set the production server clock ahead by a year, causing thousands of user accounts to expire, triggering a large‑scale outage, emergency fixes, financial loss, and harsh career consequences, while highlighting the need for proper permission and change management.

Permissionsdatabaseincident management
0 likes · 7 min read
How a Simple System‑Time Change Sparked a Massive Outage
Aikesheng Open Source Community
Aikesheng Open Source Community
Oct 29, 2021 · Databases

Impact of Adjusting System Time on MySQL Runtime Behavior

The article investigates how changing the operating system clock while MySQL is running influences functions such as SLEEP, metadata lock (MDL) wait calculations, and other timing‑related mechanisms, demonstrating that forward or backward adjustments can cause premature exits or inaccurate wait measurements.

Database Performancelock_wait_timeoutmetadata lock
0 likes · 4 min read
Impact of Adjusting System Time on MySQL Runtime Behavior