My site is running erratically in the past week. Users are complaining. Sometimes it is ok, other times it takes a huge amount of time. Until a week ago, things were pretty normal.
Here are things I am seeing.
Here are examples of slow runs:
Generated in 17.610 seconds in which 17.541 seconds were spent on a total of 9 queries.
Generated in 3.649 seconds in which 3.451 seconds were spent on a total of 9 queries.
Generated in 11.321 seconds in which 10.836 seconds were spent on a total of 15 queries.
Generated in 45.916 seconds in which 45.802 seconds were spent on a total of 13 queries.
Here are better ones:
Generated in 1.707 seconds in which 1.463 seconds were spent on a total of 9 queries.
Generated in 1.830 seconds in which 1.783 seconds were spent on a total of 12 queries.
Generated in 0.596 seconds in which 0.531 seconds were spent on a total of 14 queries.
Generated in 0.087 seconds in which 0.024 seconds were spent on a total of 14 queries.
Generated in 1.380 seconds in which 1.327 seconds were spent on a total of 28 queries.
These about a minute apart:
Generated in 79.416 seconds in which 79.340 seconds were spent on a total of 37 queries.
Generated in 0.091 seconds in which 0.022 seconds were spent on a total of 14 queries.
Searching this forum, last place I see much is from 2008:
Generated in 16.865 seconds...I think my hosting site has overloaded their MySQL server. Am I correct?
I've complained to DreamHost tech support, but got a response that my processes were hitting the site's memory limits. It is pretty odd, because I typically only have a dozen or so users at any one time, and all was running smoothly up until a week ago.
Is there something the tech support/DBA people should check so I can try to convince them?
