GolfGTIforum.co.uk

General => Site news and bright ideas => Topic started by: Ben Lessani on 24 January 2009, 23:02

Title: Slow DB server driving me mad!
Post by: Ben Lessani on 24 January 2009, 23:02
Database Error: MySQL server has gone away
File: /home/jv/public_html/Sources/Subs.php
Line: 2903

Is the error message bain of my existance! I can't make any longish posts on my dub thread without the timeout message.

The resolution is easy, you just need to modify the MySQL config a little, increase the wait_timeout and it should solve the issue.

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

If you get stuck, I can lend a hand ;)
Title: Re: Slow DB server driving me mad!
Post by: bondbill2k2 on 25 January 2009, 09:29
sql fail  :grin: sos cant help
Title: Re: Slow DB server driving me mad!
Post by: topher on 25 January 2009, 12:11
It's on my 'to-do' list.. had the same issue trying to post my detailing thread. It was never a problem before I increased the max. allowable characters per post :lipsrsealed:
Title: Re: Slow DB server driving me mad!
Post by: jv on 25 January 2009, 18:12
The bain of your existance?! :grin:

See what messing with the settings does toph  :tongue:
Title: Re: Slow DB server driving me mad!
Post by: Ben Lessani on 25 January 2009, 18:48
It's on my 'to-do' list.. had the same issue trying to post my detailing thread. It was never a problem before I increased the max. allowable characters per post :lipsrsealed:

Hand me over some root and I'll do it for you in an instant ;) I maintain 3 dedi Linux servers daily for my company.
Title: Re: Slow DB server driving me mad!
Post by: bondbill2k2 on 26 January 2009, 00:35
 :grin: dunno why i said no idea without reading what you put  :grin:

I was watching the IT crowd at the time and had the whole attitude of " is it turned on" *hangs up* in my head  :smiley:
Title: Re: Slow DB server driving me mad!
Post by: jamie_pyrite on 27 January 2009, 13:53
"Hello IT, have you tried turning it off and on?"

 :grin:
Title: Re: Slow DB server driving me mad!
Post by: jv on 01 February 2009, 13:24
mysql wait_timeout adjusted, let me know if it makes any difference :)
Title: Re: Slow DB server driving me mad!
Post by: Ben Lessani on 01 February 2009, 23:12
Thanks chief! Next time I make a big update on my thread, I'll say so.

I'm doing the valve stem seals and tappets next weekend - so I'll post the guide next weekend, then I'll know ;)