Ben, the my.cnf file (usually in /etc/my.cnf) usually contains the
settings related to memory usage. You can see info on a lot of the
various settings here:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
and here for InndoDB-specific:
http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html
If you post the output of SHOW VARIABLES we can take a look and tell
you what you might have misconfigured.
Dan
On 10/6/06, Ben Clewett <ben@stripped> wrote:
> Dear MySql,
>
> Using: 5.1.11 on AIX (precompiled 64-bit) with 100% InnoDB, 4GB memory.
>
> Our MySql is consistently using 150% memory, or 50% paging space. Once
> it gets to 150%, it tends to stay at this limit consistently.
>
> I am trying to find a tool to tell me what it is using, and some
> documentation about how to control MySQL memory use.
>
> Would some kind member help me find these?
>
> Regards,
>
> Ben Clewett.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
| Thread |
|---|
| • Memory Use | Ben Clewett | 6 Oct |
| • Re: Memory Use | Dan Buettner | 6 Oct |
