Mysql innobase_buffer_pool_size can't be over 4GB on 32-bit systems.

Solution Verified - Updated -

Issue

  • System seams to address more than 4 Gb but it cant be used by mysql server: when trying to tune up mysql's config file,setting 'innobase_buffer_pool_size' to 10Gb which cause mysql to throw this error at startup:

[ERROR] innobase_buffer_pool_size can't be over 4GB on 32-bit systems
I can only set it to 2Gb only !

  • Is there any way to let MySQL address more than than 2 gb on a 32-bit system ?
  • Mysql innobase_buffer_pool_size can't be over 4GB on 32-bit systems.

Environment

  • Red Hat Enterprise Linux 5 32 bit

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.