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+02: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';
Please let me know if that fix the issue.
Manage Cookie Consent
We use cookies to optimize our website and services. Your consent allows us to process data such as browsing behavior. Not consenting may affect some features.
Functional
Always active
Required for our website to operate and communicate correctly.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
We use these to analyze the statistics of our site. Collected information is completely anonymous.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
These cookies track your browsing to provide ads relevant to you.
