Performance

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
-	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	9:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: America/Los_Angeles (GMT-08:00)

Tagged: Performance

This topic contains 3 replies, has 2 voices.

Last updated by Bobby 7 months, 3 weeks ago.

Assisted by: Bobby.

Author	Posts
July 16, 2024 at 3:18 pm #15961153
sebastianG-75	Background of the issue: We are experiencing very high database load when we enable WPML on our production site hidden link. The hosting company (WP Engine) says that this is related to the following query: SELECT COUNT() FROM wp_comments JOIN wp_icl_translations icltr? ON icltr?.element_id = wp_comments.comment_post_ID JOIN wp_posts ON wp_posts.ID = icltr?.element_id AND CONCAT(?, wp_posts.post_type) = icltr?.element_type LEFT JOIN wp_icl_translations icltr_comment ON icltr_comment.element_id = wp_comments.comment_ID AND icltr_comment.element_type = ? WHERE ( comment_approved = ? ) AND icltr?.language_code = ? AND (icltr_comment.language_code IS NULL OR icltr_comment.language_code = icltr?.language_code ) This is causing the database to fall over and take the site down. At the moment we have had to disable WPML. Symptoms:* High database load causing the site to fall over when WPML is enabled. Questions: Can you please advise on what might be causing this? What can we do to resolve it urgently?
July 16, 2024 at 11:45 pm #15963001
Bobby Supporter Languages: English (English ) Timezone: America/Los_Angeles (GMT-08:00)	Hi there, To be of better help, can you please provide your WPML Debug information in the debug field below? http://wpml.org/faq/provide-debug-information-faster-support/ Meanwhile, if possible also share your error log with me. You can see how to enable debug logging here: https://wpml.org/documentation/support/debugging-wpml/
July 17, 2024 at 2:38 am #15963268
sebastianG-75	[removed]
July 17, 2024 at 9:14 pm #15968554
Bobby Supporter Languages: English (English ) Timezone: America/Los_Angeles (GMT-08:00)	Please try the following first steps: 1. WPML > Languages > Make themes work multilingual disable the Adjust IDs for multilingual functionality setting 2. Go to WPML->Support->Troubleshooting and remove Strings that are not needed https://wpml.org/documentation/getting-started-guide/string-translation/#attachment_9608145 Also while on that screen run the following steps as well "Cleanup and optimize string tables" "Clear invalid strings" "Remove ghost entries from WPML tables" 3. Consider using the plugin Index WP MySQL For Speed Let me know your results, please.

The topic ‘[Closed] Performance’ is closed to new replies.