sometimes I'm experiencing an out of memory error running a mysql 5.0.14 in a replica active/active environment. MySQL log suggest to increase ulimit that of course is not available under windows.
There's a parameter related to memory max size? I'm trying to figure it out but all tuning parameters are related only to various buffers size.
> sometimes I'm experiencing an out of memory error running a mysql 5.0.14 > in a replica active/active environment. MySQL log suggest to increase > ulimit that of course is not available under windows.
> There's a parameter related to memory max size? I'm trying to figure it > out but all tuning parameters are related only to various buffers size.
> Thanks > Ste
How much memory (real and virtual) do you have on your system? How much is actually being used when you get the error?
-- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstuck...@attglobal.net ==================
skyste- wrote: > Jerry Stuckle wrote: >> skyste- wrote: > > How much memory (real and virtual) do you have on your system? How much >> is actually being used when you get the error?
> Mysql-nt.exe process is using 390mb.
> RAM is 4gb > With available phisycal memory about 2gb
> Pagefile is 1,5gb.
> Ste
Sorry for the delay - I missed your earlier update.
You didn't post the actual message you're getting, but it sounds like somewhere a memory allocation request could not be satisfied. This is probably because the OS couldn't allocate memory.
You should also check your buffer sizes, etc. in your MySQL config file - what do those look like?
Also, what is the actual message you're getting, and which OS are you using?
-- ================== Remove the "x" from my email address Jerry Stuckle JDS Computer Training Corp. jstuck...@attglobal.net ==================