By - YunYangPosted on 2026-02-092026-03-02Posted in MySQL【MySQL】备份神器 mydumper:原理、实操与恢复全指南在 MySQL 数据库运维中,备份是数据安全的核心保障。相较于传统的 mysqldump,mydumper 凭 Read More
By - YunYangPosted on 2026-02-072026-03-02Posted in MySQL【MySQL】mysqldump 核心用法详解:12个高频场景与实操指南作为 MySQL 生态中最常用的逻辑备份工具,mysqldump 凭借丰富的参数设计,能灵活应对全库备份、单表 Read More
By - YunYangPosted on 2026-02-06Posted in 阅读与感悟【读书笔记】《被讨厌的勇气》——挣脱心灵的枷锁愿我们都能拥有被讨厌的勇气,在自己的人生道路上,认真起舞,活成喜欢的样子~
By - YunYangPosted on 2026-02-062026-03-02Posted in MySQL【MySQL】逻辑备份工具 mysqldump 工作原理深度剖析在 MySQL 数据库备份场景中,mysqldump 作为经典的逻辑备份工具,凭借跨平台兼容性强、备份文件可读 Read More
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-052026-02-05Posted in 阅读与感悟【读书笔记】《小狗钱钱》:童话里的财富启蒙课《小狗钱钱》既是孩子的理财启蒙书,也是成年人的财务纠错书,用童话讲透了 “普通人如何通过简单方法实现财务自由” 的底层逻辑,值得反复阅读与实践
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