Rein van der Mast wrote:
> So, about 10% slower on Windows - that's enough for me to know right now, thanks. [....]
>
> The only thing left is (disk) cache management. I am not that experienced when it comes to Linux
> (that is one of my arguments for using Windows instead). For windows there is something like
> SpeedDisk where a disk is read into the RAM for reading (most of my tables are 90% about SELECT
> queries) and writes are done to both RAM and disk.
I don't know anything about Windows, and I am not a MySQL expert. But Linux is known to manage quite
well its memory, in particular using all the available RAM for disk (actually file) caching when possible.
The free command on Linux gives you information about this (and you can also programmatically read the /proc/meminfo file - it is a pseudo file automagically generated by the kernel).
So it could be actually the case that the file cache of Linux makes MySQL run better on Linux than on Windows.
In addition, you can tune several memory-management kernel parameters (at least on 2.4 or 2.6 linux kernels) by reading and writing some [pseudo-] files inside /proc/sys/vm/ For details, see the linux/Documentation/filesystems/proc.txt inside your Linux kernel source directory.
Very probably, there exist important configuration paramters for MySQL regarding memory usage, but I don't know them yet.
Regards.
--
Basile STARYNKEVITCH ::::
http://starynkevitch.net/Basile/