I have two mysql servers:
HP DL380 G3 4GB RAM 32bit running linux with mysql 5.0.45
HP DL180 G6 16GB RAM 64bit running win2008 with mysql 5.1.47
Here's the thing...
My linux box (32bit 4GB) will run X query in 15 seconds. My windows box (64bit 16GB) in 55 seconds. Also the windows box has dual quad core processors while the linux box has dual dual cores.
The windows box should be annihilating the linux box. Is there a way to tweak the windows mysql to work faster or should I switch it to linux? I did install the windows mysql 64bit version and chose during the install to use all the resources of the box. Nothing else is on this box but mysql. While the linux box is also a webserver.