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/[EMAIL PROTECTED]