Steff,
Windows 2k Professional has a 2-gigabyte process limit. You are probably
hitting that. Windows 2000 Server has a 3-gig limit (provided you do some
configuration).
Sadly, apparently Linux has a 2 or 2.5 gig limit as well.
BTW, if you are looking at performance testing, MySQL on Win32 is
significantly slower than on Linux.
David.
----- Original Message -----
From: <Steff@stripped>
To: <mysql@stripped>
Cc: <steff@stripped>
Sent: Sunday, May 11, 2003 7:55 PM
Subject: does a 2gig memory limitation exist on the win2k MySQL-Max 4.x
build?
> Hello,
> I have two windows 2k machines with 4 gig of ram each. On one
> machine I have MySql 3.23.54-max-nt-log on the other I have
> 4.0.12-nt-log in both cases I am running INNODB.
>
> Any time I try and set the innodb_buffer_pool_size greater then
> 1600M I get an error. Based in the information in the error log it
> appears the MySql does not think I have enough memory in the
> machines.
>
> The pertinent portion of the WinMySQLadmin report is below:
> OS Platform : Windows 2000 Service Pack 3
> Machine description:
> Compiler : VC++ 6.0
> Architecture : i686
> Total Memory : 2097151 KB RAM
>
>
> What do I need to do to let MySql know the computers have
> more then 2gig of Ram ?
>
> The server properties window reports 4 gig of ram, as does Task
> Manager. My current database is about 3.5gig in size. I was hoping
> to let MySql have access to more memory for the index buffering.
>
> Thanks
> Steff
>
>
> --
> Steff McGonagle
> Envisage Information Systems, Inc.
>
> Phone (315) 497-9202 x16
> www.EnvisageSystems.com
> www.Enveritus.com
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
