Java 如何让HikariCP指标在NewRelic中正确显示

我们有一个使用HikariCP的自定义网络应用程序帽子.该应用程序被编译为jar，然后在docker容器中启动.根据环境，当我们启动webapp.jar时，我们会通过-javaagent标志加载newrelic-agent.jar.

我们的HikariCP设置如下:

  private DataSource createDataSource() {

    final HikariConfig config = new HikariConfig();

    config.setJdbcUrl(...);
    config.setUsername(...);
    config.setPassword(...);
    config.setSchema(...);

    config.setConnectionTimeout(...);
    config.setMinimumIdle(...);
    config.setMaximumPoolSize(...);
    config.setIdleTimeout(...);

    config.setLeakDetectionThreshold(...);
    config.setMaxLifetime(...);

    config.addDataSourceProperty("cachePrepStmts", "true");
    config.addDataSourceProperty("prepStmtCacheSize", "250");
    config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");

    config.setMetricRegistry(metricsRegistry.getRegistry());

    return new HikariDataSource(config);
  }

我们创建了一个服务，该服务在应用程序启动时根据NewRelic类是否存在启动报告器.由于我们正在加载java agent，它也为我们提供了解析后的newrelic.yaml配置，我们将在下面重新使用该配置:

public class NewRelicMetricsService {

    private static final Logger logger = LoggerFactory.getLogger(NewRelicMetricsService.class);

    private final NewRelicReporter reporter;

    @Inject
    public NewRelicMetricsService(ApplicationMetricsRegistry metricRegistry) {
        NewRelicReporter tmpReporter = null;
        // Check if the NewRelic java agent has been loaded.
        try {
            Class.forName("com.newrelic.api.agent.NewRelic");
            Config config = NewRelic.getAgent().getConfig();

            SenderConfiguration sender = MetricBatchSender.configurationBuilder()
                    .apiKey(config.getValue("license_key"))
                    .useLicenseKey(true)
                    .httpPoster(new OkHttpPoster(Duration.ofSeconds(2)))
                    .build();

            MetricBatchSender metricBatchSender = MetricBatchSender.create(sender);

            // Use this to define custom attributes visible in the APM & Service.
            Attributes commonAttributes = new Attributes();

            tmpReporter = NewRelicReporter.build(metricRegistry.getRegistry(), metricBatchSender)
                                          .commonAttributes(commonAttributes)
                                          .build();

        } catch (ClassNotFoundException e) {
            logger.info("New Relic java agent has not been loaded. Metrics will not be showing in New Relic.");
        }

        this.reporter = tmpReporter;

        // Start reporting.
        start();
    }

    public void start() {
        if (reporter == null) {
            return;
        }
        reporter.start(1, TimeUnit.SECONDS);
    }

    public void stop() {
        if (reporter == null) {
            return;
        }
        reporter.stop();
    }

}

上面的代码运行良好，指标开始出现在NewRelic中低于Metrics.

然而，一旦您try 通过entity过滤指标--这些指标就无处可见.就好像指标的范围是在您看到"所有指标"的"根"实体中.

不完全确定这里出了什么问题.有人有什么 idea 吗？ 也许我们需要添加特定/额外的attributes个？