Hello all,
Urgent problem here.
We have an application which via Ajax calls, does some queries very frequently. This is not a problem, it's the way it's designed and in our demo environment functions perfectly.
The issue is, with the production database and webservers, every query sleeps and never closes (though the code calls mysqli->close explicitly).
I have ruled out the DB server as a problem, by having the old demo webserver connect to it for the site and works as it should.
Thus, my conclusion is, it must be either a PHP or Apache setting - I am leaning towards Apache.
Has anyone ever experienced this before or have any suggestions? After the past 9 hours I am out of ideas (ie. I compared the main settings in httpd.con such as KeepAlive and Timeout to the demo server and set them the same...)
Thanks need urgent help!!
