Date: Sun, 09 Jul 2006 14:14:18 -0700 From: Darren Pilgrim <darren.pilgrim@bitfreak.org> To: Mathieu Arnold <mat@FreeBSD.org> Cc: Mike Jakubik <mikej@rogers.com>, stable@freebsd.org Subject: Re: MySQL and default memory limits (mysqld: Out of memory) Message-ID: <44B171AA.9080400@bitfreak.org> In-Reply-To: <E56FEA0F58A776685B3AB5DF@[192.168.1.5]> References: <44B16BE9.60508@rogers.com> <E56FEA0F58A776685B3AB5DF@[192.168.1.5]>
next in thread | previous in thread | raw e-mail | index | archive | help
Mathieu Arnold wrote: > +-Le 09/07/2006 16:49 -0400, Mike Jakubik a dit : > | I read somewhere that FreeBSD by default > | limits process size to 512MB, however the variables used to tune it do > | not seems to exist in FreeBSD-6.1 any more. How can i let MySQL use more > | memory? > > If you're using a i386, the max process memory size limit is at 512M, > you'll have to tune kern.maxdsiz in /boot/loader.conf to say 1G. That OID doesn't seem to exist: > uname -pr 6.0-RELEASE-p1 i386 > sysctl -N kern | grep max kern.maxvnodes kern.maxproc kern.maxfiles kern.argmax kern.maxfilesperproc kern.maxprocperuid kern.ipc.maxsockbuf kern.ipc.somaxconn kern.ipc.max_linkhdr kern.ipc.max_protohdr kern.ipc.max_hdr kern.ipc.max_datalen kern.ipc.maxpipekva kern.ipc.msgmax kern.ipc.shmmax kern.ipc.maxsockets kern.iov_max kern.kq_calloutmax kern.maxusers kern.threads.max_threads_per_proc kern.threads.max_groups_per_proc kern.threads.max_threads_hits kern.smp.maxcpus -- Darren Pilgrim
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?44B171AA.9080400>