pcp
[Top] [All Lists]

Re: New version of MySQL pmda - now full featured

To: Michal Kara <lemming@xxxxxxxxxxxxxxxxxxx>
Subject: Re: New version of MySQL pmda - now full featured
From: "Nathan Scott" <nathans@xxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 23 May 2000 15:26:42 -0500
Cc: pcp@xxxxxxxxxxx
In-reply-to: Michal Kara <lemming@arthur.plbohnice.cz> "New version of MySQL pmda - now full featured" (May 22, 6:03pm)
References: <20000522100145.51612@arthur.plbohnice.cz>
Sender: owner-pcp@xxxxxxxxxxx
Hi Michal,

On May 22,  6:03pm, Michal Kara wrote:
> Subject: New version of MySQL pmda - now full featured
>    Hello!
> 
>    I have finished work on a new version of MySQL pmda. Now it should
> contain metrics for MySQL versions 3.21.x - 3.23.x. It also contains
> processlist metrics.
> 
>    The help is completed, but the problems with its instalation still
> persists - you have to manually do cp help.* /var/pcp/pmdas/mysql
> in the mysql pmda directory after doing make and make install.

When I installed your mysql PMDA, I got this message...

# ./Install 
You will need to choose an appropriate configuration for installation of
the "mysql" Performance Metrics Domain Agent (PMDA).

  collector     collect performance statistics on this system
  monitor       allow this system to monitor local and/or remote systems
  both          collector and monitor configuration for this system

Please enter c(ollector) or m(onitor) or b(oth) [b] 

Updating the Performance Metrics Name Space (PMNS) ...
Compiled PMNS contains
           97 hash table entries
          410 leaf nodes
           56 non-leaf nodes
         4236 bytes of symbol table
Installing pmchart view(s) ...
newhelp: [<stdin>:24] MYSQL.0: Unknown metric name, entry abandoned
Terminate PMDA if already installed ...
Updating the PMCD control file, and notifying PMCD ...
Check mysql metrics have appeared ... 79 warnings, 79 metrics and 0 values
# 

...and the help text does seem to work for me.  The "newhelp"
warning is fixed by this change ...

15# diff help ~/isms/pcp/src/pmdas/mysql/help
20c20
< @ MYSQLD.0 Instance domain for processlist
---
> @ MYSQL.0 Instance domain for processlist

Were there any other help text problems you saw?  (I'm currently
using the pcp-2.1.3-1 rpm on my machine)


fyi - I also noticed that there doesn't seem to be any text for the
mysql.variables.low_priority_updates metric.


> 
>    The new version can be found on
> http://k332.feld.cvut.cz/~lemming/projects/pmdamysql-1.0.0.tar.gz
> 
>                                       Michal Kara

I've added a default MYSQLD domain number to the stdpmid.add-on
file for your new PMDA...

# diff /var/pcp/pmns/stdpmid.add-on ./stdpmid.add-on
21d20
> MYSQLD                66

which will be included the next time Mark pushes a new release out
onto oss.sgi.com.

cheers.

-- 
Nathan

<Prev in Thread] Current Thread [Next in Thread>