I’m encountering the same issue on two of my websites after today’s plugin auto-update. Both sites have ample PHP memory available for demanding tasks, so I suspect the problem might be related to the latest release.
For context, both websites have databases with around 80,000 users. The scripts in question are already using 720MB of memory, which is quite significant for a single script. The issue seems to be noticeable with the query:
SELECT user_id, meta_key, meta_value FROM wp_usermeta WHERE user_id IN (XXX)
Where XXX includes what seems to be all user IDs in the database. This query causes a significant slowdown in MySQL performance. Any insights or similar experiences would be appreciated.