From owner-freebsd-questions@FreeBSD.ORG  Tue Apr 28 11:03:03 2009
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id E2A45106564A
	for <freebsd-questions@freebsd.org>;
	Tue, 28 Apr 2009 11:03:03 +0000 (UTC)
	(envelope-from peterpub2@aboutsupport.com)
Received: from dns.msk.asap.bg (dns.msk.asap.bg [78.90.206.101])
	by mx1.freebsd.org (Postfix) with ESMTP id 9C7838FC08
	for <freebsd-questions@freebsd.org>;
	Tue, 28 Apr 2009 11:03:03 +0000 (UTC)
	(envelope-from peterpub2@aboutsupport.com)
Received: from [10.30.1.106] (unknown [87.121.44.129])
	by dns.msk.asap.bg (Postfix) with ESMTP id CAF2639819
	for <freebsd-questions@freebsd.org>;
	Tue, 28 Apr 2009 14:03:01 +0300 (EEST)
Message-ID: <49F6E261.6040808@aboutsupport.com>
Date: Tue, 28 Apr 2009 14:02:57 +0300
From: Peter <peterpub2@aboutsupport.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
To: FreeBSD-Questions <freebsd-questions@freebsd.org>
References: <2cd0a0da0904280122x5416837re97255dc37283dc5@mail.gmail.com>	<2cd0a0da0904280228x763cd493v19c1d3bc45015f62@mail.gmail.com>	<alpine.BSF.2.00.0904281149350.26170@wojtek.tensor.gdynia.pl>
	<2cd0a0da0904280354w21c75c18p5a4563ca2a719d15@mail.gmail.com>
In-Reply-To: <2cd0a0da0904280354w21c75c18p5a4563ca2a719d15@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Subject: Re: Where am I wasting resources? How to fix this problem?
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 28 Apr 2009 11:03:04 -0000

VeeJay wrote:
> Thanks Wojciech
> 
> How can I find out the process count limit and how can I change it?
> 
> And what is the maximum limit I can give with this hardware?
> 
> 


Hello Veejay,

Add thise to your loader.conf

mysql# cat /boot/loader.conf
kern.maxdsiz="4096M"
kern.dfldsiz="2048M"
kern.maxssiz="1024MB"


and reboot the system. This should help.

These are values from one my  mysql boxes.

It is also also in mysql notes for freebsd(see bottom)

http://dev.mysql.com/doc/refman/5.1/en/freebsd.html


Peter