[solved] Retry with new instance.
We have a PHP script that runs some MySql queries, it is for reporting and these queries can take up to a minute. That is not a problem for us.
The problem is after x seconds, LiteSpeed restarts the process with:
[NOTICE] Retry with new instance.
In the log file.
If I'm watching 'mytop' - I can see the first MySql process running and then I can see an identical query running from the 2nd process when a new instance is started.. and then another one sometimes from a 3rd retry.
All these new instances are making original query take longer.
I'm sure this is pretty basic, but how can I stop this? I presume there is a timeout setting I can change? Or just turn off the retries?
Last edited by NiteWave; 02-23-2011 at 12:46 PM..