SQL issues [resolved]

[Lincoln]

I've been using Hostgator for 2 years or longer, but lately I've been disappointed in the support I've been receiving.

I noticed latency issues of a few seconds or more when my WordPress powered site attempts to connect to the SQL database and execute queries. Any cached page that doesn't query the database loads just fine, so it's obviously an issue involving the SQL server.

Yet the best support can tell me is that the server is fine and that I should update a plugin or run a query optimizer. Never mind the fact that I don't even know what a query optimizer is, but is it really that impossible to figure out why it would take so long for the server to respond to queries? If I knew exactly what the problem was I could work to correct it if possible, but these vague answers are very unhelpful to say the least. Give me something concrete to work with here.

I suspect the server simply can't handle the SQL queries sent, which I can accept if my site simply has gotten too big and now requires a VPS or dedicated solution to run smoothly. But it's hard to believe two SQL databases on a low traffic blog could cause such a strain on the server, and I'd like to know for sure if that's indeed the case, or if there is simply some server clampdown in place that is intentionally creating a bottleneck for my site, that once removed would immediately resolve the issue.

Either way, it may be time for me to leave, because if this is indicative of the kind of support I'd received with a dedicated hosting package as well (where even more hands on knowledge is needed), that's a headache I can well do without.

Thanks for reading.

[GatorFord]

I'm really sorry to hear you are having these issues with your WordPress sites. Could you please let me know a ticket number so I can look into the issue to resolve this or at least give you a definitive answer on whether this is an issue caused by our server or whether the site has simply grown too large for a shared/reseller server? Thanks.

[Lincoln]

Thanks for your concern. The ticket number is JIS-3401318

If you can provide a more definitive answer it would be appreciated, if only to know once and for all what the culprit was.

[GatorDHanna]

I'm sorry to hear about your trouble. I've escalated that ticket to our senior administrators and assigned it to Ford to review as well.

[Lincoln]

Thank you!

[GatorDHanna]

I see that one of our senior administrators replied with some additional information. Was this helpful?

[Lincoln]

Yes, I received a list of queries that provided some clues as to what was causing the issue. When I have more time I will look to see if that can help me find which script has been initiating these slow queries and if it can be fixed.

Thanks for your time.