analyze table before cutover by wangzihuacool · Pull Request #1419 · github/gh-ost

@wangzihuacool

Related issue: #1418

Description:
analyze ghost table before cutover to avoid table statistics not timely updated.

@wangzihuacool

@meiji163

meiji163

@shaohk

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

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 ?

timvaillancourt

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

👍

@timvaillancourt

@timvaillancourt

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?

@Zorgon66

This comment was marked as spam.