Hi Miguel and David,
Thanks for the rapid response. If the windows /PAE option
where to work on our equipment is it valid to assume that the
WinMySqlAdmin report would show the extra memory in the
heading labelled "Total Memory" ?
We have avoided moving our database to Linux because we
have been told that under a unix operating system the table and
column names become case sensitive. Is this true ? We are
concerned because we were not consistent in the use of
capitalization when building our SQL statements in our existing
On 14 May 2003 at 20:29, miguel solorzano wrote:
Date sent: Wed, 14 May 2003 20:29:33 -0300
From: miguel solorzano <miguel@stripped>
Subject: Re: does a 2gig memory limitation exist on
the win2k MySQL-Max
Copies to: steff@stripped
> At 22:55 11/05/2003 -0400, Steff@stripped wrote:
> This isn't a MySQL issue, please read at Microsoft support how
> to enable Physical Address Extension (PAE) X86.
> > 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.
> For technical support contracts, visit https://order.mysql.com/
> Are you MySQL certified?, http://www.mysql.com/certification/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Miguel Angel Solórzano
> / /|_/ / // /\ \/ /_/ / /__ São Paulo - Brazil
> /_/ /_/\_, /___/\___\_\___/
> <___/ www.mysql.com
Envisage Information Systems, Inc.
Phone (315) 497-9202 x16