From owner-freebsd-questions@FreeBSD.ORG Mon Jul 31 15:35:14 2006 Return-Path: X-Original-To: freebsd-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 0C64216A4DA for ; Mon, 31 Jul 2006 15:35:14 +0000 (UTC) (envelope-from erik@erikkristensen.com) Received: from wsi.scrus.com (static-host-66-18-46-88.epbinternet.com [66.18.46.88]) by mx1.FreeBSD.org (Postfix) with ESMTP id B750043D66 for ; Mon, 31 Jul 2006 15:35:09 +0000 (GMT) (envelope-from erik@erikkristensen.com) Received: from wsi.scrus.com (localhost.scrus.com [127.0.0.1]) by wsi.scrus.com (Postfix) with ESMTP id DB8FB343EA for ; Mon, 31 Jul 2006 11:35:04 -0400 (EDT) Received: by wsi.scrus.com (Postfix, from userid 80) id D9CFD343E6; Mon, 31 Jul 2006 11:35:04 -0400 (EDT) To: freebsd-questions@freebsd.org MIME-Version: 1.0 Date: Mon, 31 Jul 2006 11:35:04 -0400 From: Erik Kristensen Message-ID: <87530d2a0b64cbc84fbfd1a19eecbc0d@66.18.46.88> X-Sender: erik@erikkristensen.com User-Agent: RoundCube Webmail/0.1b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit Subject: MySQL Signal 10 on FreeBSD 6.0-RELEASE-P6 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: Mon, 31 Jul 2006 15:35:14 -0000 Good Afternoon, I have an interesting issue with FreeBSD 6.0 and MySQL 5.0. Part of my problem has been discussed serveral times in the past on other mailing lists and it seems there has been fixes for older versions of MySQL. The MySQL server is currently receiving a SIGNAL 10 about once an hour, which is causing many problems with the innodb databases that we have running on this server. I am running FreeBSD 6.0-RELEASE-p6 and MySQL 5.0.22. In all the lists I have read regarding FreeBSD, MySQL and signal 10, it all seems to happen with version 6.0 and the 4.1.x series of MySQL. We were running 4.1.x when the problem first appeared so taking the advice of several mailing lists we upgraded MySQL to version 5.0. We first deinstalled mysql, dist cleaned the install, then did a make on the new version of mysql. Even after the upgrade we are still getting several SIGNAL 10s, usually about once an hour. Any help in this area would be greatly appreciate as this is our production server having issues. We are a small company with limited resources. The server is a dual xeon 2.8ghz dual core processors with 1GB (2x512) of ram. 400GB 7200rpm SATA drive. 80GB 7200rpm SATA drive. Thank you for your time. -Erik