30 September 2015
Category: orientdb
30 September 2015,
 Off

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.

Getting Started

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 is bundled with the distribution and can be accessed with a browse. If you launch OrientDB on your local machine, Studio is available here: http://localhost:2480.

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:

  • Server Statistics
  • SQL Profiler
  • Auditing (will be covered in another blog post)

 

Server Statistics

The new monitoring dashboard provides a quick overview on the status of OrientDB server instances. Some metrics are available here, such as :

  • CPU Usage
  • RAM Usage
  • DISK Usage
  • Active Connections
  • Operations per second
  • Network Requests
  • Average Latency (Distributed Mode)

studio-singleServer

A realtime chart is also available, displaying the CRUD operations done by the monitored server.

studio-chart

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.

studio-multipleServers
SQL Profiler

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:

  • Language type (SQL, Gremlin) of the command
  • Users that executed the command
  • Number of executions (Entries)
  • The average time of execution (Average)
  • Total time of execution (Total)
  • The highest time of execution (Max)
  • The lower time of execution (Min)
  • The last execution time (Last)

studio-sqlProfiler


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.


What’s Next?

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.

References:


Stay tuned,

Enrico Risa
Lead Enterprise Engineer

 

Comments are closed.