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
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.
----- Original Message -----
Sent: Sunday, May 11, 2003 7:55 PM
Subject: does a 2gig memory limitation exist on the win2k MySQL-Max 4.x
> 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
> 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.
> Steff McGonagle
> Envisage Information Systems, Inc.
> Phone (315) 497-9202 x16
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1