Hikari JDBC池监视Springboot应用程序中的DataDog
最近，我们有一个生产中断，其中第三方服务器无反应。这发生在指向MySQL DB的Spring Boot EC2微服务上。
在等待这些休息呼叫完成时，我们的服务开始投掷Springbootjpahikaricp-连接不可用，请求在30000ms之后提出时间。错误。
问题是，在进行潜在的高延期休息呼叫时，我们非常谨慎地避免保持数据库交易打开。也许不够小心？
我们在此微服务上启用了DataDog监视，但我没有看到可以帮助我们诊断问题的数据。 具体来说，我希望在我们的MySQL DB交易中一些可见性，以查看它们的开放时间比预期的时间长，因此我们可以相应地重构。
如果我查看该服务的DD APM，我可以看到HTTP请求延迟统计数据，以及显示线程计数正在蔓延的JVM指标。但是，没有关于池的交易和连接的具体统计数据。
如果我查看DD的DD APM，我可以看到查询，更新等的延迟，但这都是普通的，而与交易本身无关。
是否可以配置Spring和/或DataDog来可视化交易时间？
We recently had a production outage where a 3rd party server was non-responsive. This occurred on a Spring Boot EC2 microservice pointing to a MySQL DB.
While waiting for these REST calls to complete, our service started throwing SpringBootJPAHikariCP - Connection is not available, request timed out after 30000ms. errors.
The thing is, we are pretty careful in avoiding keeping a DB transaction open when making a potentially high-latency REST call. Perhaps not careful enough?
We have DataDog monitoring enabled on this microservice and I am not seeing data that would help us diagnose the problem. Specifically, I would like some visibility in our MySQL db transactions to see where these are being left open longer than expected so we can refactor accordingly.
If I look at DD APM for the service, I can see the HTTP request latency stats, and JVM metrics which show the thread count creeping up. But no specific stats about transactions and connections from the pool.
If I look at DD APM for the DB, I can see the latency for queries, updates, etc, but it is all ordinary and nothing about transactions themselves.
Is it possible to configure spring and/or datadog for visualizing transaction time?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论