| Site Inaccessible, Host Says "Queries inefficient"
Hello,
My site was shut down/locked up, whatever. This is what my host says. What should I do?
"Yes, it looks like your queries are terribly inefficient and causing a
21000 second backlog. I have killed all of the processes at this time."
"This means you had some queries, mentioned in the first reply, working
on processing data for over 5 minutes. New connections piled up waiting
for those connections to finish and as a result your site was
inaccessible. A programmer needs to refactor the
code to fix it. The site wasn't pulled at all. Your code locked its
users from accessing it. 10 out of 10 connection slots were in use by
the site because you had 10 SELECT DISTINCT() queries stuck on
processing data."
|