potiuk commented on issue #27082:
URL: https://github.com/apache/airflow/issues/27082#issuecomment-1288346833
Ideally the fix should be to detect if group replication is on and follow
different migration path @tirkarthi.
We should not - for example - disable it for "all mysql".
I think we have to assume that it will be a LOT slower when you have huge
database - and it's rather regardless from the database used (seen this
happening in all of the relational databases). The root cause of the slowness
is that most indexes are some kind of tree structure that have limited size and
they require periodic re-organisations when the table grows. While this is
usually pretty ok if done as the table grows naturally, when you insert many
rows starting from 0, you will very likely hit such re-organisation multiple
times during the insert process and it will get slower and slower as inserts
progress.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
