Handling Slow Queries Without Indexes in gh-ost

[xf97]

Hello, I'm developing a similar tool. Currently, we've encountered an issue where when we use SELECT xxx FROM xxx WHERE xxx to obtain a result set, if there's no index created on the column processed by the WHERE clause, the entire query will become a slow query. I'd like to ask how gh-ost handles this situation. I'm looking forward to your answer.

[meiji163]

The row copy ranges over the unique index that gh-ost chooses. See https://github.com/github/gh-ost/blob/master/doc/shared-key.md for more info