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

question: benefits of using gh-ost for building expensive indexes?

Open donhcd opened this issue 9 months ago • 0 comments

hello! I've been playing with gh-ost lately for various reasons and I wanted to check whether it makes sense to use gh-ost to build expensive indexes. Most of what I see is related to schema changes, and I haven't yet found anything about how/whether it helps with building indexes.

Specifically, I'm hoping that setting the chunk-size will allow us to throttle the operations we need to run for the index build at any time. Is this something that will work for index builds? If so, it could be a safer way to run big index builds, even if it has the higher total cost of copying my table first and replicating it

thanks for your help!

donhcd avatar Apr 07 '25 22:04 donhcd