How to expose Hibernate Statistics via JMX
Imagine having a tool that can automatically detect JPA and Hibernate performance issues. Wouldn’t that be just awesome?
Well, Hypersistence Optimizer is that tool! And it works with Spring Boot, Spring Framework, Jakarta EE, Java EE, Quarkus, or Play Framework.
So, enjoy spending your time on the things you love rather than fixing performance issues in your production system on a Saturday night!
As already explained, Hibernate provides a very flexible statistics mechanism. The Hibernate metrics can be accessed either programmatically via the
org.hibernate.stat.Statistics interface or via JMX (Java Management Extensions).
In this article, you are going to see how you can expose the Hibernate statistics metrics using JMX.
By default, the Hibernate statistics mechanism is not enabled, so you need to activate it using the following configuration property:
<property name="hibernate.generate_statistics" value="true"/>
To expose the Hibernate metrics via JMX, you also need to set the
hibernate.jmx.enabled configuration property:
<property name="hibernate.jmx.enabled" value="true"/> <property name="hibernate.jmx.usePlatformServer" value="true"/>
Now, Hibernate is going to collect metrics and expose them via JMX.
Since Hibernate 5.4.2, the
Statisticsobject is now exposed via JMX. Therefore, you should consider upgrading your Hibernate version if you want to benefit from this feature.
To see the Hibernate statistics metrics via JMX, we need to open JConsole and attach a new connection to our Hibernate application. Afterward, you need to go to the
MBeans tab and locate the
org.hibernate.core package as illustrated by the following screenshot.
org.hibernate.stat.internal.StatisticsImpl MBean which provides access to all metrics supported by the Hibernate
The advantage of exposing the Hibernate statistics via JMX is that you can further export these metrics to an APM (Application Performance Monitoring) tool which aggregates metrics from different sources (e.g. OS, database, cache) and correlate them so that you get a better insight into the inner workings of your system.