|
Background of the issue:
Since a week, Tuesday 11th, we are experiencing really high database load.
MySQL CPU load went from around 10% to 99%.
We see that there are a really high number of database queries being run. They all look like: SELECT post_id, meta_value FROM wp_postmeta WHERE meta_key = '_wp_attached_file' AND meta_value = '2024/02/Feedback-for-web-app-email.png' UPDATE `wp_icl_mo_files_domains` SET `domain` = 'default', `status` = 'not_imported', `num_of_strings` = 0, `last_modified` = 1739546835 WHERE `file_path_md5` = '1a45fdb74aa338aa99e43912b8a13f1b'.
We are looking for help in getting these requests under control so we are not maxing out our CPU load constantly.
We have already added the Query Monitor plugin to analyze the queries used, reviewed if there were any WAF rules in place that might have been blocking requests, increased the PHP memory limit to 256M, and updated the plugin and related plugins: WPML Multilingual CMS: 4.7.1, String Translation: 3.3.1, Advanced Custom Fields Multilingual: 2.1.5, WPML SEO 2.1.1.
Symptoms:
High server load due to many queries being fired, causing MySQL CPU load to increase from around 10% to 99%.
Questions:
How can we control the high number of database queries to reduce CPU load?
Are there any specific WPML settings that could help manage database load?
|
