gh-ost icon indicating copy to clipboard operation
gh-ost copied to clipboard

analyze table before cutover

Open wangzihuacool opened this issue 1 year ago • 5 comments

Related issue: #1418

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

wangzihuacool avatar May 23 '24 12:05 wangzihuacool

LGTM

meiji163 avatar May 29 '24 17:05 meiji163

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.

shaohk avatar May 30 '24 02:05 shaohk

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 ?

meiji163 avatar May 30 '24 15:05 meiji163

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?

timvaillancourt avatar Aug 15 '24 22:08 timvaillancourt

👍

Is it all about me? Harun

Zorgon66 avatar Aug 26 '24 21:08 Zorgon66