|
Stephanie Redcross
|
April 22, 2015 at 1:58 pm
While the event pages load, the registration page does not load and all the server resources are used to the maximum making the website unresponsive.
There is no caching plugin active.
What are the steps in debugging this?
|
|
Josh
|
April 22, 2015 at 2:44 pm
Hi Stephanie,
I can troubleshoot a few things with the credentials. I checked the site and it’s running relatively slow without Event Espresso active. You can see what I mean by going to http://ismyblogworking.com/ and inputing your website your URL. So if it’s already slow, activating EE will make things slower because Event Espresso requires a fair amount of a server’s resources.
Can you check with your host to see if they have an hosting package upgrade available where they can move you on to a higher performance server?
|
|
Stephanie Redcross
|
April 22, 2015 at 2:59 pm
When we add EE, the site stops working. We can’t access the admin screen and we get a 500 Error.
We actually updated our hosting package on Monday. That helped a little. I talked to the hosting company today and they said our VPS is loading and responding at the normal rate. This is the pages, we are running the Snappy 4000 http://www.hostgator.com/vps-hosting
|
|
Josh
|
April 22, 2015 at 3:10 pm
I checked the error logs and today there are hundreds of errors that start with these:
WordPress database error Lost connection to MySQL server during query for query SELECT option_value FROM
and
[22-Apr-2015 19:45:28 UTC] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted
Can you check with your host to see if they can find out why MySQL connections are closing, and why the memory limit is exceeded? It may help if they can run a repair script on the database.
|
|
Stephanie Redcross
|
April 22, 2015 at 3:20 pm
The hosting company is asking where you pulled this report from.
|
|
Josh
|
April 22, 2015 at 3:24 pm
They are in the file named error_log that’s in the public_html folder of your server.
|
|
Stephanie Redcross
|
April 22, 2015 at 3:28 pm
This is their answer so far:
This article will help you with that issue. You need to make this change in the wp-config.php file. Go to “Increasing memory allocated to PHP” in https://codex.wordpress.org/Editing_wp-config.php
Because you’re MAX can be pushed higher.
They are changing it for us now…..
|
|
Josh
|
April 22, 2015 at 3:35 pm
I did already change that to 256MB (it was 128MB), but the WordPress database error Lost connection to MySQL server during query for query SELECT option_value FROM errors happened again when I tried to re-activate Event Espresso.
|
|
Stephanie Redcross
|
April 22, 2015 at 3:38 pm
Is there a reason why we can’t make it larger than 258MB? We have 4GB allocated to us (unless I’m mixing apples and oranges)
is there something else we need the hosting company to do? He thought the 258MB solved it
|
|
Stephanie Redcross
|
April 22, 2015 at 3:44 pm
They set it to 512MB and did the repair again…..did that resolve the issue for EE?
|
|
Josh
|
April 22, 2015 at 3:45 pm
It may help if they can run a repair script on the database if the website continues to run slowly.
|
|
Stephanie Redcross
|
April 22, 2015 at 3:56 pm
They ran the repair script
|
|
Lorenzo Orlando Caum
|
April 22, 2015 at 4:34 pm
Hi Stephanie,
I followed up with you via email.
Thanks
—
Lorenzo
|
|
Stephanie Redcross
|
April 22, 2015 at 4:45 pm
Hi Lorenzo, Yes, feel free to active EE
|
|
Stephanie Redcross
|
April 22, 2015 at 10:50 pm
Let me know if you have any updates on this.
Also we can integrate a caching plugin if you consider that it will help with the overall speed of the website.
|
|
Lorenzo Orlando Caum
|
April 24, 2015 at 8:07 am
Hi, I saw that Josh replied to your question. Did you have any other questions about caching plugins?
—
Lorenzo
|
|
Stephanie Redcross
|
April 24, 2015 at 2:39 pm
Yes, thanks for following up. What is the best caching plugin to use which might have a CDN feature built in? And I wanted to confirm if a caching plugins break the EE plugin? We read that on the forum and though that might have been the issue earlier, however, I’m not sure if it applies to the current version.
I’m asking because, while the site is finally stable (no more lost connections) The registration pages loads very slow. We are getting complaints. It is even worse on the final page, When they click proceed to payment page, it can take up between 30 to 90 seconds to load.
Here’s an event page so you can see what I mean: http://engine2diet.com/eatstrongplant-stock/
|
|
Dean
|
April 27, 2015 at 1:45 am
Hi,
Personally I recommend W3 Total Cache, though as a company we have no formal recommendations. CDN’s are usually a separate service, though W3 does help integrate CDN’s into it.
Event Espresso will need certain pages white listed, please see here for more info: https://eventespresso.com/wiki/setup-nocache-exclusion-rules-event-espresso/
Looking at your site, I’m seeing between 8 to 10 second load times, certainly nothing in the region of 30 seconds or more.
|
