The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
MySQL database timeout
I've had a few users experiencing SQL errors because the connection with the database has been lost. Generally, it seems these sites have rather small settings for the mysql wait_timeout setting (a few tens of seconds rather than the more typical value in the tens of thousands of seconds) and the problem usually occurs after completing a slow process like a large file download.
Is there a simple way inside VB to detect and re-establish the database connection if it has timed out? Is there any reason why a site would configure MySQL to have a short timeout? |
#2
|
||||
|
||||
IMO, The timeout should be about 180 seconds. Why anyone would set it to thousands is beyond me - that means you can have dead connections just sitting there (using up resources) for many hours.
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|