From owner-freebsd-questions@FreeBSD.ORG Tue Aug 1 13:24:37 2006 Return-Path: X-Original-To: questions@freebsd.org Delivered-To: freebsd-questions@FreeBSD.ORG Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 5D2BA16A4DD for ; Tue, 1 Aug 2006 13:24:37 +0000 (UTC) (envelope-from remorse@partners.org) Received: from phsmgmx4.partners.org (phsmgmx4.partners.org [155.52.251.35]) by mx1.FreeBSD.org (Postfix) with ESMTP id D02A643D5D for ; Tue, 1 Aug 2006 13:24:36 +0000 (GMT) (envelope-from remorse@partners.org) Received: from phsmgmx4.partners.org (localhost.localdomain [127.0.0.1]) by localhost (Postfix) with SMTP id 28900188353 for ; Tue, 1 Aug 2006 09:24:36 -0400 (EDT) Received: from hedwig.mgh.harvard.edu (hedwig.mgh.harvard.edu [132.183.156.18]) by phsmgmx4.partners.org (Postfix) with ESMTP id 14A1A188349 for ; Tue, 1 Aug 2006 09:24:36 -0400 (EDT) Received: from [132.183.156.105] (buxtehude.mgh.harvard.edu [132.183.156.105]) by hedwig.mgh.harvard.edu (8.13.3/8.13.3) with ESMTP id k71DPxlU060515 for ; Tue, 1 Aug 2006 09:26:00 -0400 (EDT) (envelope-from remorse@partners.org) Mime-Version: 1.0 (Apple Message framework v752.2) Content-Transfer-Encoding: 7bit Message-Id: <31F1465C-5B87-4B79-8D58-0A538BF30562@partners.org> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: questions@freebsd.org From: Richard Morse Date: Tue, 1 Aug 2006 09:24:31 -0400 X-Mailer: Apple Mail (2.752.2) Cc: Subject: Problems with MySQL since upgrade X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 01 Aug 2006 13:24:37 -0000 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: mysql_args="--log=/var/log/mysql_query.log --log-error=/var/log/ mysql_error.log" but these log files don't seem to contain how long a query took, and I can't even tell if the query that is misbehaving is making it into the log file. - Does anyone have any suggestions what might be causing this problem? - How can I fix it? Thanks, Ricky Morse