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
