On Friday 06 March 2009 15:31, ccornell - OpenOffice.org wrote: > On 03/06/09 15:26, Frank Schönheit - Sun Microsystems Germany wrote: > > Hi Clayton, > > > >> Maybe some of you noticed that there was some problems with the > >> OOoWiki today reporting errors something along the lines of "too > >> many connections". This happens when there are too many open > >> connections on the MySQL database. This can be caused by many > >> things... no one specific seems to stand out. > >> > >> This has been fixed now. > > > > Not really. I just ran into it when saving an article, this way > > losing some work :( > > Hmmm it's back :-( I bumped up the allowed connections from 100 to > 150, and it's still happening. Time to do more digging I guess.
Clayton, in php4 there was a php.ini setting, maybe it still exists in php5: mysql.allow_persistent. Setting this to "Off" might reduce the number of open connections dramatically. Did you try this? It might also reduce performance a little bit (but only if establishing a new mysql connection takes much time), but php will then close every connection after finishing the calling script (as far as i remember). Regards, Nino --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
