We’re constantly striving to improve the user experience and simplify OrientDB. Starting with OrientDB 2.1.x, we moved some monitoring features that were previously only available with the OrientDB Workbench to OrientDB Studio. Enterprise Edition is still needed, as it comes with the Enterprise Profiler that enables the monitoring features. Going forward, our plan is to move most of the features available in the OrientDB Workbench to OrientDB Studio. In this way, users will need only one tool (instead of two separate products) to query, manage and monitor OrientDB instances.
To download OrientDB Enterprise Edition, which is free for development, click here. Once you’ve filled out the form and received the download link, you can start OrientDB server by following the documentation.
OrientDB Studio Features
Now let’s see which features are available with OrientDB 2.1.x. When Studio detects that the agent is installed on OrientDB, it will automatically enable the following features:
The new monitoring dashboard provides a quick overview on the status of OrientDB server instances. Some metrics are available here, such as :
A realtime chart is also available, displaying the CRUD operations done by the monitored server.
If the OrientDB server is running in distributed mode and is a member of an OrientDB cluster, Studio will display monitoring information for all nodes connected to the cluster. Each node will publish their corresponding metrics to the Hazelcast cluster and make them available to the other nodes.
Another cool feature available with OrientDB 2.1.x is the SQL Profiler. The Enterprise agent records and collects all the commands executed by the OrientDB server instance, and makes them available to Studio/Workbench.
For each command, the agent tracks:
With this information, we can easily identify which queries are executed more often and which queries perform worse or better in terms of execution time.
Server statistics and SQL profiler are the first features that we implemented in OrientDB Studio 2.1.x in order to provide a single tool for managing data and monitoring OrientDB server instances. We will provide more features in the next releases that are now only available with the OrientDB Workbench.
At the top of our list is a new cluster management feature that allows users to change the distributed configuration without restarting the OrientDB server instance.
Lead Enterprise Engineer