Hi Michael,
Sounds like the mysqld may have been stuck in a tight loop then.
Any ideas Sinisa?
Try the truss once more if it happens again. I can't think of
anything that would cause this.
Let me know what happens, also try the truss when the server is
running normally just to see the output and make sure you know how to
do it, even on an idle server it Prints something like this:
(null)() = 0 (0x0)
gettimeofday(0x283558e8,0x0) = 0 (0x0)
clock_gettime(0x0,0xbfafefa4) = 0 (0x0)
poll(0x82df000,0x2,0x0) = 0 (0x0)
Ken
----- Original Message -----
From: "Institute For Social Ecology" <[EMAIL PROTECTED]>
To: "Ken Menzel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, August 03, 2001 12:41 AM
Subject: RE: Further FreeBSD 4.3 Issues (CPU hogging)
> Ken,
>
> Thanks for taking the time in the midst of all your priorities to
help
> me look into this problem. I was able to get the proper pid for the
> mysqld process, but running truss -p (number here) resulted in no
> return. Running truss /usr/local/libexec/mysqld resulted in the
> display I sent in my last email. Yes, mysqld was alive at the time,
> but for whatever reason truss -p did not turn out the expected
> results.
>
> On a similar note, I shutdown mysqld and restarted it a day ago.
> Since then, mysqld has been running quite reasonably. If the data I
> sent you does not point to anything, I suppose we can wait and see
if
> the server runs itself up again.
>
> Regards,
>
> Michael
> Institute for Social Ecology
>
> 1118 Maple Hill Rd.
> Plainfield, Vermont, 05667
> USA
>
> Tel./Fax. 1 (802) 454-8493
>
> http://www.social-ecology.org/
>
>
> -----Original Message-----
> From: Ken Menzel [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 02, 2001 10:41 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Further FreeBSD 4.3 Issues (CPU hogging)
>
>
> Hi Michael,
> Sorry for the delay getting back to you, we had some network
> problems here and are in the process of upgrading our 30 year old
> copper to a new 200 pair copper cable to the building (They can't do
> fiber, sigh!). Anyway, the output from truss that you sent looked
> like a normal mysqld startup. The way to run truss for debugging a
> probelm is:
> ps -ax | grep /mysqld
> get the process ID and then truss -p process ID.
> or as one command:
> truss -p `ps -ax | grep /mysqld | cut -c 1-6`
>
> Or are you saying this is what you did and there was no output at
all
> from truss? IE it was "dead"?
>
> P.S. I will be out of the office tomorrow.
> Ken
> ----- Original Message -----
> From: "Institute For Social Ecology" <[EMAIL PROTECTED]>
> To: "Ken Menzel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
> Sent: Wednesday, August 01, 2001 4:56 PM
> Subject: RE: Further FreeBSD 4.3 Issues (CPU hogging)
>
>
> > Ken,
> >
> > Thanks as always for your very helpful support. I did a
'truss -p'
> on
> > the PID and it came back empty handed. I did do a 'truss
> > /usr/local/libexec/mysqld' which spat back all sorts of goodies.
I
> > have included the output bellow. Also, as requested, below is the
> > output of mysqlbug.
> >
> > Once again, thank you for your help.
> >
> > Regards,
> >
> > Michael
> >
> > truss /usr/local/libexec/mysqld:
> >
> > __sysctl(0xbfbffac4,0x2,0x281bfba8,0xbfbffac0,0x0,0x0) = 0 (0x0)
> > mmap(0x0,32768,0x3,0x1002,-1,0x0) = 672927744
> > (0x281c1000)
> > geteuid() = 1048 (0x418)
> > getuid() = 1048 (0x418)
> > getegid() = 1048 (0x418)
> > getgid() = 1048 (0x418)
> > open("/var/run/ld-elf.so.hints",0,00) = 3 (0x3)
> > read(0x3,0xbfbffaa4,0x80) = 128 (0x80)
> > lseek(3,0x80,0) = 128 (0x80)
>
>
>
> --------------------------------------------------------------------
-
> 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
