FYI, people experiencing this problem should try to make the mysqld as
idle as possible (ie disconnect or idle the connections) and then run
truss -p NNN (where NNN is the pid of the mysqld process) and post
a typical chunk of the output.
That would give valuable info to the mysql developers.
Tim.
On Tue, Apr 10, 2001 at 03:48:26PM +0300, Heikki Tuuri wrote:
> Hi!
>
> People are reporting performance problems also from the FreeBSD port of
> Innobase. There seems to be a runaway thread which gets free sometimes
> and eats up 100 % of the CPU. It was not fixed with the latest patches to
> Innobase.
>
> I will try setting thread priorities in 3.23.37. That might help, but I
> guess the
> real reason is different. I will probably finish my work on 37 today and
> tomorrow I will try to repeat the problems on our FreeBSD computer.
>
> Regards,
>
> Heikki
>
> >Johan Andersson writes:
> >> I've had the same problem on an Intel P-III 800 w 256M RAM running
> FreeBSD 4.1-RELEASE
> >with
> >> both the distribution from the ports tree and the source dist. from
> mysql.com.
> >>
> >> I tried to solve the problem with analysing all the database traffic, but
> mysql
> >were taking all free CPU
> >> that were availble on the same database traffic (same database) that were
> running
> >fine on a debian linux
> >> machine (Pentium 166, 192M RAM) ... So something weird is happening on
> some FreeBSD
> >machines.>
> >> But I also have two machines that are _dedicated_ mysql servers of the
> same configuration,
> >but other
> >> hardware brand (motherboard, scsi controllers, disks) that runs perfect
> on the
> >same FreeBSD release!>
> >> The machine with the problem were also running Apache/PHP .. >
> >> (How )is MySQL using sharedmemory segments ? I know that Oracle takes up
> loads
> >of them and may> bring problem for apache that also needs some seg's.. ?> >
> >> Regards,> Johan Andersson> Consultant QbranchHi!
> >Can anyone of you guys come with a repeatable test case that will
> >always lead to the situation as described. Then we could try to fixit.Regards,
> >Sinisa
>
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
