64 bit OS vs 32 bit OS with 4GB of ram

[mitk]

Hey all,

I am currently running a 32-bit OS with 2 Cores and 4 GB of ram, I was having high loads caused by one customer on wordpress (MySQL) so i decided to take a look at MySQL tuner which informed me that allocating more then 2GB of ram for a 32-bit OS can cause instability and that I should upgrade to a 64 Bit OS so I can use all the ram i have allocated to the server.

My provider advised me of the following....

I would like to make sure you wish to actually change the bit architecture. The physical hostmachine itself, all the hardware, is running a 64 bit environment. Your specific virtualized OS isn't running 64 bit, and I wouldn't recommend doing so unless you know you specifically need it.

The nature that 64 bit works is that it will end up using more memory for all basic tasks. Many of our customers will see a large increase in their server's average memory usage when they switch to 64 bit. Basically, we only recommend that you switch when you know that your MySQL InnoDB buffer pool will specifically need that greater allocation.

So is my provider correct or should i switch over to the 64 bit OS to use all of the 4 GB of ram. My server is maxing out on SQL which is why I am looking for a solution to fix it or bring down the resources usage.

 

[cPanelMichael]

Hello

One potential solution would be to switch to the 64-bit OS and check to see if this helps improve the performance of MySQL. You could always switch back to 32-bit, depending on how much effort is required for the migration of the VPS.

Thank you.

 

[mitk]

Hoping someone else can give a little more info then just try it .. I am sure my customers don't want to go through two migrations to test the

 

[NitroHost]

Nevermind.

 

[NitroHost]

Nevermind x 2.