Re: “Out of memory; check if mysq ld or some other process uses all availab le memory;” error

[Mathieu Bruneau]

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