Hi Iago, This is really a freebsd related question and not MySQL. I believe that the archives contain some info. Anyway you need to build a custom kernel for freebsd see /usr/src/sys/i386/conf/LINT. look for this section: # Certain applications can grow to be larger than the 128M limit # that FreeBSD initially imposes. Below are some options to # allow that limit to grow to 256MB, and can be increased further # with changing the parameters. MAXDSIZ is the maximum that the # limit can be set to, and the DFLDSIZ is the default value for # the limit. MAXSSIZ is the maximum that the stack limit can be # set to. You might want to set the default lower than the max, # and explicitly set the maximum with a shell command for processes # that regularly exceed the limit like INND. # options MAXDSIZ="(256*1024*1024)" options MAXSSIZ="(256*1024*1024)" options DFLDSIZ="(256*1024*1024)"
Add this or use this to create your own kernel. Don't go above 2047*1024*1024 or any threaded program will crash on startup. Hope this helps. Ken ----- Original Message ----- From: "Iago Sineiro" <[EMAIL PROTECTED]> To: "MySql Mail List" <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 3:49 AM Subject: innodb_buffer_pool_size too large > Hi all. > > I'm testing configuration of InnoDB tables in MySQL database server. The > documentation of MySQL says > that a good configuration for innodb_buffer_pool_size (the buffer) is 80% of > physical memory if the computer is a dedicated MySQL server. I have 1GB of > memory, then I set innodb_buffer_pool_size = 740M. When I restarted the > MySQL server it fails. > > This is the log of mysql server, indicating that FreeBSD can't allocate this > memory, that I need to recompile the operating > system with that option. > > 020529 18:31:52 mysqld started > InnoDB: Fatal error: cannot allocate 738213888 bytes of > InnoDB: memory with malloc! Total allocated memory > InnoDB: by InnoDB 21180100 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. > InnoDB: On FreeBSD check you have compiled the OS with > InnoDB: a big enough maximum process size. > 020529 18:31:52 mysqld ended > > Anybody knows how to change the maximum process size? > > NOTE: I'm using FreeBSD 4.5 in a 2 Pentium III 1000 Ghz with 1G. > > Thanks in advance. > > Iago. > > > > -------------------------------------------------------------------- - > 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