MySQL 5.7 Performance_Schema Dashboard at Grafana

[Mauricio Borges]

Hi Team,

I have added a successful Data Source for MySQL performance_schema and information_schema at Grafana.

 Afterwards I tried import some MySQL dashboards ( ie: 10200 ) but no luck.

Any basic dashboard I could import to see summary information about MySQL performance_schema and information_schema  ?

Or what Queries I could use in a Panel to see summary information of MySQL and start get more familiar with it... ?

Using information_schema I even could build suing Query below, but I don't see no information in the graph. See the picture.

SELECT

  UNIX_TIMESTAMP(DATE_ADD(TIME_ENABLED,INTERVAL TIME_ELAPSED + 0 SECOND)) as time_sec,

  COUNT as value,

  name as metric

FROM INNODB_METRICS

where STATUS="enabled" and SUBSYSTEM="os"

Appreciate any help.

Mauricio

[Julien Pivotto]

On 15 Feb 14:05, Mauricio Borges wrote:
> Hi Team,
>

> I have added a successful Data Source for MySQL *performance_schema* and
> * information_schema* at Grafana.

> Afterwards I tried import some MySQL dashboards ( ie: 10200 ) but no luck.
>
> Any basic dashboard I could import to see summary information about MySQL

> *performance_schema* and* information_schema* ?

> Or what Queries I could use in a Panel to see summary information of MySQL
> and start get more familiar with it... ?
>

Hello,

I have used successfully the PMM dashboards in the past:
https://github.com/percona/grafana-dashboards

PMM is an open source monitoring solution partly based on prometheus and
the node_exporter, by Percona:
https://www.percona.com/software/database-tools/percona-monitoring-and-management

Note: they are not an official Prometheus project, and have
they own fork of mysql_exporter (which should be compatible with the
official one).


--
(o- Julien Pivotto
//\ Open-Source Consultant
V_/_ Inuits - https://www.inuits.eu

[Julien Pivotto]

On 15 Feb 23:15, Julien Pivotto wrote:
> On 15 Feb 14:05, Mauricio Borges wrote:
> > Hi Team,
> >
> > I have added a successful Data Source for MySQL *performance_schema* and
> > * information_schema* at Grafana.
> > Afterwards I tried import some MySQL dashboards ( ie: 10200 ) but no luck.
> >
> > Any basic dashboard I could import to see summary information about MySQL
> > *performance_schema* and* information_schema* ?
> > Or what Queries I could use in a Panel to see summary information of MySQL
> > and start get more familiar with it... ?
> >
>
> Hello,
>
> I have used successfully the PMM dashboards in the past:
> https://github.com/percona/grafana-dashboards
>
> PMM is an open source monitoring solution partly based on prometheus and
> the node_exporter, by Percona:

edit: node_exporter & the mysqld_exporter

> https://www.percona.com/software/database-tools/percona-monitoring-and-management
>
> Note: they are not an official Prometheus project, and have
> they own fork of mysql_exporter (which should be compatible with the
> official one).
>
>
> --
> (o- Julien Pivotto
> //\ Open-Source Consultant
> V_/_ Inuits - https://www.inuits.eu
>

> --
> You received this message because you are subscribed to the Google Groups "Prometheus Users" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-use...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/20200215221547.GA13905%40oxygen.