From owner-freebsd-questions@FreeBSD.ORG Tue Feb 10 16:49:04 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 1A9E0106566C for ; Tue, 10 Feb 2009 16:49:04 +0000 (UTC) (envelope-from valentin.bud@gmail.com) Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.153]) by mx1.freebsd.org (Postfix) with ESMTP id 950FF8FC1C for ; Tue, 10 Feb 2009 16:49:03 +0000 (UTC) (envelope-from valentin.bud@gmail.com) Received: by fg-out-1718.google.com with SMTP id l26so1224126fgb.35 for ; Tue, 10 Feb 2009 08:49:02 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=OOTrzGdnTm5QH9k2CDEJgha0U89QojybBzYvkJl4tQg=; b=onOrQ+ChxwPFhx+Nnr5l4aZTfW+2qk8xCEMWzit1O98ipSefhZAhWYzJa818Njt1QE f45NYxIv/IZySuDRMzqZb6Ql0PhE3cbiDDlkmGDJcSDzgEE4As4fxv0eA+cnFHRFkbb2 zxizpsD+1+ZXpAgHDd+AtEIxXX/yHlOV0AEmo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=ly/e0cYLbtkNPd/vA91+WOOKEUqWY23rwCwMcSZkPHJFOc32Aec6aesMFVsqh4o29V c8bOzoR53Rl1rOerhRG7xNprnJkpq7C1XuIhWeLhPh0+cfiR1T/nCc3mf3JnGg/ytntt 0w2TvzbBlPgqk4eIk4rOWJMz0EttjAb/DqLvQ= MIME-Version: 1.0 Received: by 10.86.91.3 with SMTP id o3mr641686fgb.77.1234284542733; Tue, 10 Feb 2009 08:49:02 -0800 (PST) Date: Tue, 10 Feb 2009 18:49:02 +0200 Message-ID: <139b44430902100849r30b5144cxb5770fa45fa6c906@mail.gmail.com> From: Valentin Bud To: freebsd-questions Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Subject: mysqld out of memory 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: Tue, 10 Feb 2009 16:49:04 -0000 Hello community, Today I had for the first time this problem with mysql on a production server. The following start flowing in the mysql-err.log 090210 9:12:17 [ERROR] /usr/local/libexec/mysqld: Out of memory (Needed 1676280 bytes) Doing a top resulted in mysql eating up about 2GB of memory of a total of 4 GB which i have on that particular box. After googling a little i found some post on the mailing list about setting kern.maxdsiz to 1GB. After that I have checked out the kern.maxdsiz with # limits -Hd Resource limits (current): datasize 1048576 kB I noticed that it is already at 1GB. Now my problem is how can i avoid this in the future because on that production server mysql is crucial or in case it happens how ca I be the first to know of that problem? I will post some info about the server # uname -a FreeBSD nemty 7.0-RELEASE FreeBSD 7.0-RELEASE #5: Tue Mar 25 16:38:28 CET 2008 root@nemty:/usr/obj/usr/src/sys/NEMTY i386 # mysqladmin version ... Server version 5.0.75-log ... If there are any other info that might help in troubleshooting this problem i will be glad to provide them. Thanks for yout input. a great day, v