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)

  • What is the result of this query : show variables like 'version_compile%'; Apr 15, 2013 at 15:09
  • What version of MySQL ? (Please run select version();) Apr 15, 2013 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();) Apr 15, 2013 at 17:13
  • MySQL version 5.5.27
    – Daniel
    Apr 15, 2013 at 20:56
  • What is the result of this query : show variables like 'version_compile%'; Apr 15, 2013 at 21:01

1 Answer 1



  • 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.

  • I'll give it a try.
    – Daniel
    Apr 15, 2013 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, 2013 at 21:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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