Wpml and WPML String Translation database slow query problem

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.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	12:00 – 14:00	12:00 – 14:00	12:00 – 14:00	12:00 – 14:00	12:00 – 14:00	-
-	17:00 – 21:00	17:00 – 21:00	17:00 – 21:00	17:00 – 21:00	17:00 – 21:00	-

Supporter timezone: Europe/Vienna (GMT+02:00)

This topic contains 3 replies, has 0 voices.

Last updated by Bigul 2 months, 4 weeks ago.

Assisted by: Bigul.

Author	Posts
May 14, 2025 at 2:03 pm #17032688
tornikeS	Background of the issue: I am experiencing a database overload issue with the WPML plugin on my website hidden link. We have tested various solutions including increasing server specifications, changing to the default theme, turning off WPML, cleaning the wp_icl_strings table, and disabling WP Rocket. The issue persists, and it started about a week ago. WPML String Translation and WPML plugins seem to be causing the server overload. I have attached the queries that are consistently running and overloading the database. Symptoms: The database is overloaded to 100% when WPML is active, causing server errors. Questions: What should we do to resolve the database overload issue caused by WPML? Why is WPML automatically and consistently running certain queries that overload the database?
May 15, 2025 at 7:07 am #17035195
tornikeS	The problem was not fixed, there are still slow queries.
May 15, 2025 at 10:34 am #17036348
tornikeS	WPML slow cpu and database
May 15, 2025 at 2:59 pm #17037563
Bigul WPML Supporter since 01/2013 Languages: English (English ) Timezone: Europe/Vienna (GMT+02:00)	Hello, Thank you for the updates. Generally, the number of queries generated by WPML depends on the size of your database, particularly the wp_posts and wp_postmeta tables. In some cases, a high number of queries may also result from compatibility issues with other plugins or themes. Could you please let us know the current size of your database, especially the wp_posts and wp_postmeta tables? In the meantime, please try the workaround suggested in the following errata, but make sure to take a full site backup before proceeding. https://wpml.org/errata/reducing-size-of-icl_translate_job-icl_translate-and-other-wpml-tables/ Let us know if you notice any difference in the results after applying the workaround. -- Thanks! Bigul

The topic ‘[Closed] Wpml and WPML String Translation database slow query problem’ is closed to new replies.