Tag

database logs

0 views collected around this technical thread.

Sanyou's Java Diary
Sanyou's Java Diary
Jul 3, 2023 · Databases

Master MySQL Internals: Architecture, Logs, and Recovery Explained

This article walks through MySQL's three‑layer logical architecture, explains the roles of redo, undo, bin, and relay logs, shows how they ensure crash‑safety and point‑in‑time recovery, and provides practical commands for inspecting and configuring these logs.

InnoDBMySQLReplication
0 likes · 18 min read
Master MySQL Internals: Architecture, Logs, and Recovery Explained
Aikesheng Open Source Community
Aikesheng Open Source Community
May 25, 2023 · Databases

Analyzing Slow Queries in OceanBase: Log‑Based Diagnosis and Performance Optimization

This article consolidates practical experience and author insights to guide OceanBase engineers in quickly diagnosing and resolving slow‑SQL performance issues by leveraging ODP and OBServer logs, key metrics, and systematic analysis steps.

OBproxyOceanBaseSQL Optimization
0 likes · 15 min read
Analyzing Slow Queries in OceanBase: Log‑Based Diagnosis and Performance Optimization
Ops Development Stories
Ops Development Stories
Jul 1, 2021 · Databases

Understanding Database Write-Ahead Logs (WAL) and Their Implementation in etcd

This article explains common database logging mechanisms such as MySQL redo logs and binlogs, compares them with Redis AOF and etcd's Raft‑based WAL, and provides an in‑depth analysis of etcd's WAL source code, including key structures, creation process, record types, encoding, and file pipeline management.

GoRaftWAL
0 likes · 18 min read
Understanding Database Write-Ahead Logs (WAL) and Their Implementation in etcd
macrozheng
macrozheng
Jan 29, 2021 · Databases

Understanding MySQL’s Logical Architecture and Its Crucial Logs

This article explains MySQL's three‑layer logical architecture, the roles of redo, undo, and binary logs, how they interact with the buffer pool and crash recovery, and provides practical commands for managing slow query, general, and error logs.

MySQLPerformance TuningStorage Engine
0 likes · 18 min read
Understanding MySQL’s Logical Architecture and Its Crucial Logs