Skip to content
Tagged articles

time-zone

8 articles · Page 1 of 1
Cilantro Loves Linux
Cilantro Loves Linux
Nov 2, 2026 · Databases

MySQL Configuration Deep Dive: Character Sets, Collations, Time Zones & SQL Modes with Hands-On Experiments

This tutorial demonstrates MySQL 8.0 configuration of character sets, collations, time zones, and SQL modes through reproducible experiments, showing how connection settings differ from server defaults, how utf8mb4 handles emojis, why TIMESTAMP converts across time zones while DATETIME does not, and how strict SQL mode rejects out-of-range values.

MySQLcharacter-setcollation
0 likes · 20 min read
MySQL Configuration Deep Dive: Character Sets, Collations, Time Zones & SQL Modes with Hands-On Experiments
macrozheng
macrozheng
May 7, 2025 · Backend Development

Mastering Date and Time Handling in Java: Thread Safety, Time Zones, and Performance

This article explores common pitfalls in Java date handling, explains thread‑unsafe SimpleDateFormat issues, demonstrates safe alternatives with ThreadLocal, Java 8 Time API, and zone‑aware calculations, and provides performance‑optimized patterns for high‑throughput applications.

spring-bootthread safetytime-zone
0 likes · 10 min read
Mastering Date and Time Handling in Java: Thread Safety, Time Zones, and Performance
Taobao Frontend Technology
Taobao Frontend Technology
Nov 6, 2024 · Fundamentals

New JavaScript Proposals Transform Error Handling, RegExp, and Binary Data

Several Stage‑3 TC39 proposals—including Error.isError for reliable error type checks, RegExp.escape for safe regex construction, Uint8Array methods for base64/hex conversion, and Temporal.TimeZone.prototype.equals for canonical time‑zone comparison—aim to enhance JavaScript’s core capabilities across browsers and Node.js.

Base64JavaScriptTC39
0 likes · 8 min read
New JavaScript Proposals Transform Error Handling, RegExp, and Binary Data
DataFunSummit
DataFunSummit
May 29, 2024 · Big Data

Best Practices for Building an International Ride‑Hailing Data Metric System at Didi

This article presents Didi's comprehensive approach to designing, implementing, and governing a global data metric system for international ride‑hailing, covering business scenarios, metric‑related challenges, organizational structures, process flows, model architecture, time‑zone handling, tooling, and multi‑level governance.

data metricsinternationalizationride-hailing
0 likes · 15 min read
Best Practices for Building an International Ride‑Hailing Data Metric System at Didi
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 13, 2022 · Databases

Using ClickHouse Materialized Views: Creation, Testing, and Time‑Zone Issue Resolution

This article explains how to create a ClickHouse materialized view that aggregates per‑minute data from a per‑second table, demonstrates insertion and query tests, investigates an unexpected 1970‑01‑01 timestamp caused by time‑zone handling, and provides the corrected view definition aligning field names.

ClickHouseMaterialized Viewdatabase
0 likes · 8 min read
Using ClickHouse Materialized Views: Creation, Testing, and Time‑Zone Issue Resolution
Qunar Tech Salon
Qunar Tech Salon
Aug 1, 2017 · Databases

MySQL Time Zone Setting Causes High CPU and Slow Queries Due to Mutex Contention

A production MySQL incident showed sudden system CPU spikes and many running threads despite low query throughput, which was traced to the server's time_zone=system setting causing timestamp conversion to lock a global mutex, leading to excessive spin‑locks, context switches, and degraded performance that was resolved by changing the time_zone to a fixed offset.

CPUMutexMySQL
0 likes · 6 min read
MySQL Time Zone Setting Causes High CPU and Slow Queries Due to Mutex Contention