From owner-freebsd-isp Wed Jul 29 06:56:32 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id GAA27833 for freebsd-isp-outgoing; Wed, 29 Jul 1998 06:56:32 -0700 (PDT) (envelope-from owner-freebsd-isp@FreeBSD.ORG) Received: from ppc1.cybertime.ch (ppc1.cybertime.ch [194.191.120.136]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id GAA27791 for ; Wed, 29 Jul 1998 06:56:27 -0700 (PDT) (envelope-from pajarola@cybertime.ch) Received: from tyr.cybertime.ch by ppc1.cybertime.ch (AIX 4.1/UCB 5.64/4.03) id AA03802; Wed, 29 Jul 1998 15:55:26 +0200 Message-Id: <3.0.32.19980729155551.006f99d0@www.dlc.cybertime.ch> X-Sender: pajarola@www.dlc.cybertime.ch X-Mailer: Windows Eudora Pro Version 3.0 (32) Date: Wed, 29 Jul 1998 15:56:03 +0200 To: Tim Tsai , freebsd-isp@FreeBSD.ORG From: Rico Pajarola Subject: Re: MySql Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org At 05:33 29.07.98 -0500, you wrote: >Is anybody running MySql in a production environment? What are your >opinions regarding performance and stability? Since MySql is based on >kernel threads and there seems to be known problems with that on FreeBSD >I am concerned about its stability. MySQL seems fast and stable, but there is a problem with file descriptor limits under FreeBSD. This should'nt be a problem if you dedicate a machine to it. But don't try to run anything like Squid or INN on the same server... It uses MIT-Pthreads on -stable, but in current you can (and should) use kernel threads. I didn't notice any difference in stability though (no crashes ever safe this nasty 'too many open files'). btw: It was running with a limit of infinity (which means something like 640 to FreeBSD). >FreeBSD really needs a decent commercial DBMS. Right Rico Pajarola To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message