Hello again!
Do you know if there is any way I can see what the mysqld is doing? If it is
taking up 99% of the processor time, it is very busy doing something! I
installed the binary version and consequently only have the tools available
which came with that distribution.
Thanks,
David
Simon Green wrote:
> Is that not 98% idle and mysqld using 5% of the total CPU use! i.e. you are
> looking at vary different things?
> Simon
>
> -----Original Message-----
> From: David Allen [mailto:[EMAIL PROTECTED]]
> Sent: 21 May 2001 12:42
> To: Randy Johnson; [EMAIL PROTECTED]
> Subject: Re: CPU usage running mysql
>
> Randy,
>
> I did not receive any replies so any suggestions would be useful!. We are
> using mysql with PHP and the problem may stem from PHP "hogging" the
> database,
> but I cannot be sure.
>
> Thanks,
>
> David
>
> Randy Johnson wrote:
>
> > Dave Did you get any replies?? I am having the same problem as you and it
> > is driving me crazy...
> >
> > thanks
> >
> > randy
> >
> > -----Original Message-----
> > From: David Allen [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, May 18, 2001 8:59 AM
> > To: [EMAIL PROTECTED]
> > Subject: CPU usage running mysql
> >
> > Hi,
> >
> > We run mysql V3.22.32 (solaris 2.5.1 version ) on a Solaris 2.6 box. The
> > top command shows the mysqld running at 98.3% of cpu time when the
> > system is idling. On a Solaris 7 box runnning Solaris 7 running
> > mysql-3.22.32 (solaris 7 version) but also idle, the top command shows
> > 0.5% for the mysqld. Any ideas which is correct, how I can rectify the
> > situation and could this explain why the 2.6 box has started to run
> > slow? Stopping and restarting the mysqld has no effect on the cpu time
> > used
> >
> > Thanks,
> >
> > David
> >
> > ---------------------------------------------------------------------
> > 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
---------------------------------------------------------------------
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
