InnoDB memory allocation on FreeBSD

2002-01-17 Thread Alexei V. Alexandrov

Hello everyone,

  I`m running mysql version 4.0.0-alpha under FreeBSD 4.3-STABLE on a
  dual pentium 4 x 1Ghz with a total memory of 1.5Gb and a scsi hard
  drive with a volume about 50Gb. The problem is in the InnoDB startup
  option innodb_buffer_pool_size. I`m trying to set it to about 500MB.
  When giving this option mysql won`t start and the error log reports
  that InnoDB cannot allocate requested memory size:

  InnoDB: Fatal error: cannot allocate 524304384 bytes of
  InnoDB: memory with malloc! Total allocated memory
  InnoDB: by InnoDB 157458980 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.

  Here is the output of top:
  
  160 processes: 1 running, 159 sleeping
  CPU states: 10.3% user,  0.0% nice,  2.1% system,  0.3% interrupt, 87.3% idle
  Mem: 329M Active, 577M Inact, 137M Wired, 25M Cache, 163M Buf, 638M Free
  Swap: 3257M Total, 3257M Free

  Where can i be wrong?

--- 
 Best regards,
 Alexei V. Alexandrov


-
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




Re: InnoDB memory allocation on FreeBSD

2002-01-17 Thread Sergei Golubchik

Hi!

On Jan 17, Alexei V. Alexandrov wrote:
 Hello everyone,
 
   I`m running mysql version 4.0.0-alpha under FreeBSD 4.3-STABLE on a
   dual pentium 4 x 1Ghz with a total memory of 1.5Gb and a scsi hard
   drive with a volume about 50Gb. The problem is in the InnoDB startup
   option innodb_buffer_pool_size. I`m trying to set it to about 500MB.
   When giving this option mysql won`t start and the error log reports
   that InnoDB cannot allocate requested memory size:
 
   InnoDB: Fatal error: cannot allocate 524304384 bytes of
   InnoDB: memory with malloc! Total allocated memory
   InnoDB: by InnoDB 157458980 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.
 
   Here is the output of top:
   
   160 processes: 1 running, 159 sleeping
   CPU states: 10.3% user,  0.0% nice,  2.1% system,  0.3% interrupt, 87.3% idle
   Mem: 329M Active, 577M Inact, 137M Wired, 25M Cache, 163M Buf, 638M Free
   Swap: 3257M Total, 3257M Free
 
   Where can i be wrong?
 
 --- 
  Best regards,
  Alexei V. Alexandrov

It's well-known kernel config issue. See LINT

% limit
...
datasize524288 kbytes
...

% grep MAXDSIZ /usr/src/sys/compile/SERG/machine/*
vmparam.h:#ifndef MAXDSIZ
vmparam.h:#define MAXDSIZ (512UL*1024*1024) /* max data size */

Regards,
Sergei

-- 
MySQL Development Team
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
   ___/

-
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