You are viewing a plain text version of this content. The canonical link for it is here.
Posted to modperl@perl.apache.org by Nigel Hamilton <ni...@turbo10.com> on 2002/09/21 16:32:21 UTC

top for apache? [OT]

Hi,
	I just found a really cool tool (mentioned in SysAdmin journal). 
It shows a dynamic picture of MySQL processes just like 'top' (see 
below).

MySQL on localhost (3.23.37)   up 2+20:24:55 [09:12:03]
 Queries Total: 543,555        Avg/Sec: 2.21  Slow: 1
 Threads Total: 13        Active: 1     Cached: 0    
 Key Efficiency: 97.87%  Bytes in: 186,667,281  Bytes out: 227,159,325

     Id      User      Host          DB   Time    Cmd Query or State                               
     --      ----      ----          --   ----    --- ----------                                   
  16776      root localhost        test      0  Query show full processlist                        
  16749    search localhost      search      1  Sleep                                              
  16745    search localhost      search      2  Sleep                                              
				....
  16746    search localhost      search     19  Sleep                                              
  16752    search localhost      search     19  Sleep                                              
  16763    search localhost      search     23  Sleep                                              

	You can see what queries are taking too long and kill queries
interactively.

	You can find it here: http://jeremy.zawodny.com/mysql/mytop

	It would be great to have a similar tool for mod_perl/apache. You
could see the memory consumption of children over time, number of requests
served, average response time etc.

	At the moment I end up repeatedly doing things like:

	ps -aux | grep apache | wc -l
		
	to see the number of children and then make guestimates of 
average per child memory consumption.

	Does anyone want to code this up over the weekend? ;-)


Nige
	
-- 
Nigel Hamilton
Turbo10 Metasearch Engine

email:	nigel@turbo10.com
tel:	+44 (0) 207 987 5460
fax:	+44 (0) 207 987 5468
________________________________________________________________________________
http://turbo10.com		Search Deeper. Browse Faster.


Re: top for apache? [OT]

Posted by Eric Cholet <ch...@logilune.com>.

--On Sunday, September 22, 2002 09:54:02 -0400 Perrin Harkins 
<pe...@elem.com> wrote:

> Nigel Hamilton wrote:
>> 	It would be great to have a similar tool for mod_perl/apache.
>
> The closest thing available is a combination of mod_status and
> Apache::Status.  If you haven't tried these yet, give them a shot.  They
> provide a good deal of information.

You might also want to check out Apache::VMonitor. From the module's
description: "This module emulates the reporting functionalities of top(1),
extended for mod_perl processes, mount(1), and df(1) utilities. It has a
visual alerting capabilities and configurable automatic refresh mode. All
the sections can be shown/hidden dynamically through the web interface."

--
Eric Cholet


Re: top for apache? [OT]

Posted by Perrin Harkins <pe...@elem.com>.
Nigel Hamilton wrote:
> 	It would be great to have a similar tool for mod_perl/apache.

The closest thing available is a combination of mod_status and 
Apache::Status.  If you haven't tried these yet, give them a shot.  They 
provide a good deal of information.

- Perrin


Re: top for apache? [OT]

Posted by darren chamberlain <dl...@users.sourceforge.net>.
* Nigel Hamilton <ni...@turbo10.com> [2002-09-21 04:31]:
> I just found a really cool tool (mentioned in SysAdmin journal). 
> It shows a dynamic picture of MySQL processes just like 'top'

[-- snip --]

> It would be great to have a similar tool for mod_perl/apache. You
> could see the memory consumption of children over time, number of
> requests served, average response time etc.

Have you seen mod_status?  It produces parsable output; you can get nice
useful info like:

   Srv  PID    Acc   M CPU    SS  Req Conn Child Slot Client    VHost Request
   0-0  6762 0/13/43 _ 12.98 85   0   0.0  0.20  0.59 127.0.0.1 foo   GET /images/header_logo2.gif HTTP/1.1
   1-0  6760 0/18/48 _ 19.44 85   1   0.0  0.42  0.68 127.0.0.1 foo   GET /images/336633.gif HTTP/1.1
   2-0  6761 0/16/46 _ 12.96 85   0   0.0  0.39  1.04 127.0.0.1 foo   GET /images/curve_white2.gif HTTP/1.1
   3-0  6763 0/15/45 _ 13.01 85   0   0.0  0.38  0.40 127.0.0.1 foo   GET /images/99cc99_h10.gif HTTP/1.1
   4-0  6764 0/11/41 _ 6.64  85   0   0.0  0.20  0.45 127.0.0.1 foo   GET /images/336633_w119.gif HTTP/1.1
   5-0  6765 0/9/39  _ 6.70  85   0   0.0  0.20  0.63 127.0.0.1 foo   GET /images/header_end2.gif HTTP/1.1
   6-0  6766 0/7/37  W 6.53  85   0   0.0  0.20  0.80 127.0.0.1 foo   GET /server-status HTTP/1.0
   7-0  6767 0/4/34  _ 0.01  85   5   0.0  0.00  0.40 127.0.0.1 foo   GET /server-status HTTP/1.0
   8-0  6768 0/1/31  _ 0.00  85   1   0.0  0.00  0.01 127.0.0.1 foo   GET /images/clear.gif HTTP/1.1
   9-0  -    0/0/30  . 13.06 105  0   0.0  0.00  0.22 127.0.0.1 foo   GET /images/curve_white2.gif HTTP/1.1
   10-0 -    0/0/3   . 0.01  1069 1   0.0  0.00  0.00 127.0.0.1 foo   GET /images/336633.gif HTTP/1.1

(darren)

PS Yes, mytop is very cool.

-- 
Do what thou wilt shall be the whole of the Law.
Love is the law, love under will.

Re: top for apache? [OT]

Posted by Kyle Oppenheim <ky...@tellme.com>.
On Sat, 21 Sep 2002, Nigel Hamilton wrote:

> 	to see the number of children and then make guestimates of
> average per child memory consumption.

I'm not sure what the equivalent for other operating systems is, but
here's a Solaris tip for the archives... we use /usr/proc/bin/pmap to
determine memory consumption:

  for p in `pgrep httpd`; do /usr/proc/bin/pmap -x $p | tail -1; done

pmap gives you the total memory usage, amount actually resident, amount
shared, and the amount not shared (private).

- Kyle