MySQLでIN句の中にたくさんの値を設定した場合、5.7→8.0で大きく性能劣化が発生しているらしい。現在MySQL側で調査中。MariaDBはどうだろう。
---
Why Are Queries with Many IN Values More Expensive After Upgrading to MySQL 8.x?
https://www.percona.com/blog/why-are-queries-with-many-in-values-more-expensive-after-upgrading-to-mysql-8-x/
#bookmarks