Date: Mon, 23 May 2005 19:44:41 +0100 From: "Steven Hartland" <killing@multiplay.co.uk> To: <stable@FreeBSD.ORG>, "Pete French" <petefrench@ticketswitch.com> Subject: Re: mysql loosing connections on 5.4 Message-ID: <004d01c55fc7$7d0afd50$b3db87d4@multiplay.co.uk> References: <E1DaGhN-000Ono-QZ@dilbert.firstcallgroup.co.uk>
next in thread | previous in thread | raw e-mail | index | archive | help
Do you get a particular error and which version of mysql are you running: We have to use 4.0 due to this bug: http://bugs.mysql.com/?id=7209&edit=2 Steve ----- Original Message ----- From: "Pete French" <petefrench@ticketswitch.com> To: <stable@FreeBSD.ORG> Sent: Monday, May 23, 2005 6:26 PM Subject: mysql loosing connections on 5.4 > When port randomisation was added to 4.x I noticed that under heavy > loading my webservers starting dropping their connections to the > the mysql database. This was fixed by disabling port randomisation > and everything ran very happily. > > When I upgraded to 5.4 I left port randomisation on, and everything > was fine until we started to get a very heavy load on the servers over > the last two days. So I disabled it, and the problem went away to a large > degree, but is still there occasionaly (i.e. I still see a few connections). > > It's odd behavioour, but what makes it odder is that all these connections > are too a local mysql process, using a socket in /tmp! So quite how > port randomsiation should affect it I dont know. > > Anybody else seen this ? I remember a few people had the same issue under > 4.x, but I havent heard much about it since then. ================================================ This e.mail is private and confidential between Multiplay (UK) Ltd. and the person or entity to whom it is addressed. In the event of misdirection, the recipient is prohibited from using, copying, printing or otherwise disseminating it or any information contained in it. In the event of misdirection, illegible or incomplete transmission please telephone (023) 8024 3137 or return the E.mail to postmaster@multiplay.co.uk.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?004d01c55fc7$7d0afd50$b3db87d4>