Sever writeoperation due to WPML tables

This thread is resolved. Here is a description of the problem and solution.

Problem:
The client's website is not functioning correctly due to a write operation issue with WPML.
Solution:
1. We recommend checking the following ticket for advice on optimizing your website: https://wpml.org/forums/topic/how-can-i-improve-performance-of-a-slow-site/#post-15350474.
2. Ensure that the WordPress REST API is enabled. For more information, visit: https://wpml.org/documentation/support/rest-api-dependencies/.
3. Enable debugging in your wp-config.php file by changing the line to:

define('WP_DEBUG', true);

4. Enable error logging with the following line:

define('WP_DEBUG_LOG', true);

This will save errors to a debug.log file in the /wp-content/directory. For more details, visit: https://wpml.org/documentation/support/debugging-wpml/.
5. Deactivate the WPML CMS Nav plugin temporarily as it should not affect translations.
6. Update your WPML plugin and add-ons to the latest version, 4.7.0, following the instructions here: http://wpml.org/faq/install-wpml/.

If these steps do not resolve your issue or the solution seems outdated, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the problem persists, please open a new support ticket at WPML support forum.

This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Tagged: Exception

This topic contains 5 replies, has 0 voices.

Last updated by Andrey 1 month, 3 weeks ago.

Assisted by: Andrey.

Author	Posts
February 5, 2025 at 6:03 am #16669036
valentinB-22	Background of the issue: I am trying to fix my website, which is not working properly due to a write operation issue related to WPML. Here is the screenshot for reference: hidden link. Symptoms: The website is not functioning correctly due to a write operation issue with WPML. Questions: website is not working properly due to write operation due to WPML, here are the screenshot hidden link please check at your end
February 5, 2025 at 9:33 pm #16673077
Andrey Supporter Languages: English (English ) Russian (Русский ) Timezone: Europe/Kyiv (GMT+03:00)	Thank you for contacting WPML support. To assist you better, could you please provide a detailed explanation of the issue you are encountering? I reviewed the screenshot you sent, and it appears to be fine to me.
February 10, 2025 at 10:27 am #16686377
valentinB-22	I have hosted my website on AWS, and upon analyzing the AWS server metrics, I noticed a high number of write operations. After conducting a detailed investigation, I found that WPML tables are causing delays, as shown in the screenshots. This issue needs to be resolved urgently because the excessive write operations are causing the website to crash frequently, directly impacting my business. I have attached AWS metric screenshots for reference. Please assist in resolving this issue. Here is the screenshot for reference: hidden link. write operation: hidden link hidden link
February 10, 2025 at 2:54 pm #16688261
Andrey Supporter Languages: English (English ) Russian (Русский ) Timezone: Europe/Kyiv (GMT+03:00)	Thank you for contacting WPML support. WPML has made additional requests to the database to enable your site to run smoothly with multiple languages, but this should not cause any noticeable slowdown of your website. Please check the following ticket for advice on how to optimize your website: https://wpml.org/forums/topic/how-can-i-improve-performance-of-a-slow-site/#post-15350474. I noticed from the information you provided that the WordPress REST API is disabled. You need to ensure that it is enabled: https://wpml.org/documentation/support/rest-api-dependencies/. Are there any entries in the debug.log at the time of the crash? To enable debugging, open your wp-config.php file and look for the line that reads `define('WP_DEBUG', false);`. Change it to: define('WP_DEBUG', true); To enable error logging to a file on the server, you'll need to add another line: define('WP_DEBUG_LOG', true); This will save the errors to a debug.log file inside the /wp-content/directory: https://wpml.org/documentation/support/debugging-wpml/. Please let me know what you find in the debug.log after enabling debugging mode.
February 11, 2025 at 7:28 am #16690140
valentinB-22	I have checked WordPress REST API is enable Here is the error of i have found after enabling debugging mode.: hidden link Can you please check at your end.
February 11, 2025 at 9:27 am #16690580
Andrey Supporter Languages: English (English ) Russian (Русский ) Timezone: Europe/Kyiv (GMT+03:00)	Thank you for your feedback. This notice should not cause any issues. However, you can deactivate the WPML CMS Nav plugin for now; the translations will still work without it. Please update your WPML plugin and add-ons to the latest version, 4.7.0, to take advantage of the latest bug fixes and improvements. You can find the most recent versions under "My Account -> Downloads" on this site. Instructions for updating can be found here: http://wpml.org/faq/install-wpml/. If you do not see the updates, you may need to click the "Check for updates" button in the Plugins → Add New Plugin → Commercial tab. Before proceeding, please remember to back up your database.