Re: “Out of memory; check if mysqld or some other process uses all available memory;” error

Amarnath Shivashankar a écrit :
> We have found that the MYSQL on all Email DB servers starts throwing "Out of
> memory; check if mysqld or some other process uses all available memory;"
> error. The error goes once we restart MySQL. But after a week again the same
> problem occurs. We have 4 GB of physical memory on the server but Mysql
> utilizes only up to 2.5 GB & starts throwing Out of memory error
>
> Please help me to resolve this.........
>

This looks like the traditionnal 32 bits limitation ... You're using a 32 bits system right ? Because of many reasons (lots of documentation on the net about that) MySQL is in practice limited to about 2.4-2.6G of memory, thus the error you see.

When I experienced this errors, I lowered the mysql_buffer and innodb_buffer so that mysql would stay below this limit and never had other issue with it. (It was crashing with an error 11 before). I kept this settings till I could upgrade to a 64 bits host.

-- 
Mathieu Bruneau
aka ROunofF

===
GPG keys available @ 
http://rounoff.darktech.org

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com