Re: Some advisory needed (mysql, xfs, rjfs and hangups)

[Mihai RUSU <dizzy@roedu.net>]

Hi

I dont know if the kernel/fs change triggers this bug but I did hit a
similar bug with MySQL (a recent version too).
It hangs up and starts spawning lots of threads and the CPU load arround
100%. Since then I have used the binary versions from mysql.com. I VERY
MUCH recommend them (I did benchamarks and they are faster than any other
compiled version I have made, even statically linked etc...).

So try to get the last MySQL stable version, binary tar.gz (or RPM) and
install it, and see if that crasshes.

PS: The MySQL server I am talking about now has 70 days uptime, 800
millions queries and an average of 130 queries per second, its on XFS +
software RAID 1, kernel 2.4.9-13, XFS 1.0.2 release

On Wed, 8 May 2002, Tomasz Baranowski wrote:

> Hi,
>
> Afriend of mine has installed MySql on Quad processor 2GB RAM machine.
>
> Until upgrade all was working fine. He changed kernel to 2.2.x and
> fs to reiserfs and MySQL start hangup. I suggested her to change
> kernel to 2.4 and fs to XFS but this doesn't help.
>
> Due I see some similarity (change to journaled fs) I have question:
> did someone have any ideas why this happens ? What is so different
> so MySQL hangs ?
>
> It seems like it is waiting for something, during that MySql causes
> 100% load of each CPU.
>
> Regards,
> Blizbor
>
>

----------------------------
Mihai RUSU

Disclaimer: Any views or opinions presented within this e-mail are solely
those of the author and do not necessarily represent those of any company,
unless otherwise specifically stated.