Author Topic: Slow DB server driving me mad!  (Read 2377 times)

Offline Ben Lessani

  • I live here
  • *****
  • Posts: 3,873
  • The poor mans MK2 Haynes author
Slow DB server driving me mad!
« 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 ;)

Offline bondbill2k2

  • Here all the time
  • ****
  • Posts: 452
Re: Slow DB server driving me mad!
« Reply #1 on: 25 January 2009, 09:29 »
sql fail  :grin: sos cant help

Offline topher

  • Administrator
  • Serious forum addict
  • *****
  • Posts: 9,605
  • fully functioning
Re: Slow DB server driving me mad!
« Reply #2 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:

Online jv

  • Administrator
  • Serious forum addict
  • *****
  • Posts: 7,212
Re: Slow DB server driving me mad!
« Reply #3 on: 25 January 2009, 18:12 »
The bain of your existance?! :grin:

See what messing with the settings does toph  :tongue:
Buy site stuff!
GolfGTI.co.uk - merchandise

Support the forum charity!
Forum Charity

Offline Ben Lessani

  • I live here
  • *****
  • Posts: 3,873
  • The poor mans MK2 Haynes author
Re: Slow DB server driving me mad!
« Reply #4 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.

Offline bondbill2k2

  • Here all the time
  • ****
  • Posts: 452
Re: Slow DB server driving me mad!
« Reply #5 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:

Offline jamie_pyrite

  • I live here
  • *****
  • Posts: 908
Re: Slow DB server driving me mad!
« Reply #6 on: 27 January 2009, 13:53 »
"Hello IT, have you tried turning it off and on?"

 :grin:

Online jv

  • Administrator
  • Serious forum addict
  • *****
  • Posts: 7,212
Re: Slow DB server driving me mad!
« Reply #7 on: 01 February 2009, 13:24 »
mysql wait_timeout adjusted, let me know if it makes any difference :)
Buy site stuff!
GolfGTI.co.uk - merchandise

Support the forum charity!
Forum Charity

Offline Ben Lessani

  • I live here
  • *****
  • Posts: 3,873
  • The poor mans MK2 Haynes author
Re: Slow DB server driving me mad!
« Reply #8 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 ;)