From owner-freebsd-questions@FreeBSD.ORG Mon May 9 11:46:28 2005 Return-Path: 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 10B4D16A4E7 for ; Mon, 9 May 2005 11:46:28 +0000 (GMT) Received: from ctb-mesg1.saix.net (ctb-mesg1.saix.net [196.25.240.73]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7759B43D7B for ; Mon, 9 May 2005 11:46:27 +0000 (GMT) (envelope-from savage@savage.za.org) Received: from smtp01.za.hybyte.net (wbs-146-135-86.telkomadsl.co.za [165.146.135.86]) by ctb-mesg1.saix.net (Postfix) with ESMTP id 0E11E5EFB; Mon, 9 May 2005 13:46:22 +0200 (SAST) Received: from 030-001.za.hybyte.net ([192.168.1.30] helo=pc2xp) by smtp01.za.hybyte.net with smtp (Exim 4.50) id 1DV6iM-000D7h-qT; Mon, 09 May 2005 13:46:22 +0200 Message-ID: <000d01c5548c$bbeec830$1e01a8c0@pc2xp> From: "Chris Knipe" To: , Date: Mon, 9 May 2005 13:46:24 +0200 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 Subject: memory errors / crashes X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 09 May 2005 11:46:28 -0000 We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=536870912 read_buffer_size=2093056 max_used_connections=418 max_connections=2048 threads_connected=404 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 516080 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Righty. Now, the system has 4 x 3.2GHz Intel processors... It has 4GB of ram... systat shows that all 4 processors are definately used... NO swap space is used at all (4GB allocated), and yes, it uses the entire 4GB of ram under heavy load... I am aware of the POSSIBILITY of the 2GB limit... However, I highly doubt that this is related as the system has no problem to use the 4GB of RAM (According to top in any case). 1) Why does the system not swap, and 2) Why is Mysql complaining that it needs at least 512MB ram, whilst there are 4GB available to it?????? I've been battling for over 3 weeks to get this right, I have made multiple posts on the list about this... can someone please just give me some answers.... We're running FBSD 5.4-STABLE. -- Chris.