From owner-freebsd-questions@FreeBSD.ORG Wed Apr 8 12:11:19 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 D5A3F106573B for ; Wed, 8 Apr 2009 12:11:19 +0000 (UTC) (envelope-from valentin.bud@gmail.com) Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.187]) by mx1.freebsd.org (Postfix) with ESMTP id 63A6B8FC19 for ; Wed, 8 Apr 2009 12:11:19 +0000 (UTC) (envelope-from valentin.bud@gmail.com) Received: by mu-out-0910.google.com with SMTP id w9so37377mue.3 for ; Wed, 08 Apr 2009 05:11:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:from:date:message-id :subject:to:content-type; bh=oKEHPMzGYsvpS1nB1csXzLs8ieIq8ahzjI++xXpjd0c=; b=tX5IGK0lbEh5P76d1EjzTmlRVvzyhIBLhNgJtfpWMaFXrrpIQrRJvVewvRPT2jTjyH s6eY3IcJYlhbx6eNtKnz0nhsYALWN2+sLYfuMdNiLSzGdi1lvJHvt0BEnLLSSN+C/9yI BJPbJbvIliMpmOY9XiXyVMTnNtVGc2+PjfLwM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:from:date:message-id:subject:to:content-type; b=av+vG+usU3EYL37+16SLloWFLJ33SdbocfdlUBoXQjVaj971iygXXCbm4h7lMSMrQD TRVqffHyvcgEb1R+x1BVMhfHNRxUZ8eDwl+lD0Nfk/WCoHRP3wpK9KWrogOF9rZxOgRc 8smC3dGx/YoU6X+JIMOvtEKZOv+NqC20Q+SZg= MIME-Version: 1.0 Received: by 10.103.214.13 with SMTP id r13mr507974muq.37.1239192678277; Wed, 08 Apr 2009 05:11:18 -0700 (PDT) From: Valentin Bud Date: Wed, 8 Apr 2009 14:11:03 +0200 Message-ID: <139b44430904080511i5b883e8dm40ead16dd075ffe@mail.gmail.com> 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: mysql 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: Wed, 08 Apr 2009 12:11:20 -0000 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 -- network warrior since 2005