Persistent connections?

[telescopi]

Just had to edit my config.php to change where it sends those horrible 'database error' emails (overloaded server), and noticed this entry - anyone know what it does exactly, and what is best?

[eva2000]

do a search on this forum you should find a few posts by me and others http://vbulletin.com/forum/search.php?s= ;)

[Philipp]

and what is best?

That depend on your hosting account. If your board is on a virtual account then better you turn off persistant connections. If your board is on a dedicated server then use persistant connections.

[telescopi]

I never think of search - most places turn it off for the sake of CPU :)

Think I've got an idea of what it does - dunno how it will turn out on a hugely loaded server though (normally between 5 and 15 load), we're getting a new server tomorrow anyway (dual P3, 1GB RAM), so hopefully won't be a problem after that :)

[telescopi]

Hmm, well it is a dedicated server - but only a RAQ3 and routinely has over 150 users on - been upped to 512MB at least, it wasn't funny before :)

Lots of 'too many connection' errors, probably about 800 a day.

[bplein]

Originally posted by telescopi
Hmm, well it is a dedicated server - but only a RAQ3 and routinely has over 150 users on - been upped to 512MB at least, it wasn't funny before :)

Lots of 'too many connection' errors, probably about 800 a day.

If I'm not mistaken, simply put the max_connections to a number that is GREATER THAN the number of max connections into your web server.... in Apache I have mine set to 350, and the DB to 500. I'll fine tune more later.