blocks|key|2617680|text|导出器有助于向端点公开主机的指标。端点可以是/metrics或/prometheus|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2617681|您需要将prometheus.yml配置为从端点抓取指标|2617682|普罗米修斯官方文件中有一份出口商名单|2617683|https://prometheus.io/docs/instrumenting/exporters/|2617684|您可以找到Oracle、MySql和PostGresSQL的导出器，以及通用的JDBC导出器。|2617685|您需要在数据库计算机上安装此导出器，以获取特定于数据库的指标。|2617686|对于与spring+boot应用程序相关的指标，比如“对数据库的查询次数”，您可以使用Micrometer+For+spring+boot+2.x编写自定义指标。|2617687|entityMap|0|LINK|mutability|MUTABLE|url^0|M|8|V|B|0|4|E|0|0|0|1F|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|13|8|@$9|14|A|15|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|16|8|@]|D|@]|E|$]]|$1|J|3|K|5|6|7|17|8|@]|D|@$9|18|A|19|1|1A]]|E|$]]|$1|L|3|M|5|6|7|1B|8|@]|D|@]|E|$]]|$1|N|3|O|5|6|7|1C|8|@]|D|@]|E|$]]|$1|P|3|Q|5|6|7|1D|8|@]|D|@]|E|$]]|$1|R|3|-4|5|6|7|1E|8|@]|D|@]|E|$]]]|S|$T|$5|U|V|W|E|$X|K]]]]

Exporters help in exposing the metrics of the hosts to the endpoint.
The endpoints can either be <code>/metrics</code> or <code>/prometheus</code>
You would need to configure your <code>prometheus.yml</code> to scrape the metrics from the endpoints
Prometheus official documentation has a list of exporters
<a href="https://prometheus.io/docs/instrumenting/exporters/" rel="nofollow noreferrer">https://prometheus.io/docs/instrumenting/exporters/</a>
You can find exporters for Oracle,MySql and PostGresSQL and a generic JDBC exporter.
You would need to install this exporter on your database machine to obtain DB specific metrics.
For spring boot application related metrics like &quot;Number of queries to the database&quot;, you can write custom metrics using Micrometer for spring boot 2.x

blocks|key|2406977|text|您可以尝试使用micrometer。这是spring+boot的指标提供程序。我目前正在做同样的事情，我并不完全知道人们可以使用测微器的所有方式。所以，希望下面的信息能对你有所帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2406978|有一些方法可以将spring+boot应用程序端点暴露给prometheus，然后您可以将grafana链接到使用prometheus。查看此link，了解如何做到这一点的示例|2406979|默认情况下，千分尺将包括JvmMemoryMetrics、UptimeMetrics等。但是，您可以在应用程序中使用以下包中提供的绑定器，方法是将其添加为bean。|2406980|io.micrometer.core.instrument.binder|code-block|syntax|javascript|2406981|例如(用Kotlin编写的代码)，|2406982|import+io.micrometer.core.instrument.binder.db.PostgreSQLDatabaseMetrics
import+io.micrometer.core.instrument.binder.jvm.ClassLoaderMetrics
import+org.springframework.context.annotation.Bean
import+org.springframework.context.annotation.Configuration
import+javax.sql.DataSource

/**
+*+Class+to+configure+binders+for+micrometer+metrics+for+this+application
+*/
@Configuration
open+class+MetricsConfiguration(private+val+dataSource:+DataSource)+{

++++@Bean
++++open+fun+jvmMemoryMetrics():+ClassLoaderMetrics+{
++++++++return+ClassLoaderMetrics()
++++}

++++@Bean
++++open+fun+dbMetrics():+PostgreSQLDatabaseMetrics+{
++++++++return++PostgreSQLDatabaseMetrics(dataSource,+"database-name")
++++}

}|2406983|如果需要，您还可以编写自定义绑定器和指标。有关这些内容的更多信息，请参阅micrometer+docs。|2406984|entityMap|0|LINK|mutability|MUTABLE|url|https://micrometer.io/docs|1|https://www.callicoder.com/spring-boot-actuator-metrics-monitoring-dashboard-prometheus-grafana/|2^0|7|A|0|0|1Z|4|1|0|0|0|0|0|10|F|2|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@$A|14|B|15|1|16]]|C|$]]|$1|D|3|E|5|6|7|17|8|@]|9|@$A|18|B|19|1|1A]]|C|$]]|$1|F|3|G|5|6|7|1B|8|@]|9|@]|C|$]]|$1|H|3|I|5|J|7|1C|8|@]|9|@]|C|$K|L]]|$1|M|3|N|5|6|7|1D|8|@]|9|@]|C|$]]|$1|O|3|P|5|J|7|1E|8|@]|9|@]|C|$K|L]]|$1|Q|3|R|5|6|7|1F|8|@]|9|@$A|1G|B|1H|1|1I]]|C|$]]|$1|S|3|-4|5|6|7|1J|8|@]|9|@]|C|$]]]|T|$U|$5|V|W|X|C|$Y|Z]]|10|$5|V|W|X|C|$Y|11]]|12|$5|V|W|X|C|$Y|Z]]]]

You can try using <a href="https://micrometer.io/docs" rel="nofollow noreferrer">micrometer</a>. This is the metrics provider for spring boot. I'm currently working on the same thing, and I'm not completely aware of all the way one can use micrometer. So, hopefully the below information will be useful for you.

There are ways to expose spring boot application endpoints to prometheus, and then you can link up grafana to use prometheus. Checkout this <a href="https://www.callicoder.com/spring-boot-actuator-metrics-monitoring-dashboard-prometheus-grafana/" rel="nofollow noreferrer">link</a> for an example on how you can do it

By default, micrometer will include the JvmMemoryMetrics, UptimeMetrics, etc,. But you can use the binders provided in the below package in your application by adding it as a bean.

<pre><code>io.micrometer.core.instrument.binder
</code></pre>

For example (code written in Kotlin),

<pre><code>import io.micrometer.core.instrument.binder.db.PostgreSQLDatabaseMetrics
import io.micrometer.core.instrument.binder.jvm.ClassLoaderMetrics
import org.springframework.context.annotation.Bean
import org.springframework.context.annotation.Configuration
import javax.sql.DataSource

/**
 * Class to configure binders for micrometer metrics for this application
 */
@Configuration
open class MetricsConfiguration(private val dataSource: DataSource) {

 @Bean
 open fun jvmMemoryMetrics(): ClassLoaderMetrics {
 return ClassLoaderMetrics()
 }

 @Bean
 open fun dbMetrics(): PostgreSQLDatabaseMetrics {
 return PostgreSQLDatabaseMetrics(dataSource, "database-name")
 }

}
</code></pre>

You can also write custom binders &amp; metrics if needed. Refer to the <a href="https://micrometer.io/docs" rel="nofollow noreferrer">micrometer docs</a> for more information on those.

How can I monitor JDBC calls(Oracle/MySql/PostgreSQL etc.) statistics for my spring boot application with Grafana/Prometheus?.
<ul>
<li>Do we have any plugin for it ?.</li>
<li>is it possible to capture this statistics through Grafana/Prometheus?</li>
</ul>
Specifically I am looking for statistics like, i.e.
<ul>
<li>How many open connection I have with database?</li>
<li>Whether my database is up or not?</li>
<li>What queries are causing longest response time etc ?.</li>
</ul>

How to monitor JDBC calls and statistics with Grafana

PostgreSQL

数据库

Kotlin

如何监控JDBC调用(Oracle/MySql/PostgreSQL等)我使用Grafana/Prometheus?的spring boot应用程序的统计信息。我们是否有相应的插件？是否可以通过捕获此统计信息具体地说，我正在寻找像这样的统计数据，即我与database?Whether有多少打开的连接我的数据库是否已启动...

问如何使用Grafana监控JDBC调用和统计信息
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用Grafana监控JDBC调用和统计信息EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用Grafana监控JDBC调用和统计信息
EN