细说pt-osc

Shawn Yan Lv.6

2018-04-23 16:21:01 2018-04-23 16:21:01 Created 2018-04-23 16:21:01 2018-04-23 16:21:01 Updated

89 Words 1 Mins

Flow

Usage

Mark

使用OSC会使增加一倍的空间，包括索引而且在 Row Based Replication 下，还会写一份binlog。不要想当然使用 --set-vars 去设置 sql_log_bin=0，因为在这个session级别，alter语句也要在从库上执行，除非你对从库另有打算。

Reference

pt-online-schema-change使用说明、限制与比较

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.

推荐阅读

关于 Percona Toolkit

pt-archiver不会迁移max(id)那条数据的问题

if (hexo-config('comment.enable') == true && hexo-config('comment.system') != "") { if (hexo-config('comment.system') == "waline") { @require "./waline.styl" } else if (hexo-config('comment.system') == "gitalk") { @require "./gitalk.styl" } else if (hexo-config('comment.system') == "twikoo") { @require "./twikoo.styl" } } .comments-container display inline-block margin-top $spacing-unit width 100% #comment-anchor width 100% height 10px .comment-area-title width 100% margin 10px 0 font-size 1.38rem color var(--default-text-color) font-family 'Consolas', '宋体', sans-serif font-weight bold i color var(--default-text-color) +redefine-tablet() margin 5px 0 font-size 1.2rem

On this page

Flow
Usage
Mark
Reference