Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm trying to boost my InnoDB driver on my Windows 7 PC since each page request takes just about 1.7 seconds to load versus 0.002 seconds on my Ubuntu 12.10 workstation.

The setting I'm playing around with is the well-known innodb_buffer_pool_size line, which should increase the performance a lot, and it did on my Ubuntu workstation - but my Windows 7 workstation can only seem to allocate 1G of RAM, my system currently have 16GB.

If I try to exceed 4GB I get [ERROR] innobase_buffer_pool_size can't be over 4GB on 32-bit systems, so I try to allocate 3G but now my server wont start, same goes for 2G. 1GB works but did only contribute to about 0.1s worth of speed increase - which isn't much.

Is there something more I have to account for on Windows to get better performance, and why can I not allocate more than 1G of RAM? (I get no errors when I try to allocate more than 1GB, the server just won't start)

share|improve this question
    
What is the result of this query : show variables like 'version_compile%'; –  RolandoMySQLDBA Apr 15 '13 at 15:09
    
What version of MySQL ? (Please run select version();) –  RolandoMySQLDBA Apr 15 '13 at 15:18
1  
I just saw you have innobase_buffer_pool_size. Seriously, what version of MySQL are you running ? (Please run select version();) –  RolandoMySQLDBA Apr 15 '13 at 17:13
    
MySQL version 5.5.27 –  Daniel Apr 15 '13 at 20:56
    
What is the result of this query : show variables like 'version_compile%'; –  RolandoMySQLDBA Apr 15 '13 at 21:01
show 3 more comments

1 Answer

up vote 2 down vote accepted

Since

  • show variables like 'version_compile%'; gives you
    • version_compile_machine : x86
    • version_compile_os : Win32
  • Your OS is Windows 7 x64 OS

it looks like you simply need to upgrade the version of MySQL to the 64-bit Windows version.

share|improve this answer
    
I'll give it a try. –  Daniel Apr 15 '13 at 21:07
    
I switched to a x64 build and now the page generates in 0.07s with the buffer set to 12G! Now that is acceptable :) Thank you! –  Daniel Apr 15 '13 at 21:31
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.