Our web host recently wrote to us to ask us to change hosting because the site is overloading their server. When they checked our server to find out why it was under a high load, we found that there were over 80 individual PHP processes running for the site, and also over 80 MySQL processes that were in use. This is extremely high usage, and is not normal for most sites.
We installed Query Monitor on a staging website (hidden link) and we always have at least 93 duplicate queries. (see screenshot).
If I visit the Global Option Page for example - here is what I have
INSERT IGNORE INTO wp_options ( option_name, option_value, autoload )
VALUES ('wpml.WPML\\TM\\Settings\\ProcessNewTranslatableFields.lock', '1714516172', 'no') /* LOCK */ /* From [sialstaging.wpenginepowered.com/wp-admin/admin.php?page=acf-options-global&message=1&lang=fr&admin_bar=1] in [/nas/content/live/sialstaging/wp-content/plugins/sitepress-multilingual-cms/vendor/wpml/core-api/core/utility/Lock.php:47] */
Thank you for contacting WPML support. While you are waiting for one of my colleagues to take this ticket and work on it, let me provide you with the first debugging steps and try to help with the issue quickly.
This does appear to be the same issue as reported in the known-issue post shared by Drazen, and I'm adding this thread to the internal ticket about the problem, to raise its priority.
I'll let you know when the developers provide an update.
If you try the workaround let me know if it helps.
