Skip to content

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

Open
@donhcd

Description

@donhcd

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!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions