graph number of processes?

[stigmata]

Hi,

is it possible to graph the number of processes like apache or mysqld via SNMP?

Regards,
stigmata

[rony]

No directly, but you could use a script to count the process names in the process table of the HOSTMIB and return a count.

PHP server would be a great way too implement this.

[fmangeant]

Hi

you can use these 2 excellent templates sets :

- MySQL Graph Collection 2.0 : http://forums.cacti.net/viewtopic.php?t=6108



- ApacheStats 0.4 : http://forums.cacti.net/viewtopic.php?t=4028

[stigmata]

hi fmangeant,

thx for this - did you know a solution to graph how much RAM the mysqld processes use? This is a very important thing for my monitorig
My problem - I'm not a programmer...


Regards,
stigmata

[stigmata]

hi fmangeant / rony,

thx for this - did you know a solution to graph how much RAM the mysqld processes use? This is a very important thing for my monitorig
My problem - I'm not a programmer...


Regards,
stigmata

[stigmata]

hi fmangeant / rony,

thx for this - did you know a solution to graph how much RAM the mysqld processes use? This is a very important thing for my monitorig
My problem - I'm not a programmer...


Regards,
stigmata

[fmangeant]

Hi

it should be possible with a little script

You can get a list of MySQL processes like this :

Code: Select all

$ snmpwalk -v 1 -c public localhost hrSWRunName | grep "mysqld"
HOST-RESOURCES-MIB::hrSWRunName.3621 = STRING: "mysqld_safe"
HOST-RESOURCES-MIB::hrSWRunName.3712 = STRING: "mysqld"
HOST-RESOURCES-MIB::hrSWRunName.3771 = STRING: "mysqld"
HOST-RESOURCES-MIB::hrSWRunName.3772 = STRING: "mysqld"
HOST-RESOURCES-MIB::hrSWRunName.3773 = STRING: "mysqld"

Parse the output, and then query each process memory size, for example :

Code: Select all

$ snmpwalk -v 1 -c public localhost hrSWRunPerfMem.3712
HOST-RESOURCES-MIB::hrSWRunPerfMem.3712 = INTEGER: 60516 KBytes

[stigmata]

hmmmm, sounds very good but my experience in programming.................. is it possible that you wrote that script? It would be very helpful for me and other cacti-user?!

Regards,
stigmata

[CactiPadawan]

i am trying to use the apache template,

Apache Statistics - Bytes / Request :
not working -> ERROR: Could not parse color in ''


Apache Statistics - Hits / s :
working but i have no title nor legends ..

Apache Statistics - kBits / s120x500
working but i have no title nor legends ..

Apache Statistics - Thread Details
working but i have no title nor legends ..

Apache Statistics - Thread Details (%)
not working -> ERROR: Could not parse color in ''


i am sorry maybe its because i dont use cacti correctly .. i am a beginner with it. But i would appreciate any answer. Thank you.

[BSOD2600]

If you're talking on a win32 host, then yes you can. I wrote a script: http://forums.cacti.net/viewtopic.php?t=6661

[stigmata]

no, these are linux-boxes...