MySQL Forums
Forum List  »  InnoDB

Re: Cannot use innodb_buffer_pool great than 1,5Gb
Posted by: Yoshiaki Tajika
Date: December 01, 2005 11:52PM

Would you try 4GB RAM tuning? By setting "/3GB" switch in boot.ini,
an application process can allocate more than 2GB memory.

Then, comment out "innodb_buffer_pool_awe_mem_mb" in my.ini,
and set "innodb_buffer_pool_size=2500MB", for example.

But my worry is that windows 2003 server standard edition officially
support /3GB switch only for Microsoft's tested applications,
like MS Exchange Server or MS SQL Server.
For details, see http://support.microsoft.com/kb/291988/en-us.

So I think your ways are,
a) Test /3GB switch, and judge to use it or not.
b) Buy Windows OS which fully supports /3GB switch.
c) Buy EM64T H/W and Windows OS.
d) Buy Visual Studio, and recompile MySQL by yourself.

Ummm, it's really a difficult problem.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Cannot use innodb_buffer_pool great than 1,5Gb
1644
December 01, 2005 11:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.