[Closed] Slow PHP logs

Hello there,

I performed some tests in the local copy of your site and I was able to improve the performance considerably by following some steps.

I recommend that you create a test/staging version of the site where you can test it before implementing in the live site. Or that you make a full backup prior to proceeding to those steps, just in case.

From the steps bellow, please check the ones that are feasible to implement:

- Update all the WPML plugins, there are a few updates available that contain patches related to performance
- Update all plugins/themes in general and WordPress version to 6.6.1
- Disable the WP Query monitor while not debugging performance issues, keeping it always enabled can be costly
- Lower the weight of the page size in MB. Compress media (EWWW Image Optimizer or similar), minimize the media quantity through the pages
- Go to WPML -> Support -> Troubleshooting (link). Once on the troubleshooting screen press the following buttons:
Press each button at a time and wait for the process to complete.
'Cleanup and optimize string tables'
'Clear the cache in WPML'
'Remove ghost entries from the translation tables'
'Fix element_type collation'
'Fix terms count'
'Fix post type assignment for translations'
- If possible try to have only one security and one cache plugin in place, having multiple of them can also cause slowness
- Update to PHP 8.0, 8.1 or 8.2 versions

On top of those steps, I also checked that your options with the autoload enabled are consuming a lot of memory every time the site loads. Please check more about the autoload here: hidden link

If you run the following SQL query, you'll see the options that are consuming more resources:

SELECT option_id, option_name, sum(char_length(`option_value`))/1024 as size FROM `wp_options` WHERE `autoload` = 'yes' GROUP BY option_id ORDER BY size DESC;

Based on this thread, you can set icl_sitepress_settings to be not 'autoloaded', that should help giving a performance boost:

https://wpml.org/forums/topic/urgent-icl_sitepress_settings-is-510803-in-length-causing-website-down-time/page/2/#post-13552369

You can disable it with the following command:

update wp_options set autoload = 'not' where option_name = 'icl_sitepress_settings';

But there are a few other plugins consuming lots of resources that you need to check if you can either disable the plugin, change some settings to decrease the autoload consumption or disable the autoload for them, but this needs to be done on a plugin-by-plugin basis as we're talking about 3rd party plugins we don't support and don't fully know how they operate.

The options: wpseo_taxonomy_meta wcml_trbl_products_needs_fix_postmeta and channel_project are the ones in the top, but there are others you'll be able to see when running the select query above.

Thank you, please give it a try and let us know how it goes.
Mateus

Hello there,

You're correct.

I checked here that is safe to disable the autoload for wcml_trbl_products_needs_fix_postmeta as well.

Please go ahead with the steps and tell me the results.