From owner-freebsd-questions@FreeBSD.ORG Tue Mar 2 03:07:19 2004 Return-Path: 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 E641F16A4CE for ; Tue, 2 Mar 2004 03:07:19 -0800 (PST) Received: from geminix.org (gen129.n001.c02.escapebox.net [213.73.91.129]) by mx1.FreeBSD.org (Postfix) with ESMTP id 6D35843D2F for ; Tue, 2 Mar 2004 03:07:19 -0800 (PST) (envelope-from gemini@geminix.org) Message-ID: <40446AE3.7000308@geminix.org> Date: Tue, 02 Mar 2004 12:07:15 +0100 From: Uwe Doering Organization: Private UNIX Site User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.6) Gecko/20040119 X-Accept-Language: en-us, en MIME-Version: 1.0 To: questions@freebsd.org References: <055201c3fe85$b3cda490$6401a8c0@yourqqh4336axf> In-Reply-To: <055201c3fe85$b3cda490$6401a8c0@yourqqh4336axf> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Received: from gemini by geminix.org with asmtp (TLSv1:AES256-SHA:256) (Exim 3.36 #1) id 1Ay7k5-00036w-00; Tue, 02 Mar 2004 12:07:17 +0100 Subject: Re: MySQL and FreeBSD 4.x.. problems, problems with server X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 02 Mar 2004 11:07:20 -0000 dap wrote: > This has happened with enough servers at different locations that I have to > believe there is a relationship here. I have servers running the latest > release of MySQL. I've run the servers on FreeBSD 4.4., 4.7, and 4.8. I am > not using the threaded version. MySQL always uses threads. It's just that you have the choice which implementation to use, native or Linux threads. > On all three versions, on different servers > at different sites, I have seen MySQL just go wacky after a while. > > Two types of symptoms: > > 1. mysqld just decides to consume as much of the CPU as possible. > 2. new connections to mysql fail > > It will usually take 1-3 weeks between occurances. > [...] > Yes, this is a mysql problem probably, and not a FreeBSD problem. However, > I'm hoping to get some help or hope here as well as with the mysql people. > :) There have been some fixes lately to 'libc_r', the threads lib MySQL uses by default on FreeBSD 4.x. They deal with EOF conditions in connection with write(2) which may very well cause process looping. This programming error could be the cause of your problem as well, so it might be worthwhile to take a look at the latest CVS commits to 'uthread_write.c': http://www.freebsd.org/cgi/cvsweb.cgi/src/lib/libc_r/uthread/uthread_write.c?sortby=date&only_with_tag=RELENG_4 BTW, a potentially serious problem with signals in 'uthread_join.c' has been fixed recently, too. Hope it helps in your case. Uwe -- Uwe Doering | EscapeBox - Managed On-Demand UNIX Servers gemini@geminix.org | http://www.escapebox.net