From owner-freebsd-questions@FreeBSD.ORG Fri Oct 13 11:18:08 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 46B8716A417 for ; Fri, 13 Oct 2006 11:18:08 +0000 (UTC) (envelope-from georg@dts.su) Received: from mail.dts.su (mail.dts.su [80.84.115.110]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5E1F643D60 for ; Fri, 13 Oct 2006 11:18:06 +0000 (GMT) (envelope-from georg@dts.su) Received: (qmail 15284 invoked by uid 1009); 13 Oct 2006 11:18:03 -0000 Received: from unknown (HELO localhost) (192.168.18.98) by mail.dts.su with SMTP; 13 Oct 2006 11:18:03 -0000 Date: Fri, 13 Oct 2006 15:17:32 +0400 From: georg@dts.su X-Mailer: The Bat! (v3.80.06) Professional Organization: dts.su X-Priority: 3 (Normal) Message-ID: <1815339004.20061013151732@dts.su> To: freebsd-questions@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Subject: FreeBSD 6.2 MySQL cannot allocate... X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: georg@dts.su List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 13 Oct 2006 11:18:08 -0000 Helo, freebsd-questions. I have FreeBSD 6.2 with 2GB RAM, 4GB SWAP and MySQL 5.0 In my.cnf I write innodb_buffer_pool_size = 1G When Mysql 5.0 starting his write to errorr log: InnoDB: Error: cannot allocate 1073758208 bytes of InnoDB: memory with malloc! Total allocated memory InnoDB: by InnoDB 28448296 bytes. Operating system errno: 12 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. InnoDB: Note that in most 32-bit computers the process InnoDB: memory space is limited to 2 GB or 4 GB. InnoDB: We keep retrying the allocation for 60 seconds... InnoDB: Fatal error: cannot allocate the memory for the buffer pool In kernel conf I write: options MAXDSIZ=(1224*1024*1024) options DFLDSIZ=(1224*1024*1024) options MAXSSIZ=(128*1024*1024) also in /boot/loader.conf: kern.maxdsiz="1075771824" # 1GB kern.dfldsiz="1075771824" # 1GB kern.maxssiz="268435456" # 128MB What can I do for solve this error? Sorry for my English... -- Regards, georg mailto:georg@dts.su