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

_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"
  • mysql memory Valentin Bud
    • Re: mysql memory William Gordon Rutherdale

Reply via email to