Date: Wed, 08 Apr 2009 08:55:09 -0400 From: William Gordon Rutherdale <will.rutherdale@utoronto.ca> To: freebsd-questions <freebsd-questions@freebsd.org> Subject: Re: mysql memory Message-ID: <49DC9EAD.2090300@utoronto.ca> In-Reply-To: <139b44430904080511i5b883e8dm40ead16dd075ffe@mail.gmail.com> References: <139b44430904080511i5b883e8dm40ead16dd075ffe@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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 >
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?49DC9EAD.2090300>