mysql on various windows os

[jennyflower]

Hi, Ive been running some tests on MySQL. I have used a windows 2000 server with a 3GHz P4 and 1Gb RAM, a windows 2003 server with a hyper-threading 3GHz P4 and 512 Gb RAM and a Vista machine with the same spec as the 2003 machine. I ran the same test on each machine with the same data and restarting the server between tests. As the operating system got mroe recent the speed at which MySQL ran the query slowed down,

The average speeds were:
2000: 13753ms
2003: 16275ms
vista: 24497ms

These were all with a standard MySQL installs and no settings altered.

Can anyone explain why this is, i would expect the newer the operating system the faster the query ran

 

[towerbase]

The extra RAM in the Windows 2000 test compared to the Windows 2003 test probably explains the modest difference in performance.

I understood that Windows Vista required 1GB to run reasonably well and this probably explains why Vista appears to be 50% slower.

Unless you are using identical hardware running identical benchmarks, this type of comparison is probably meaningless.

Andrew
Hampshire, UK

 

[jennyflower]

Yeah I thought it would be at the mo, I am just starting to run the tests with a gig in the 2 slower machines, so Ill see how it goes from there.

 

[jennyflower]

Well i didnt really make much of a difference. The 2003 server ran slightly slower with 1gb ram and the vista machine ran 4s faster with 1gb ram. very odd indeed, the 2000 machines still wins hands down!