This thread is resolved. Here is a description of the problem and solution.
Problem: You are experiencing slow performance on your site, and PHP x-ray reports indicate that WPML is significantly impacting performance. The issue might be related to the database collation settings for the wp_postmeta table. Solution: We recommend altering the collation of your wp_postmeta table to utf8mb4_general_ci to potentially resolve the performance issues. You can do this by executing the following SQL commands in your database:
ALTER TABLE `wp_postmeta`<br />CHANGE `meta_key` `meta_key` varchar(255) COLLATE 'utf8mb4_general_ci' NULL AFTER `post_id`,<br />CHANGE `meta_value` `meta_value` longtext COLLATE 'utf8mb4_general_ci' NULL AFTER `meta_key`,<br />COLLATE 'utf8mb4_general_ci';
If this solution does not apply to your case, or if it is outdated, we highly recommend checking related known issues at https://wpml.org/known-issues/, verifying the version of the permanent fix, and confirming that you have installed the latest versions of themes and plugins. If the issue persists, please open a new support ticket at WPML support forum for further assistance.
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.
Background of the issue:
I am experiencing very slow performance on my site hidden link.
My previous ticket was marked as resolved, but the issue persists.: https://wpml.org/forums/topic/very-slow-performance/page/2/
I have tried disabling AffiliateWP and all caching plugins without success. I couldn't find the 'Activity Log Plugin' and 'CDN Cache Plugin' you mentioned.
Here is a list of my current installed plugins:
Advanced Custom Fields Multilingual - Version 2.1.4.2
Advanced Custom Fields PRO - Version 6.3.6
AffiliateWP - Version 2.21.0
AffiliateWP - Affiliate Area Shortcodes - Version 1.3.1
Cloudways WordPress Migrator - Version 5.56
CommerceGurus CommerceKit - Version 2.3.0.1
Contact Form 7 - Version 5.9.8
Contact Form 7 Multilingual - Version 1.3.1
CookieYes | GDPR Cookie Consent - Version 3.2.6
Custom Post Type UI - Version 1.17.1
Elementor - Version 3.23.4
Elementor Pro - Version 3.23.3
Explorial Coupon Plugin - Version 1.0.0
Explorial Klavyio Plugin - Version 3.0
Explorial Photo Gallery Plugin - Version 1.0.1
FiboSearch - AJAX Search for WooCommerce (Pro) - Version 1.28.1
GTM4WP - A Google Tag Manager plugin - Version 1.20.2
Imagify - Version 2.2.2
Kirki Customizer Framework - Version 5.1.0
Lazy Load Control For Elementor - Version 0.0.3
mame TWINT for WooCommerce - Version 6.0.4
Media Cleaner - Version 6.7.8
Object Cache Pro - Version 1.21.2
Query Monitor - Version 3.16.4
Rank Math SEO - Version 1.0.226
Rank Math SEO PRO - Version 3.0.69
Redirection - Version 5.5.0
REST Extensions - Version 1.3
Smart Coupons for WooCommerce Pro - Version 2.4.4
Thrive Product Manager - Version 10.1
Thrive Quiz Builder - Version 10.1
WooCommerce - Version 9.2.3
WooCommerce Discount Manager - Version 1.1.7
WooCommerce Multilingual & Multicurrency - Version 5.3.7
WooCommerce PayPal Payments - Version 2.8.3
WooCommerce Stripe Gateway - Version 8.6.1
WP Mail SMTP - Version 4.1.1
WP Rocket - Version 3.16.4
WP Rocket | Disable Google Font Optimization
WP-Memory-Usage - Version 1.2.10
WPML Multilingual CMS - Version 4.6.13
WPML SEO - Version 2.1.0
WPML String Translation - Version 3.2.14
Symptoms:
In PHP x-ray reports, WPML always ranks on top regarding performance impact and we're not sure how to improve that or where the problem exactly is. Please see the original ticket.
Questions:
In PHP x-ray reports, WPML always ranks on top regarding performance impact and we're not sure how to improve that or where the problem exactly is. Please see the original ticket.
Thanks for your answer. We found the two plugins and deleted it.
The website was not noticeably faster than before, but also not slower.
These were the only mu-plugins present.
Languages: English (English )Spanish (Español )Italian (Italiano )
Timezone: Europe/Madrid (GMT+01:00)
Hi there!
After a long time of testing and debugging, the second tier think that I found a possible issue.
The wp_postmeta table has collation of utf8mb3_general_ci and not utf8mb4_general_ci
Possible solution is to do this in the database:
ALTER TABLE `wp_postmeta`
CHANGE `meta_key` `meta_key` varchar(255) COLLATE 'utf8mb4_general_ci' NULL AFTER `post_id`,
CHANGE `meta_value` `meta_value` longtext COLLATE 'utf8mb4_general_ci' NULL AFTER `meta_key`,
COLLATE 'utf8mb4_general_ci';
