I've been trying to find the answer to this online for a while with no luck.
What are possible downsides or consequences to running an alter (such as add index, add column, drop index, drop column) with
ALGORITHM=INPLACE, LOCK=NONE in mysql 8.0 innodb?
I figure there have to be some concerns or situations where you would not want to use
LOCK=NONE at least.
If new rows are being added to the table as you run the alter to add an index, is it possible that some indexes wouldn't be created? I'm just wondering if I should be concerned about using these for all alters I run.