Yeh I forgot to originally state that I was using freebsd. You were correct,
freebsd is compiled by default to not allow processes bigger than roughly
500megs. I recompiled the kernel, changing the limit to 1.5 gigs and now it
runs fine using all my memory.
For anyone else who needs the howto for this go look at.
http://www.cs.unc.edu/~jeffay/dirt/FAQ/kernel-memory.html
Thanks,
Rich
----- Original Message -----
From: "Christopher Schreiber" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "'Heikki Tuuri'"
<[EMAIL PROTECTED]>
Sent: Saturday, December 08, 2001 10:22 AM
Subject: RE: innodb won't allocate the memory i ask it to
> If you are running FreeBSD, there is an inner limit, which doesn't allow
> malloc() calls greater then 500MB. You need to reconfigure the kernel
> sources and recompile (or change your InnoDB parameters to use less then
> 500MB of RAM).
>
> Chris Schreiber
>
> -----Original Message-----
> From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, December 08, 2001 4:58 AM
> To: [EMAIL PROTECTED]
> Subject: Re: innodb won't allocate the memory i ask it to
>
>
> Rich,
>
> >I have a system with 1gig of ram and i am trying to get the innodb buffer
> to
> >be about 750megs. Whenever I set the value in the database config file it
> >won't start with an error along the lines of,
> >
> >011207 21:02:42 mysqld started
> >InnoDB: Fatal error: cannot allocate 67108864 bytes of
> >InnoDB: memory with malloc! Total allocated memory
> >InnoDB: by InnoDB 484667027 bytes. Operating system errno: 12
> >InnoDB: Cannot continue operation!
> >InnoDB: Check if you should increase the swap file or
> >InnoDB: ulimits of your operating system.
> >011207 21:02:44 mysqld ended
> >
> >I have 1gig of ram and a 1gig swap file.
> >Any ideas why it won't assign more than roughly 450megs of memory to
mysql?
>
> do you have other big processes running at the same time in your computer?
>
> If not, then this is probably a problem in Linux or glibc. Some Linux
> versions seem to refuse to allocate big amounts of memory. You could try
> another Linux kernel version, or write to your Linux vendor about the
> problem.
>
> >Rich
>
> Regards,
>
> Heikki
> http://www.innodb.com
> --
> Order commercial MySQL/InnoDB support at https://order.mysql.com/
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
