[Resolved] Database deadlock bringing site down

Problem:
The client is experiencing database deadlocks when WPML is enabled, which floods the error log. Clearing the WPML cache temporarily resolves the issue, and the client inquires about the effectiveness of clearing the cache and the impact of using the Advance Translator over the Classic one.
Solution:
If you're experiencing database deadlocks similar to the ones described, we recommend following the workaround provided in our errata page: https://wpml.org/errata/wpml-causing-backend-slowness-and-duplicated-queries/. Clearing the WPML cache can sometimes help because it removes temporary data that could be causing a bottleneck. As for the translator mode, switching to the Advanced Translator can improve performance as it is optimized for better efficiency.

Please note that the solution provided might be outdated or not applicable to your case. 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: WPML support forum.