MySQL: 32-bit vs 64-bit OS

This is a classic mistake in deploying MySQL servers in stand-alone machines, deploying it in a >3GB memory 64-bit capable machine with a 32-bit linux OS. It’s quite an epidemic actually that even hosting sites are committing this “mistake”. It’s no surprise that even us suffered the same fate in our previous MySQL servers… (we have a valid reason though)

What’s wrong with 32-bit, you say?

Simply put, MySQL won’t be able to use the remaining memory at all. MySQL is a single process, 32-bit + single process = memory limit for each process is… sounds familiar?

Anyway, you can find more information from this blog [mysqlperformanceblog.com].

If you want to check if you have a 64-bit capable cpu, you can check the links below:
http://processorfinder.intel.com/
http://www.cpuid.com/

Just look for the AMD64 or EM64T flag.

One thought on “MySQL: 32-bit vs 64-bit OS

  1. Pingback: 2010 in review « mundane idiosyncrasies

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s