From owner-freebsd-current@FreeBSD.ORG Mon Jun 14 19:14:53 2004 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 8A0DC16A4CE; Mon, 14 Jun 2004 19:14:53 +0000 (GMT) Received: from mail.ngdc.net (mail.ngdc.net [195.190.153.169]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4AC6D43D62; Mon, 14 Jun 2004 19:14:53 +0000 (GMT) (envelope-from laursen@netgroup.dk) Received: from animal (port390.ds1-noe.adsl.cybercity.dk [217.157.177.19]) (AUTH: LOGIN laursen@solidcore.dk) by bunsen.solidcore.dk with esmtp; Mon, 14 Jun 2004 21:14:50 +0200 Message-ID: <02da01c45243$d86439b0$6401a8c0@animal> From: "Lasse Laursen" To: "Daniel Eischen" References: Date: Mon, 14 Jun 2004 21:14:11 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 cc: freebsd-current@freebsd.org cc: freebsd-threads@freebsd.org Subject: Re: Possible Threading problem with -CURRENT / MySQL? X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 14 Jun 2004 19:14:53 -0000 Hi, I will try that. Would it be better to use 4.10 and MySQL w. LinuxThreads instead? It's production databases that we run on the machine so stability is a must (yes I know - 5.2 isn't stable yet...) The reason why we decided to use 5.2-CURRENT was that the improved SMP support - which seems to still have some bugs? Regards -- Lasse Laursen · VP, Hosting Technology · NetGroup Processing Aps St. Kongensgade 40H · DK-1264 Copenhagen K, Denmark Phone: +45 3370 1526 · Fax: +45 3313 0066 - Don't be fooled by cheap finnish imitations - BSD is the One True Code ----- Original Message ----- From: "Daniel Eischen" To: "Lasse Laursen" Cc: ; Sent: Monday, June 14, 2004 9:10 PM Subject: Re: Possible Threading problem with -CURRENT / MySQL? > On Mon, 14 Jun 2004, Lasse Laursen wrote: > > > > > WE use the SCHED_ULE, and: > > > > > > > > # Memory options > > > > options MAXDSIZ="(1536*1024*1024)" > > > > options MAXSSIZ="(1024*1024*1024)" > > > > options DFLDSIZ="(1536*1024*1024)" > > > > > > Try using SCHED_4BSD, then try removing all memory options. > > > > Wouldn't this limit us to 512 MB of memory per process running on the > > server? we tried with each scheduler with same results. I will try to > > recompile without the memory options and use the old scheduler. Any hints > > why this might work? > > No, just trying to see what happens with a more stock > kernel. Also, try removing /etc/my.conf to use default > MySQL settings. > > -- > Dan > >