Monitoring

Users of Selectel Managed Databases can get information about the load on the cluster servers and working with databases. All data are presented in the form of graphs. The graphs can be viewed on the Monitoring tab on the cluster page.

Cluster Servers Watchers

vCPU

The graph shows the percentage of the cluster server cores loaded.

Load Average

The graph shows the average system load over a period of time. Load average shows the number of processes which are being executed by the cluster cores. The graph shows the indicator displayed as three values: for 1 minute, for 5 minutes, and for 15 minutes.

Memory Usage

The graph shows the taken memory without regard of the cache and OS buffers.

Disk Usage

The graph shows the used disk space.

Cluster Databases Watchers

Connections

Each line of the graph shows the number of connections to a particular cluster database. The graph also shows the total number of connections to all cluster databases.

Longest Query Execution Time

The graph shows the execution time of the longest query for the period.

Transactions

The graph shows the number of transactions per one second for each cluster database.

Row Operations

The graph shows the number of operations on all databases per one second. It shows the following types of operations:

  • tup_returned – number of rows returned by queries in this database per one second;
  • tup_fetched – number of rows fetched by queries in this database per one second;
  • tup_inserted – number of rows inserted by queries in this database per one second;
  • tup_updated – number of rows updated by queries in this database per one second;
  • tup_deleted – number of rows deleted by queries in this database per one second.

Cache Hit

The graph shows the percentage of the data read from the cache in the request (the ratio of blks_hit to the sum of blks_hit and blks_read).

Locks

The graph shows the number of locks for each cluster database.

Deadlocks

The graph shows the number of deadlocks recorded in each database.