[AndrewD]

Originally Posted by elsupremo

I finally caught up with everyone, upgrading both my VB to 3.6.2 and my LDM to 2.2.6. I ended up having the problem with the constant MYSQL error e-mails

I fell into the trap of trying to be too friendly to the web server by releasing the database before everything was finished - I'd missed that VB keeps hold of some database accesses which are performed when the job finally ends. The error messages were actually telling you (not very clearly) that there was no longer a connection to the database.

One question: I ended up adjusting wait_timeout to 90 seconds when I was troubleshooting this problem. LDM told me that was a low wait_timeout setting, so I changed the setting back to default. What is an optimal wait_timeout setting?

I've not got right to the bottom of all the timeout settings. The basic point is to ensure that downloads complete before the database or the php script decide to give up in desparation. So, if you are offering downloads of large files - particularly if these are being streamed directly to a media player - the value for wait_timeout (and the similar value for php timeout - I can't recall its name) should be longer than the download takes to finish.

The php timeout is more critical on windows servers than on linux, as it seems to count also the time when the script has actually been told to sleep for a while. Under linux, this time is ignored.