Re: InnoDB, FreeBSD and Memory: Cannot Allocate memory - raising limits

2005-08-23 Thread Jeremiah Gowdy
:45 AM Subject: InnoDB, FreeBSD and Memory: Cannot Allocate memory - raising limits SUMMARY While I am fairly certain the problem is with FreeBSD, since this is InnoDB/MySQL related, I thought I would post here to see if others have had this problem. I have googled several different phrases to

Re: InnoDB, FreeBSD and Memory: Cannot Allocate memory - raising limits

2005-08-23 Thread Peter Beckman
On Tue, 23 Aug 2005, Jeremiah Gowdy wrote: The limit you are running into is the maxdsiz or max data size for a process. It is defaulting to 512MB. In FreeBSD 5.x you don't have to recompile your kernel to set a different maxdsiz. See /boot/defaults/loader.conf. Putting kern.maxdsiz="107374

Re: InnoDB, FreeBSD and Memory: Cannot Allocate memory - raising limits

2005-08-23 Thread Jeremiah Gowdy
:45 AM Subject: InnoDB, FreeBSD and Memory: Cannot Allocate memory - raising limits SUMMARY While I am fairly certain the problem is with FreeBSD, since this is InnoDB/MySQL related, I thought I would post here to see if others have had this problem. I have googled several different phrases to

InnoDB, FreeBSD and Memory: Cannot Allocate memory - raising limits

2005-08-23 Thread Peter Beckman
SUMMARY While I am fairly certain the problem is with FreeBSD, since this is InnoDB/MySQL related, I thought I would post here to see if others have had this problem. I have googled several different phrases to find this answer -- how does FreeBSD 5 set resource limits, and how do I override them