By - YunYangPosted on 2026-02-06Posted in MySQL【MySQL】日志相关高频问题分享MySQL 的日志系统是保障数据可靠性和主从同步的核心,日常开发和运维中,我们经常会遇到 Redo Log、B Read More
By - YunYangPosted on 2026-02-062026-03-02Posted in MySQL【MySQL】Binlog、Redo Log、Undo Log 区别与实践在 MySQL 数据库中,Binlog(二进制日志)、Redo Log(重做日志)、Undo Log(回滚日志 Read More
By - YunYangPosted on 2026-02-06Posted in MySQL【MySQL】Undo Log 配置实战指南本文基于 MySQL 8.0+ 版本,详解 Undo Log 关键配置参数、优化方案与实操步骤
By - YunYangPosted on 2026-02-05Posted in MySQL【MySQL】Undo Log清理机制(Purge):原理、判断与优化实战在 MySQL InnoDB 存储引擎中,Undo Log 作为事务回滚与 MVCC(多版本并发控制)的核心组 Read More
By - YunYangPosted on 2026-02-05Posted in MySQL【MySQL】Undo Log 深度解析:事务回滚与 MVCC 的底层支柱在 InnoDB 存储引擎中,Undo Log 是保障事务一致性与并发性能的核心组件。它作为「逻辑日志」记录数 Read More
By - YunYangPosted on 2026-02-05Posted in MySQL【MySQL】MySQL 8.0 Redo Log 归档与禁用实战指南MySQL 的 Redo Log 作为保障事务持久性的核心组件,采用「循环写」机制确保性能,但在特定场景下(如 Read More
By - YunYangPosted on 2026-02-05Posted in MySQL【MySQL】Redo Log落盘机制深度解析本文将从参数解析、实验验证、场景选型三个维度,带你彻底掌握 Redo Log 落盘的底层逻辑
By - YunYangPosted on 2026-02-04Posted in MySQL【MySQL】Redo Log 深度解析:从原理到实战,保障事务持久性本文将从原理、核心机制、配置优化到崩溃恢复,全面拆解 Redo Log,帮你彻底搞懂它如何守护数据安全。
By - YunYangPosted on 2026-02-04Posted in MySQL【MySQL】错误日志 Error Log 完全指南:从配置到故障排查实战在 MySQL 数据库运维中,遇到服务启动失败、连接异常、死锁等问题时,错误日志(Error Log)绝对是你 Read More
By - YunYangPosted on 2026-02-04Posted in MySQL【MySQL】慢查询日志 Slow Log :定位低效 SQL在 MySQL 数据库运维中,SQL 语句的执行效率直接影响系统响应速度。当网站出现卡顿、接口超时等问题时,慢 Read More