Keywords: WordPress - AWS - Technical issue - Other
We are having performance issues on our Bitnami WordPress instance with woocommerce having a little over 500k products, where we notice extremely long server response times (~60 seconds or sometimes even a gateway timeout).
Upon running show processlist; command in mysql console, we found a task named "event_scheduler" which is always running in the "Waiting on empty queue" state.
As recommended, we also have the W3 total cache plugin installed on WordPress with the pagecache enabled with the Disk:Enhanced setting. Other cache options are also enabled with the Disk setting.
We have run the bnsupport-tool on both sites but the tool was unable to upload the results, I have therefore uploaded them to google drive and sent the link as a reply on the welcome private message with beltran.