Keywords: WordPress - AWS - Technical issue - Other
bnsupport ID: f99f208d-7c23-7504-b96e-f09ce7d33e31
We migrated the WooCommerce site to AWS to use the CDN. The website works incredibly fast everywhere but payments and product updates.
If we try to update a product (POST request to /wp-admin/post.php) it takes 21-22 seconds to complete! The same is happening when people are paying through a credit card (PayPal Express is perfectly fine). Also if we want to refund it can also take up to 20 seconds to complete.
Everything else works very fast, I don't know what's the issue.
I am using the laster AWS Lightsail image 5.6 with PHP v7.4.13 and MySQL 8.0.22
Server is 32 GB RAM, 8 vCPUs, 640 GB SSD
I tried everything I could imagine already...
#wait_timeout = 120
long_query_time = 1
I can share more php settings if required.
I can't find anything in error logs or googling this issue. It's very strange, how come the website works perfectly fine, but some POST requests take forever to complete. Would it be something with the DataBase migration?
Anyways, I hope someone will help me ;c