> -----Original Message-----
> From: David Allen [mailto:[EMAIL PROTECTED]]
> Sent: lunes, 21 de mayo de 2001 14:36
> To: Simon Green; [EMAIL PROTECTED]
> Subject: Re: CPU usage running mysql
>
>
> 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.
First of all, compare with supported tools such as vmstat or ps to ensure
that top is correct. vmstat will not show the process itself but just total
usertime, systemtime and idletime.
You can also use Symbel ( www.setoolkit.com ), but I've experienced a bug in
this too related to cpu/process info on Solaris 6, 7 and possible also 8.
This is in all recent releases (3.0 -> 3.2) and is present in toptool.se,
aw.se and infotool.se.
Tools in Symbel that will work and give you some info about mysqld is
/opt/RICHPse/examples/pea.se this however tends to loop if you pipe the
output to awk or another program. That's another bug ;-)
For default debugging tools shipped with a standard Solaris go to
/usr/proc/bin :
# ls -al /usr/proc/bin
total 30
drwxr-xr-x 2 root bin 512 Dec 31 20:25 .
drwxr-xr-x 3 root bin 512 Dec 31 20:25 ..
lrwxrwxrwx 1 root root 15 Dec 31 20:25 pcred ->
../../bin/pcred
lrwxrwxrwx 1 root root 16 Dec 31 20:25 pfiles ->
../../bin/pfiles
lrwxrwxrwx 1 root root 16 Dec 31 20:25 pflags ->
../../bin/pflags
lrwxrwxrwx 1 root root 14 Dec 31 20:25 pldd -> ../../bin/pldd
lrwxrwxrwx 1 root root 14 Dec 31 20:25 pmap -> ../../bin/pmap
lrwxrwxrwx 1 root root 14 Dec 31 20:25 prun -> ../../bin/prun
lrwxrwxrwx 1 root root 14 Dec 31 20:25 psig -> ../../bin/psig
lrwxrwxrwx 1 root root 16 Dec 31 20:25 pstack ->
../../bin/pstack
lrwxrwxrwx 1 root root 15 Dec 31 20:25 pstop ->
../../bin/pstop
lrwxrwxrwx 1 root root 15 Dec 31 20:25 ptime ->
../../bin/ptime
lrwxrwxrwx 1 root root 15 Dec 31 20:25 ptree ->
../../bin/ptree
lrwxrwxrwx 1 root root 15 Dec 31 20:25 pwait ->
../../bin/pwait
lrwxrwxrwx 1 root root 14 Dec 31 20:25 pwdx -> ../../bin/pwdx
There are man pages for all of them. They all give useful information about
what a given process is doing.
You can also use truss.
...ofcourse you can also get some info from MySQL itself with "show
processlist"
--
Un saludo / Venlig hilsen / Regards
Jesper Frank Nemholt
Unix System Manager
Compaq Computer Corporation
Phone : +34 699 419 171
E-Mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
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
