bonjour,
Le jeudi 13 juillet 2006, Simon Matter a écrit...
> 1) It's a good idea to have at least as much swap space than real memory.
> I suggest to increase swap to 1-2G in your case. (of course this won't
> make your db faster).
No, not for this amount of physical memory. It was the case, in the
"past", when physical memory was small.
> 2) Without analyzing your memory situation in detail, it seems that you
> already use too much which leads to 294M of swap being used. If some of
> the 294M is related to MaxDB, it's very clear that it may slow down
> things. I think reducing cache_size may help a bit then.
I do not think so. Some parts of the executable code segment can be swapped
by the kernel, because they are accessed only when the executable is
run, some pages are swapped because of their age...
See vmstat for io concerning the swap area (and the man page).
Sorry, my english is too bad for writing about this topic...
--
jm
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
