Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Out of memory on Windows

1 view
Skip to first unread message

skyste-

unread,
Nov 5, 2009, 3:17:39 AM11/5/09
to
Hello all,

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

Jerry Stuckle

unread,
Nov 5, 2009, 6:00:48 AM11/5/09
to

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.
jstu...@attglobal.net
==================

skyste-

unread,
Nov 5, 2009, 6:11:11 AM11/5/09
to
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

skyste-

unread,
Nov 5, 2009, 6:11:17 AM11/5/09
to
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.

Jerry Stuckle

unread,
Nov 6, 2009, 12:15:30 PM11/6/09
to

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?

0 new messages