[jmg_]

Does anyone know if the performance regressions between 5.7 and 8.0 have been fixed? I no longer use MySQL regularly so I haven't been following this.

If I recall correctly, this was one of the major reasons why people were deferring this upgrade.

---

> Most notably, we encountered a problem where queries with large WHERE IN clauses would crash MySQL. We had large WHERE IN queries containing over tens of thousands of values.

The need to rewrite queries is mildly concerning. If this was part of their Rails codebase, I'm curious if these patches will make it into the ORM.

[walth]

They have not been fixed, 8.0 is much hungrier for disk io for many query patterns. MariaDB is much better.