From owner-freebsd-questions@FreeBSD.ORG Wed Jul 19 17:14:23 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 BCD2316A4E2 for ; Wed, 19 Jul 2006 17:14:23 +0000 (UTC) (envelope-from thaddeus@dm1.net) Received: from mail.dm1.net (mail.dm1.net [162.39.20.85]) by mx1.FreeBSD.org (Postfix) with SMTP id 0809643D4C for ; Wed, 19 Jul 2006 17:14:22 +0000 (GMT) (envelope-from thaddeus@dm1.net) Received: (qmail 21701 invoked from network); 19 Jul 2006 17:15:34 -0000 Received: from unknown (HELO ?192.168.1.49?) (thaddeus@192.168.1.49) by mail.dm1.net with SMTP; 19 Jul 2006 17:15:34 -0000 Mime-Version: 1.0 (Apple Message framework v752.2) Content-Transfer-Encoding: 7bit Message-Id: <407487AA-A1C4-4581-A7EA-2FBC68E284C6@dm1.net> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed To: freebsd-questions@freebsd.org From: Thaddeus Quintin Date: Wed, 19 Jul 2006 13:14:20 -0400 X-Mailer: Apple Mail (2.752.2) Subject: Memory usage for MySQL 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: Wed, 19 Jul 2006 17:14:23 -0000 I'm working on a FreeBSD 6.1 machine and setting up MySQL 5.0 with some InnoDB tables. The machine has 2GB of RAM and will primarily be used as a database machine and will also be serving files over NFS (not high volume). The issue that I'm having is that when I start up MySQL I get a couple "Out of Memory" errors before it actually starts up. Looks like this- 060719 11:55:35 InnoDB: Started; log sequence number 0 43656 /usr/local/libexec/mysqld: Out of memory (Needed 950109184 bytes) /usr/local/libexec/mysqld: Out of memory (Needed 712581120 bytes) 060719 11:55:35 [Note] /usr/local/libexec/mysqld: ready for connections. Version: '5.0.22-log' socket: '/tmp/mysql.sock' port: 3306 If I reduce or increase the innodb_buffer_pool_size variable for MySQL I can eliminate or increase the number of errors. This set of errors was with innodb_buffer_pool_size set to 600M This is what top currently shows for MySQL- PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND 871 mysql 8 20 0 1196M 159M kserel 0 0:01 0.00% mysqld I tweaked /boot/loader.conf to allow larger data size for processes already (rebooted after changes)- kern.maxdsiz="1395864371" # 1.3GB kern.dfldsiz="1395864371" # 1.3GB kern.maxssiz="134217728" # 128MB If there's an out of memory error, how come MySQL starts up? Is this something to be concerned about? What else should I be checking to figure this out? Thanks- Thaddeus