That's the weird part; it doesn't seem to be swapping at all. When trying
different combinations in my.cnf, I had key_buffer as low as 64M without
any effect.
Jon
On Mon, 7 May 2001, Joseph Bueno wrote:
> Hi,
>
> Are you sure that you need 200Mb of key_buffer cache ?
> Since your machine is obviously swapping a lot when it slows down
> (you can verify that with vmstat), I think you should try first to lower RAM usage.
> Use 'mysqladmin extended-status' and find out how much RAM you need for key_buffer
> (check 'Key_blocks_used' variable) and reduce key_buffer value.
>
> Hope this helps
> --
> Joseph Bueno
> NetClub/Trader.com
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php