Performance and High Memory & CPU utilization

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
-	11:00 – 15:00	11:00 – 15:00	11:00 – 15:00	11:00 – 15:00	11:00 – 15:00	-
-	16:00 – 20:00	16:00 – 20:00	16:00 – 20:00	16:00 – 20:00	16:00 – 20:00	-

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

Tagged: Performance

This topic contains 13 replies, has 3 voices.

Last updated by Laura 1 year, 7 months ago.

Assisted by: Laura.

Author	Posts
November 6, 2023 at 7:34 am #14735033
idrisA	We are using WPML for English and Arabic language pages in eShop. After enabling this plugin(s), every ajax call is taking longer time than expected. eventually it is making burden on the servers and memory getting chocked. We ended up with a situation where servers reached 100% utilization. Expecting your support in tuning the performance of this plugin.
November 6, 2023 at 2:07 pm #14738733
Mateus Getulio Supporter Languages: English (English ) Portuguese (Brazil) (Português ) Timezone: America/Sao_Paulo (GMT-03:00)	Hi, Thanks for contacting us. Before your ticket is assigned to one of my colleagues, please allow me to walk you through some initial debugging steps. This will help speed up the support process. We have a dedicated page for performance issue, please read our official documentation in the following link and see if it helps you with the performance issue: https://wpml.org/faq/prevent-performance-issues-with-wpml/ Please give it a check and let us know if you need further assistance. Best,
November 14, 2023 at 7:08 am #14793747
idrisA	Hi, We have very good infra & hosting, dedicated cache mechanism, but WPML plugins utilizing 3 times more resources and memory than expecting, also the execution time of each call is taking 3 to 4 secs. Before activating this plugin, Ajax calls were taking less than a second. due to which the memory being chocked and web servers are going down. Please support to close this performance problem. Please setup a meeting with your experts in this plugin to better understand the problem.
November 14, 2023 at 4:40 pm #14800975
Laura WPML Supporter since 05/2018 Languages: English (English ) Italian (Italiano ) Timezone: Europe/Rome (GMT+02:00)	Hi, I'll take care of the ticket from now on. Sorry, but we don't offer meeting, all the support needs to be done within this forum. Please provide 1. your debug information (https://wpml.org/it/faq/provide-debug-information-faster-support/) 2. your site's credentials or a staging site we can test with 3. some examples for slow Ajax calls
November 16, 2023 at 9:01 am #14823221
idrisA	hi, Our staging site not publicly accessible, here I am attaching the debug information and ajax calls screenshots Debug Info: --------------- [removed]
November 16, 2023 at 11:52 am #14825277
Laura WPML Supporter since 05/2018 Languages: English (English ) Italian (Italiano ) Timezone: Europe/Rome (GMT+02:00)	Please use the box to add the debug info or they're not readable
November 16, 2023 at 11:53 am #14825279
Laura WPML Supporter since 05/2018 Languages: English (English ) Italian (Italiano ) Timezone: Europe/Rome (GMT+02:00)	Also, the screenshot you provided doesn't tell us anything, we need the full request
November 19, 2023 at 5:49 am #14869319
idrisA	Provided the debug information
November 20, 2023 at 11:22 am #14875803
Laura WPML Supporter since 05/2018 Languages: English (English ) Italian (Italiano ) Timezone: Europe/Rome (GMT+02:00)	WordPress and WPML are outdated, please update them as the first thing, then check for slow queries etc. Please note we need some kind of log to work on, a single screenshot saying there's a slow query doesn't tell us anything.
November 27, 2023 at 7:15 am #14926671
idrisA	Dear Team, Please find the slow queries recorded. ------------------------------------------------------------ SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'wp_installer_network' AND site_id = 1; # Time: 2023-11-27T06:55:06.189401Z # Query_time: 1.412289 Lock_time: 0.000095 Rows_sent: 256285 Rows_examined: 256285 SET timestamp=1701068106; SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'wp_installer_network' AND site_id = 1; # Time: 2023-11-27T06:55:06.189408Z # Query_time: 1.453090 Lock_time: 0.000067 Rows_sent: 256285 Rows_examined: 256285 SET timestamp=1701068106; SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'wp_installer_network' AND site_id = 1; # Time: 2023-11-27T06:55:06.189409Z # Query_time: 1.479687 Lock_time: 0.000057 Rows_sent: 256285 Rows_examined: 256285 SET timestamp=1701068106; SELECT meta_value FROM wp_sitemeta WHERE meta_key = 'wp_installer_network' AND site_id = 1; # Time: 2023-11-27T07:08:02.272566Z # Query_time: 2.631139 Lock_time: 0.000165 Rows_sent: 256285 Rows_examined: 256285 SET timestamp=1701068882;
November 27, 2023 at 4:27 pm #14932647
Laura WPML Supporter since 05/2018 Languages: English (English ) Italian (Italiano ) Timezone: Europe/Rome (GMT+02:00)	I sent the ticket to the 2nd tier.
November 28, 2023 at 10:05 am #14937493
Laura WPML Supporter since 05/2018 Languages: English (English ) Italian (Italiano ) Timezone: Europe/Rome (GMT+02:00)	Can you please manually run this query SELECT * FROM wp_sitemeta WHERE meta_key = 'wp_installer_network' AND site_id = 1; and tell me what's the number of row examined?
November 28, 2023 at 12:38 pm #14939323
idrisA	Total number of rows examined : 256241
November 28, 2023 at 2:55 pm #14941107
Laura WPML Supporter since 05/2018 Languages: English (English ) Italian (Italiano ) Timezone: Europe/Rome (GMT+02:00)	The problem here it's the number of rows, WPML can't store that much so this explain the issue. We'd need access to the database (directly or via plugin - we can install it ourself if you provide us with the credentials of the site) to check what's happening and removing them. If this is not possible, we can only suggest you to delete all the entries except the oldest, but we can't guarantee it won't cause other issues.

The topic ‘[Closed] Performance and High Memory & CPU utilization’ is closed to new replies.