Date: Wed, 2 Aug 2006 09:03:07 -0400 From: Richard Morse <remorse@partners.org> To: Richard Morse <remorse@partners.org> Cc: questions@freebsd.org Subject: Re: Problems with MySQL since upgrade Message-ID: <D1FBD2B5-CEB6-479B-8254-497E199462CF@partners.org> In-Reply-To: <31F1465C-5B87-4B79-8D58-0A538BF30562@partners.org> References: <31F1465C-5B87-4B79-8D58-0A538BF30562@partners.org>
next in thread | previous in thread | raw e-mail | index | archive | help
On Aug 1, 2006, at 9:24 AM, Richard Morse wrote: > Hi! I recently updated MySQL to version 5.0.22 using the ports > system (portupgrade -r -R mysql-\*). Previous to this, MySQL was > behaving perfectly normally. Since the upgrade, I have found that > every so often -- sometimes two or three times a day, sometimes > every other day, but no more often than that -- one of the > databases MySQL is hosting starts misbehaving, MySQL starts > climbing in processor usage, and I have to restart MySQL to > recover. By "misbehaving", I mean that some subset of queries to > this database start not returning -- they take forever. By > climbing in processor usage, I mean that my load averages, which > normally sit around 0, start going up to 3, 5, even 7. > > - How can I determine what query it is that is causing this to > happen? I have turned on the log files by adding the following > line to /etc/rc.conf: Hi! Since this time, I have, I think, found what query is causing the problem: SELECT u.*, s.* FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.sid = "d9fe25949f79f2c767a0d237b4fdf841" AND u.status < 3 LIMIT 0, 1 How can I determine _why_ this is causing MySQL to hang/enter some kind of infinite loop? Thanks, Ricky
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?D1FBD2B5-CEB6-479B-8254-497E199462CF>