analyze table before cutover by wangzihuacool · Pull Request #1419 · github/gh-ost
Related issue: #1418
Description:
analyze ghost table before cutover to avoid table statistics not timely updated.
When the modified table is a partition table, the execution time of the ANALYZE command will increase as the number of partitions increases. When the ANALYZE statement is synchronized to the replica, it may cause replication lag.
When the ANALYZE statement is synchronized to the replica, it may cause replication lag.
Maybe make this feature a optional flag then? What do you think @timvaillancourt ?
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others. Learn more.
👍
When the modified table is a partition table, the execution time of the ANALYZE command will increase as the number of partitions increases. When the ANALYZE statement is synchronized to the replica, it may cause replication lag.
@meiji163 considering this (I didn't think of it) I suggest this is an optional flag for now and we can have opt-in users report on performance
@wangzihuacool can you add an optional flag and doc/command-line-flags.md update for this one?
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters