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 ... datasize 524288 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