symptone, one of those that you quote was from 2002. George no longer seems to recommend having a large wait_timeout, he seems to go for the minimum-it-can-go-but-still-work-on-your-forum philosophy now. I recently asked him for help in tuning my forum and I had it originally set at the default (I think 28800) and am currently trying out 240. Yesterday I tried out 180 but got two database errors, so I'm trying out something new today. But, there is so much more that goes into tuning your mysql server than just the wait_timeout! I would strongly suggest that you post in the Server Configuration forum and ask for his advice. There is a notice at the top that tells you all the information he needs (about 13 or 14 items). He knows his stuff. I was having problems every night on my board when I did my backups, now I have no problems. The board is running smooth as silk, in part thanks to George.
|