From owner-freebsd-current@FreeBSD.ORG Thu Apr 27 08:13:21 2006 Return-Path: X-Original-To: freebsd-current@FreeBSD.org Delivered-To: freebsd-current@FreeBSD.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 9BE8D16A403; Thu, 27 Apr 2006 08:13:21 +0000 (UTC) (envelope-from bra@fsn.hu) Received: from people.fsn.hu (people.fsn.hu [195.228.252.137]) by mx1.FreeBSD.org (Postfix) with ESMTP id 2F3CB43D49; Thu, 27 Apr 2006 08:13:20 +0000 (GMT) (envelope-from bra@fsn.hu) Received: from localhost (localhost [127.0.0.1]) by people.fsn.hu (Postfix) with ESMTP id 67E3B8441E; Thu, 27 Apr 2006 10:13:19 +0200 (CEST) Received: from people.fsn.hu ([127.0.0.1]) by localhost (people.fsn.hu [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 06082-02-4; Thu, 27 Apr 2006 10:13:12 +0200 (CEST) Received: from [IPv6:::1] (unknown [192.168.2.3]) by people.fsn.hu (Postfix) with ESMTP id 97FD484418; Thu, 27 Apr 2006 10:13:12 +0200 (CEST) Message-ID: <44507D18.9050707@fsn.hu> Date: Thu, 27 Apr 2006 10:13:12 +0200 From: Attila Nagy User-Agent: Thunderbird 1.5 (X11/20060407) MIME-Version: 1.0 To: Jason Evans References: <444F71F3.6030901@fsn.hu> <444F83AD.9040207@FreeBSD.org> In-Reply-To: <444F83AD.9040207@FreeBSD.org> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at fsn.hu Cc: freebsd-current@FreeBSD.org Subject: Re: malloc problems with MySQL? X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 27 Apr 2006 08:13:21 -0000 Hello, On 04/26/06 16:29, Jason Evans wrote: >> The problem is that with the exact same configuration as with >> 6-STABLE, MySQL cannot allocate more than about 400-500MB of memory: >> >> mysqld: (malloc) Error in malloc(838877200): out of memory >> mysqld got signal 6; >> >> Limits seems to be OK: >> datasize 2097152 kB >> I have kern.maxdsiz=2G in loader.conf. >> >> MySQL gets errno 12 (ENOMEM) when trying to allocate that amount of RAM. >> >> What else is needed to make it work with the new malloc >> implementation? I can malloc the same amount of memory from a one >> liner program... > Allocations that are larger than the chunk size (2 MB by default) are > allocated using mmap(2), rather than sbrk(2). Most likely, your > problems will go away if you reduce the heap size, so that mmap has more > address space to work with. I've increased vm.max_proc_mmap to the max, without any effects. I can still not create my 1M row heap table in MySQL. What do you mean under reducing the heap size? ps: rev. 1.125 of src/lib/libc/stdlib/malloc.c didn't help (if it's supposed to help to resolve this issue) Thanks, -- Attila Nagy e-mail: Attila.Nagy@fsn.hu Free Software Network (FSN.HU) phone: +3630 306 6758 http://www.fsn.hu/