Mysql Monitoring Graphs in Graphite

Asked by Tom

Hi ,

From the past few days , i am testing graphite for monitoring system metrics in real time graphs and i am able to find system graphs in graph. I ran the below example and able to saw graphs on graphite server GUI :

opt/graphite/examples# ls -ls example-client.py
4 -rw-r--r-- 1 root root 1950 2012-05-31 11:58 example-client.py

But i am not able to find a single document that shows how we can setup Mysql Monitoring graphs in Graphite.

I installed Diamond also and run diamond -f -r MySQLPerfCollector.py -c MySQLPerfCollector.conf but can;t see any mysql related graphs. I created separate user in mysql for graphite also.

Is dere any document or plugin that helps to monitor mysql metricess graphs in Graphite.

Thanks

Thanks

Question information

Language:
English Edit question
Status:
Answered
For:
Graphite Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Tom (eddy-adarsh) said :
#1

Ohhh, looks like no one use Graphite for mysql Monitoring.

On Fri, Feb 22, 2013 at 1:41 PM, Tom
<email address hidden>wrote:

> New question #222545 on Graphite:
> https://answers.launchpad.net/graphite/+question/222545
>
> Hi ,
>
> >From the past few days , i am testing graphite for monitoring system
> metrics in real time graphs and i am able to find system graphs in graph. I
> ran the below example and able to saw graphs on graphite server GUI :
>
> opt/graphite/examples# ls -ls example-client.py
> 4 -rw-r--r-- 1 root root 1950 2012-05-31 11:58 example-client.py
>
> But i am not able to find a single document that shows how we can setup
> Mysql Monitoring graphs in Graphite.
>
> I installed Diamond also and run diamond -f -r MySQLPerfCollector.py -c
> MySQLPerfCollector.conf but can;t see any mysql related graphs. I created
> separate user in mysql for graphite also.
>
> Is dere any document or plugin that helps to monitor mysql metricess
> graphs in Graphite.
>
>
> Thanks
>
>
> Thanks
>
> --
> You received this question notification because you asked the question.
>

Revision history for this message
Jason Dixon (jason-dixongroup) said :
#2

Nice attitude.

Revision history for this message
Tom (eddy-adarsh) said :
#3

Sorry I didn't mean that way.
Will post once i get succeeded.

On Sat, Feb 23, 2013 at 5:51 PM, Jason Dixon <
<email address hidden>> wrote:

> Your question #222545 on Graphite changed:
> https://answers.launchpad.net/graphite/+question/222545
>
> Jason Dixon posted a new comment:
> Nice attitude.
>
> --
> You received this question notification because you asked the question.
>

Revision history for this message
Tim Zehta (timzehta) said :
#4

We use collectd to gather MySQL metrics:

https://collectd.org/wiki/index.php/Plugin:MySQL

It does requires translation layer, such as bucky:

https://github.com/cloudant/bucky

or collectd-cargon:

https://github.com/indygreg/collectd-carbon

Can you help with this problem?

Provide an answer of your own, or ask Tom for more information if necessary.

To post a message you must log in.