We would like to seek your help as we are having difficulties creating, saving and publishing certain posts on our site.
By looking at the logs, it appears the queries from WPML are taking long time to process.
The posts (including localization) in question:
Front: hidden link
Back: hidden link
This one specific request appear to be the cause?
WPML_Media_Post_With_Media_Files::_get_ids_from_media_array
--> screenshot01.png and screenshot02.png
Another screen grab displayin process in 10 hour period.
--> screenshot03.png and screenshot04.png
And we are also seeing some slow database queries
--> screenshot05.png
Just earlier today, we've had our site go down temporarily a couple of times due to high CPU and memory usage and slow mysql queries. The main issue was with the two plugins.
It appears that we need to optimize the setting for WPML and would greatly appreciate
if you can help us in the regard.
Another point of interest is whether we can set certain autoload data to NO for WPML?
We are currently at 1.4MB mark for the autoload data, but our hosting company (WP Engine) recommends to keep it below 800K mark for optimal performance.
Please kindly help us identify the problem and the solution to the problem.
We've replicated the production environment to the following environment.
We can also provide logs as well as access to New Relic tool as needed to diagnose the problem
You mentioned that according to your logs WPML Media Translation creates the requests causing the issue.
Are you actually using the WPML Media Translation plugin? Have you translated any images?
You would need to update your WPML plugin to the latest version 4.4.8 and add-ons to benefit from the latest bug fixes and improvements. This may not necessarily resolve your problem, however, in order to troubleshoot the issue best we need to work on the latest code available.
You can check the latest released versions under "My Account -> Downloads" on this site. Instructions to update can be found here: http://wpml.org/faq/install-wpml/
I'd like you to know that our development team considers performance all the time.
Please remember to backup your database first before you proceed.
Another point of interest is whether we can set certain autoload data to NO for WPML?
In future releases, we have some new features to clean up the strings. As for now, I can suggest trying to exclude the strings from auto-registering in WPML >> String Translation. But I can not be sure if this makes affects what you have pointed out.
