[GitHub] [airflow] potiuk commented on issue #27082: Airflow database migration fails in MySQL group replication mode

[GitBox <gi...@apache.org>]

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: commits-unsubscribe@airflow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org