MySQL and default memory limits (mysqld: Out of memory)

[Darren Pilgrim]

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