From owner-freebsd-questions@FreeBSD.ORG Tue May 17 16:32:12 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 C02F116A4CE for ; Tue, 17 May 2005 16:32:12 +0000 (GMT) Received: from hotmail.com (bay20-f14.bay20.hotmail.com [64.4.54.103]) by mx1.FreeBSD.org (Postfix) with ESMTP id 93D2043D5F for ; Tue, 17 May 2005 16:32:12 +0000 (GMT) (envelope-from michaelluch@hotmail.com) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 17 May 2005 09:32:12 -0700 Message-ID: Received: from 213.94.197.137 by by20fd.bay20.hotmail.msn.com with HTTP; Tue, 17 May 2005 16:32:11 GMT X-Originating-IP: [213.94.197.137] X-Originating-Email: [michaelluch@hotmail.com] X-Sender: michaelluch@hotmail.com From: "michael luch" To: freebsd-questions@freebsd.org Date: Tue, 17 May 2005 16:32:11 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 17 May 2005 16:32:12.0182 (UTC) FILETIME=[FA429360:01C55AFD] Subject: buffer cache size 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: Tue, 17 May 2005 16:32:12 -0000 I think that the buffer cache on my system is not growing sufficiently and wonder if I can I tune it. Here's a snippet from the output of top on my system: Mem: 646M Active, 2905M Inact, 174M Wired, 121M Cache, 112M Buf, 5460K Free Swap: 512M Total, 192K Used, 512M Free I have a MySQL db that's more than 1GB in size. When I do a SELECT, mysqld becomes about 25%busy (fair enough, it's waiting for disk). However, I was expecting to see the Buffer Cache size (that's the 121M Cache I think) grow, and expected to see subsequent SELECTs cause mysqld become CPU bound, as data from the database should now be in the buffer cache. However, this is not the case. I have 2GB of inactive memory, but a small buffer cache and a disk bound mysqld :( Are there some tunables I should look at to allow the buffer cache to grow? All the searches I did suggested that the vm system should look after this itself. Thanks M _________________________________________________________________ Send a sexy animated wink with Messenger 7.0 - FREE download! http://messenger.msn.co.uk