Does a downgrade to MySQL 3.22.x help ? (seems less work to me, but I'l
investigate the other possibilities anyway).
Sinisa Milivojevic wrote:
> Herald van der Breggen writes:
> > Hello Noor,
> >
> > I am struggling with a similar problem on a linux based system. It's a
> > Netfinity 4500R, dual pentium, RAID-5 with a rather new ServeRaid-4L
> > scsi controler.
> >
> > On certain moments, mostly in the peak hours, mysql suddenly behaves
> > weird and the load increases very very quick. The swap used is also
> > increasing very quick (was that also the case on your system ?).
> >
> > We use mysql in combination with Apache::Session which uses GET_LOCK. We
> > saw that no lock could be obtained, which could be the cause for an
> > increase og threads being used.
> >
> > At the moment the wevserver and mysql server are restarted automically
> > when the number of threads is higher than 60 (by a cron job), which is a
> > clumbsy solution of course....
> >
> > I have seen this problem with 3.23.29-beta, 3.23.30-gamma and 3.23.31.
> > I consider downgrading to 3.22.x :-/
> >
> >
> > Herald
> >
> >
>
>
> Hi!
>
> The above is an already reported problem that occurs only on SMP Linux
> on the high load.
>
> A solution is to try kernel 2.4, glibc 2.2 (when stable) and to build
> properly MySQL on that setup.
>
>
> 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