From owner-freebsd-questions@FreeBSD.ORG  Wed Apr  8 12:55:18 2009
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 1772510656C0
	for <freebsd-questions@freebsd.org>;
	Wed,  8 Apr 2009 12:55:18 +0000 (UTC)
	(envelope-from will.rutherdale@utoronto.ca)
Received: from mail.vex.net (smaug.vex.net [208.76.104.132])
	by mx1.freebsd.org (Postfix) with ESMTP id E68E18FC16
	for <freebsd-questions@freebsd.org>;
	Wed,  8 Apr 2009 12:55:17 +0000 (UTC)
	(envelope-from will.rutherdale@utoronto.ca)
Received: from [192.168.110.8] (unknown [207.35.13.213])
	by mail.vex.net (Postfix) with ESMTPA id 636D517106
	for <freebsd-questions@freebsd.org>;
	Wed,  8 Apr 2009 08:55:16 -0400 (EDT)
Message-ID: <49DC9EAD.2090300@utoronto.ca>
Date: Wed, 08 Apr 2009 08:55:09 -0400
From: William Gordon Rutherdale <will.rutherdale@utoronto.ca>
User-Agent: Thunderbird 1.5.0.14ubu (X11/20080505)
MIME-Version: 1.0
To: freebsd-questions <freebsd-questions@freebsd.org>
References: <139b44430904080511i5b883e8dm40ead16dd075ffe@mail.gmail.com>
In-Reply-To: <139b44430904080511i5b883e8dm40ead16dd075ffe@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Subject: Re: mysql memory
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 08 Apr 2009 12:55:18 -0000

I think 'top' is showing the external view of the process and how many 
pages total of heap have been allocated (under 'RES').  Possibly your 
tuner program is just showing the size of the cache specifically.

-Will

Valentin Bud wrote:
> Hello community,
>
>  I have mysql installed on FreeBSD 7.0 i386. I am using mysqltuner.pl from
> ports
> to check for tuning parameters. Now my problem, sort of speak, is that
> mysqltuner.pl
> shows the following:
> [OK] Maximum possible memory usage: 1.6G (53% of installed RAM)
>
>  So as far as i understand mysql is limited to using max 1.6G of RAM. But
> top
> shows different things
> PID USERNAME  THR PRI NICE   SIZE    RES   STATE  C   TIME    WCPU COMMAND
> 68083 mysql           18  44    0       2901M  1927M ucond   3   608:36
> 1.07%  mysqld
>
>  Why is mysql using more memory than showed in mysqltuner. Is mysqltuner
> inaccurate?
>
>  Mysql is used for storing fulltext obtained throuhg OCR from different
> documents. Is there a way
> to make a chart on how much memory is needed for a given number of pages or
> documents?
>
> thanks,
> v
>