细说pt-osc
Flow
Usage
Mark
使用OSC会使增加一倍的空间,包括索引而且在 Row Based Replication 下,还会写一份binlog。不要想当然使用 --set-vars
去设置 sql_log_bin=0
,因为在这个session级别,alter语句也要在从库上执行,除非你对从库另有打算。
Reference
- Title: 细说pt-osc
- Author: Shawn Yan
- Created at: 2018-04-23 16:21:01
- Updated at: 2018-04-23 16:21:01
- Link: https://shawnyan.cn/2018/mysql/pt-osc-detail/
- License: This work is licensed under CC BY-NC-SA 4.0.
Comments