From owner-freebsd-isp@FreeBSD.ORG Mon Jun 16 23:19:25 2003 Return-Path: Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 6418F37B401 for ; Mon, 16 Jun 2003 23:19:25 -0700 (PDT) Received: from misery.sdf.com (misery.sdf.com [207.200.153.226]) by mx1.FreeBSD.org (Postfix) with ESMTP id D9BA943F85 for ; Mon, 16 Jun 2003 23:19:23 -0700 (PDT) (envelope-from tom@sdf.com) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 19S8CD-00021d-00; Mon, 16 Jun 2003 21:35:49 -0700 Date: Mon, 16 Jun 2003 21:35:46 -0700 (PDT) From: Tom Samplonius To: Troy Settle In-Reply-To: <000601c33483$7b1f8810$0100a8c0@tws> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII cc: freebsd-isp@freebsd.org Subject: Re: ~40 mysql processes X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 17 Jun 2003 06:19:25 -0000 On Mon, 16 Jun 2003, Troy Settle wrote: > Is it normal to have ~40 MySQL processes running from a single server, > each using ~72MB of memory? > > MySQL was built with linux threads and is running on a Dual Xeon 2.4GHZ > w/HTT & 4GB RAM. For linuxthreads, yes. Linux threads implements threads as pseudo processes using rfork(). The 70MB memory usage is probably shared between all the "processes". Unfortunately, top doesn't do a job of showing how much of processes memory is shared with another process. Almost all forked processes share some memory space of the parent, whether rfork() or regular fork(). > TIA, > > -- > Troy Settle > Pulaski Networks > http://www.psknet.com > 540.994.4254 ~ 866.477.5638 > Pulaski Chamber 2002 Small Business Of The Year Tom