From owner-freebsd-questions@FreeBSD.ORG Thu Apr 5 13:35:47 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 40A8116A403 for ; Thu, 5 Apr 2007 13:35:47 +0000 (UTC) (envelope-from freebsd-questions@m.gmane.org) Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mx1.freebsd.org (Postfix) with ESMTP id 012D413C483 for ; Thu, 5 Apr 2007 13:35:46 +0000 (UTC) (envelope-from freebsd-questions@m.gmane.org) Received: from root by ciao.gmane.org with local (Exim 4.43) id 1HZS7C-0006Os-AR for freebsd-questions@freebsd.org; Thu, 05 Apr 2007 15:35:02 +0200 Received: from router.inscrfibre.fibre.golden.net ([209.183.151.182]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 05 Apr 2007 15:35:02 +0200 Received: from gdunn01 by router.inscrfibre.fibre.golden.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 05 Apr 2007 15:35:02 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-questions@freebsd.org From: Graham Dunn Date: Thu, 05 Apr 2007 09:24:19 -0400 Lines: 43 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: router.inscrfibre.fibre.golden.net User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.2pre) Gecko/20070116 Thunderbird/2.0b2 Mnenhy/0.7.5.0 Sender: news Subject: Running out of memory for mysql(dump) X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 05 Apr 2007 13:35:47 -0000 I've asked this question on the mysql-users list, but there wasn't any more information than what I've seen on google. The problem is that I get an error when trying to use mysqldump to get a backup of our RT Attachments table (all other tables will process fine) /usr/local/bin/mysqldump: Error 5: Out of memory (Needed 14154840 bytes) when dumping table `Attachments` at row: 24285 mysql Ver 12.22 Distrib 4.0.24, for portbld-freebsd5.3 (i386) mysqldump Ver 10.9 Distrib 4.1.12, for portbld-freebsd5.3 (i386) and mysqldump Ver 9.11 Distrib 4.0.24, for portbld-freebsd5.3 (i386) There are pages in the mysql online docs about setting variables in /boot/loader.conf to avoid the 512MB per-process limit in FreeBSD: seisei# more /boot/loader.conf set console=comconsole kern.maxdsiz="1G" # kern.dfldsiz="751619277" # 750 MB kern.maxssiz="134217728" # 128MB No change after reboot. FreeBSD seisei.cs.myharris.net 5.3-RELEASE-p9 FreeBSD 5.3-RELEASE-p9 #0: Wed Apr 20 13:14:54 EDT 2005 root@atarashii.inscriber.local:/usr/obj/usr/src/sys/GENERIC i386 vm.vmtotal: System wide totals computed every five seconds: (values in kilobytes) =============================================== Processes: (RUNQ: 1 Disk Wait: 0 Page Wait: 0 Sleep: 58) Virtual Memory: (Total: 1823K, Active 1132540K) Real Memory: (Total: 1009492K Active 708436K) Shared Virtual Memory: (Total: 40948K Active: 26944K) Shared Real Memory: (Total: 37572K Active: 24768K) Free Memory Pages: 48428K Any suggestions for dealing with this? Thanks, Graham