The page has been translated by Gen AI.
ServiceWatch Metrics
Scalable DB sends metrics to ServiceWatch. The metrics provided by default monitoring are data collected at a 1‑minute interval.
Reference
For instructions on how to view metrics in ServiceWatch, refer to the ServiceWatch guide.
Basic Metrics
The following are the basic metrics for the namespace Scalable DB(DBaaS).
The indicators whose names are shown in bold below are the indicators selected as major indicators among the basic indicators provided by Scalable DB(DBaaS). Key metrics are used to build service dashboards that are automatically created for each service in ServiceWatch.
Each metric indicates through the user guide which statistical value is meaningful when viewing that metric, and among the meaningful statistics, the values displayed in bold are the primary statistics. In the service dashboard, you can view key metrics using these primary statistical values.
OS Basic Metrics
Category | Performance items | unit | Detailed description | meaningful statistics |
|---|---|---|---|---|
| CPU | CPU Usage | Percent | CPU usage |
|
| Disk | Disk Usage | Percent | Disk usage |
|
| Disk | Disk Write Bytes | Bytes/Second | Write bandwidth (bytes/second) on block device |
|
| Disk | Disk Read Bytes | Bytes/Second | Read capacity (bytes/second) from block device |
|
| Disk | Disk Write Requests | Count/Second | Number of write requests on block device (requests per second) |
|
| Disk | Disk Read Requests | Count/Second | Number of read requests on block device (requests per second) |
|
| Disk | Average Disk I/O Queue Size | None | Average queue length of requests issued to the block device |
|
| Disk | Disk I/O Utilization | Percent | Proportion of time the block device actually handled I/O operations |
|
| Memory | Memory Usage | Percent | Memory usage |
|
| Network | Network In Bytes | Bytes/Second | Received capacity (bytes/second) on the network interface |
|
| Network | Network Out Bytes | Bytes/Second | Transmitted capacity (bytes/second) on the network interface |
|
| Network | TCP Connections | Count/Second | Current total number of successfully established TCP connections |
|
| Network | Network In Packets | Count | Number of packets received on the network interface |
|
| Network | Network Out Packets | Count | Number of packets transmitted on the network interface |
|
| Network | Network In Dropped | Count | Number of packet drops received on the network interface |
|
| Network | Network Out Dropped | Count | Number of packet drops transmitted on the network interface |
|
| Network | Network In Errors | Count | Number of packet errors received on the network interface |
|
| Network | Network Out Errors | Count | Number of packet errors transmitted on the network interface |
|
Table. OS basic metrics
Scalable DB Basic Metrics
Category | Performance items | unit | Detailed description | meaningful statistics |
|---|---|---|---|---|
| Activelock | Active locks | Count | Number of transactions in lock wait (Lock Wait) state for 1 minute (60 seconds) or longer in the InnoDB storage engine |
|
| Activesession | Active sessions | Count | Number of active sessions |
|
| Activesession | Connection usage | Percent | DB connection session usage rate |
|
| Activesession | Connections | Count | DB connection session |
|
| Activesession | Aborted Connections | Count/Minute | Number of abnormal terminated connections |
|
| Datafile | Current open files | Count | Number of file descriptors opened by the DB |
|
| Datafile | Max open files | Count | Maximum number of file descriptors the DB can open |
|
| Datafile | Open files usage | Percent | DB file maximum count utilization |
|
| InnoDB | InnoDB buffer pool hit ratio | Percent | The proportion of data read directly from memory without accessing the disk |
|
| InnoDB | Innodb row lock wait transactions | Count | Current number of InnoDB transactions waiting for a row lock |
|
| InnoDB | InnoDB row lock time | Milliseconds | Total time waited due to InnoDB row locks (in milliseconds) |
|
| InnoDB | InnoDB deadlocks | Count/Minute | Number of transactions rolled back due to deadlock |
|
| InnoDB | Table lock waits | Count/Minute | Number of waits that occurred to acquire a table lock |
|
| InnoDB | Temp disk tables | Count/Minute | Number of Temp Tables created on disk |
|
| InnoDB | Innodb log waits | Count | Number of times waited to write the redo log to disk |
|
| ProxySQL | Proxy Uptime | Seconds | Express the proxy’s uptime in seconds |
|
| ProxySQL | Backend connections(CONNECTED) | Count | Number of sessions connected to the Proxy server |
|
| ProxySQL | Client connections connected | Count | Number of client sessions currently connected to the proxy |
|
| ProxySQL | Queries routed | Count | Number of queries routed to the backend server |
|
| ProxySQL | Backend connections(ACTIVE, IDLE) | Count | Active / idle connection count per endpoint |
|
| ProxySQL | Backend server status | None | Backend server status
|
|
| ProxySQL | Backend conneciton check | Count | Backend server connection success/failure count | - |
| State | Instance state | None | Check Scalable DB status up/down
| - |
| State | Slave behind master seconds | Seconds | Replica latency (unit: seconds) |
|
| State | Slave io thread running (Replica Only) | None | I/O Thread status
| - |
| State | Slave SQL thread running (Replica Only) | None | SQL Thread status
| - |
| Tablespace | Tablespace used | Megabytes | Tablespace usage |
|
| Tablespace | Tablespace used(TOTAL) | Megabytes | Tablespace usage (total) |
|
| Transactions | Slow queries | Count | Number of queries running longer than 10 seconds |
|
| Transactions | Long transaction time | Seconds | Long Transaction time |
|
| Transactions | Wait locks | Count | Number of sessions waiting for lock |
|
| Transactions | SQL Queries/Minute | Count/Minute | Queries executed per minute |
|
Table. Scalable DB basic metrics