A couple of notes about this thread (comparing Linux and Win32)
I have run the MySQL benchmarks on the same machine that has Linux,
Win98 and NT on different partitions.
This is AMD-K6 350 MHz, 256M RAM with IDE disks
MySQL was started with the default options.
The results where:
Win98 was 37 % faster than NT
Linux is 7 % faster than Win98 and 431 % faster than NT
The overhead of using MyODBC (and probably any ODBC driver) is at
least 19 %.
Note that while the benchmark (perl + mysqld) was running on NT, the
machine was completely dead; It was impossible to even use 'emacs' on
it to edit anything (many seconds between key presses).
On Linux, you hardly noticed that the benchmark was running...
The problem seems to be that even if NT should have a better
file-handling, any CPU and disk intensive application will starve the
system and make it unusable for anything else.