1C database monitoring

In cloud ready 1C, you can track the status of your database.

For more detailed analysis, some metrics can be viewed as graphs in the dashboard:

The full set of available metrics can be exported in Prometheus format.For more information, see the Export metrics in Prometheus format subsection of the 1C Server Cluster Monitoring instructions .

The time in the control panel corresponds to the time set on your device and is independent of the region where the cluster is hosted.

note

For example, you have created a database in Novosibirsk, in the pool ru-8.On the device from which you entered the control panel, the time zone of Moscow is set.The time on the metrics charts will be displayed in the time zone of Moscow.

View 1C database metrics

In the control panel, in the top menu, click Products and select 1C Ready Cloud.
Go to the Databases section.
Open the database page → Monitoring tab.
In the Cluster Monitoring block, select the monitoring type:
- Database Server Monitoring - If you need to see metrics on cloud server resources;
- Database monitoring - if you need to see overall database load and query metrics.
Optional: filter metrics by date.
Look at the available database metrics.

Database metrics in the control panel

Database server monitoring
Database monitoring

Memory	Occupied memory without cache and temporary data in percent or GB
vCPU	Server cores utilization in percent
CPU iowait	Percentage of time the processor is idle and waiting for I/O operations to complete
Disk	Disk space occupied as a percentage or GB. It includes the part of disk space reserved for service needs
Load Average	Averages the system load over one minute, five minutes, and 15 minutes. Shows the number of operations performed
OOM	Number of operations that terminated due to memory shortage
Disk load	Speed of disk read and disk write operations per second Number of disk read and disk write operations per second
Network load	Number of bytes transmitted and received over the network interface Number of packets transmitted and received through the network interface per second

Connections
Execution time of the longest query	Execution time of the longest query in each database for a period of time
Transactions	Number of transactions per second in each database
String operations	The number of rows affected by operations in the selected database per second: `tup_deleted` - number of rows deleted by operations per second; `tup_fetched` - number of rows fetched by operations per second; `tup_inserted` - number of lines inserted by operations per second; `tup_returned` - number of lines returned by operations per second; `tup_updated` - number of rows updated by operations per second
Cache hit	What percentage of the data in the query was read from the cache
Locks	Number of locks in each database
Deadlocks	Number of mutual locks in each database