|
gmilne80
|
September 7, 2017 at 8:46 am
Hello,
I’ve purchased a support token and filled in the form for this issue.
It appears that event espresso is using a huge number of sql connections on my site and is often causing the database to timeout completely from this. I’ve had my host check and the max simultaneous connections on their package is set to 50.
I’ve reached the limit of what I am able to do to try and increase this and am hoping you may be able to investigate and offer some advice. Currently the back end of the site is responding extremely slowly due to this issue and it is making it nearly impossible to add new posts to the site without the connection getting dropped.
|
|
Josh
|
September 7, 2017 at 9:04 am
Hi Gordon,
We received your request for priority support. You could try deactivating the EWWW Image Optimizer plugin. That particular plugin does some backend processing with AJAX that somehow triggers EE’s checks for plugin updates. Normally those checks occur once every 24 hours, but if they’re happening on every request that will really slow things down.
|
|
gmilne80
|
September 7, 2017 at 9:10 am
Thanks for the fast response. I’ve disabled that plugin now. I’ll give it a run like that for a day or so and see if there is a difference or not and get back to you. If there is anything else I can do to increase site speed that you can suggest it would be much appreciated.
|
|
Josh
|
September 7, 2017 at 9:19 am
There are some additional suggestions in the WordPress codex related to the max simultaneous database connections issue:
https://codex.wordpress.org/High_Traffic_Tips_For_WordPress#MySQL.2FMariaDB
I’m curious about how it was determined that Event Espresso 3 is using a huge number of sql connections, those connections all go through WPDB, but if your site gets a lot of traffic that could mean you need to upgrade to a host that allows more than 50.
|
|
gmilne80
|
September 7, 2017 at 10:23 am
I don’t know if the slow load times I’m getting will all be related to the max user connections. When running P3 performance monitor plugin it was identifying that over 90% of the load time was from the espresso multiple plugin. Is this due to the large number of events we have on the site or is there a way this load time can be reduced further?
Also, is there any host that you would recommend looking at that would provided more connections?
|
|
Josh
|
September 7, 2017 at 10:27 am
Yes the stats from the p3 plugin are more than likely due to the large number of events on your site.
We have a number of host recommendations here:
https://eventespresso.com/requirements/
|
