Thanks all. The problem is solved.
Lots of talk about TMPDIR and such so I gave all my attention to software
problems and missed the obvious.
For some reason the OS didn't recognize all the RAM and started reporting
only 128M instead of the installed 384M This led to over use of swapfile.
I love MySQL, but I have to say this experience has made me even a stronger
supporter. The fact that my 300M database even stayed online when the RAM
suddenly dropped by 65%, even though the server vars were optimized for more
RAM
Thanks
----- Original Message -----
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, January 20, 2001 5:27 AM
Subject: Re: temp tables lock unrelated tables
> Michael Griffith writes:
> > Cacheing before writing sounds like exactly the type of thing that
would
> > explain the problem. However, I'm on FreeBSD (Sorry, didn't give too
many
> > details). Anybody know if there is something similar in to bdflush
BSD?
> >
> > I did run iostat to monitor the the activity during the freeze. It
appears
> > that the writes to the disk about double the usual, but average <
1MB/s.
> > 7200 RPM SCSI Barracuda, seems like it should be able to handle more.
CPU is
> > even 50% idle
> >
> > Currently I do not have the TMPDIR on a separate physical disk from the
> > data. This is looking like the most obvious solution. But I'm still
> > confused -- I had no problems at all 48 hours ago. Now suddenly disk
> > locking.
> >
> > Thanks.
> >
>
>
> Hi!
>
> What FreeBSD ?? If any of 4.* kind, there were many important patches
> for it, especially since 10th of January.
>
> Ken Menzel has sent a lot of important details on patching of the
> latest FreeBSD generations to this list. Please read his mailings.
>
>
> Regards,
>
> Sinisa
>
> ____ __ _____ _____ ___ == MySQL AB
> /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
> /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
> /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus
> /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
> ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
> /*/ \*\ Developers Team
>
---------------------------------------------------------------------
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