I have a search script that works really good when there is no traffic to it, but when you start getting multiple requests it doesn't work at all. I am getting about 16,500 hits to the script a day (the load is balanced between two servers), and it will not provide search results anymore unless you are lucky enough to find a low traffic period. You just sit there until it times-out. To me it seems like there is a lock on a file and everyone is waiting their turn. In heavier traffic situations, requests will continue to build until they end up overloading the MySQL server. I need someone to find the problem here and fix it.
The logs pretty much always look like this:
Read POST information timed out
client stopped connection before rvputs completed
Also, within admin there is a spot to set how often the stats are calculated. I would like this option seperated from the rest of the script so that I can run it as a cron job and not have it burden an unfortunate users experience.
This script can be seen at [login to view URL]