本文為英文版的機器翻譯版本,如內容有任何歧義或不一致之處,概以英文版為準。
使用 Amazon CloudWatch 監控 Aurora DSQL
使用 CloudWatch 監控 Aurora DSQL 時,其會收集原始資料並將資料處理成可讀且近乎即時的指標。CloudWatch 會保留這些統計資料 15 個月,協助您更深入了解 Web 應用程式或服務效能。設定警示以監控特定閾值,並在符合條件時傳送通知或採取動作。檢閱下列適用於 Aurora DSQL 的用量和可觀測性指標。
如需更多資訊,請參閱 Amazon CloudWatch 使用者指南。
可觀測性和效能
此表格概述 Aurora DSQL 的可觀測性指標。其包含用於追蹤唯讀及總交易的指標,以提供整體工作負載特徵分析。將查詢逾時和 OCC 衝突率等可操作的指標都包含在內,以協助識別效能問題及並行衝突。與工作階段相關的指標,包括作用中及總體指標,可深入了解系統目前的負載。
| CloudWatch 指標名稱 | 指標 | 單位 | 說明 |
|---|---|---|---|
| ReadOnlyTransactions | Read-only transactions | none | The number of read-only transactions |
| TotalTransactions | Total transactions | none | The total number of transactions executed on the system, including read-only transactions. |
| QueryTimeouts | Query timeouts | none | The number of queries which have timed out due to hitting the maximum transaction time |
| OccConflicts | OCC conflicts | none | The number of transactions aborted due to key level OCC |
| CommitLatency | Commit Latency | milliseconds | Time spent by commit phase of query execution (P50) |
| BytesWritten | Bytes Written | bytes | Bytes written to storage |
| BytesRead | Bytes Read | bytes | Bytes read from storage |
| ComputeTime | QP compute time | milliseconds | QP wall clock time |
| ClusterStorageSize | Cluster Storage Size | bytes | Cluster size |
用量指標
Aurora DSQL 使用稱為分散式處理單元 (DPU) 的單一標準化計費單位,測量所有請求型的活動,例如查詢處理、讀取及寫入。
| CloudWatch 指標名稱 | 指標 | 維度:ResourceId | 單位 | 說明 |
|---|---|---|---|---|
| WriteDPU | Write Units | <cluster-id> | DPU | Approximates the write active-use component of your Aurora DSQL cluster DPU usage. |
| MultiRegionWriteDPU | Multi-Region Write Units | <cluster-id> | DPU | Applicable for Multi-Region clusters: Approximates the multi-Region write active-use component of your Aurora DSQL cluster DPU usage. |
| ReadDPU | Read Units | <cluster-id> | DPU | Approximates the read active-use component of your Aurora DSQL cluster DPU usage. |
| ComputeDPU | Compute Units | <cluster-id> | DPU | Approximates the compute active-use component of your Aurora DSQL cluster DPU usage. |
| TotalDPU | Total Units | <cluster-id> | DPU | Approximates the total active-use component of your Aurora DSQL cluster DPU usage. |
CDC 串流指標
Aurora DSQL 會發佈變更資料擷取 (CDC) 串流的下列指標。這些指標使用 ClusterId和 StreamId維度,因此您可以獨立監控每個 CDC 串流。如需 CDC 串流的詳細資訊,請參閱變更資料擷取 (CDC) 串流。
| CloudWatch 指標名稱 | 指標 | 單位 | 說明 |
|---|---|---|---|
| IsImpaired | Is impaired | none | Indicates whether the stream is impaired. The value is 1
when the stream is in the 受損 state, and
0 when the stream is healthy. Use this metric to create a
CloudWatch alarm that notifies you when a stream becomes impaired. |
| PublishedBytes | Published bytes | bytes | The total number of bytes that Aurora DSQL wrote to the target Kinesis data stream. |
| PublishedRecords | Published records | none | The number of CDC records that Aurora DSQL wrote to the target Kinesis data stream. |
| BehindSourceLag | Behind source lag | milliseconds | The delay, in milliseconds, between when a transaction commits in Aurora DSQL and when
the CDC system processes the resulting record. A rising value indicates
that the CDC pipeline is falling behind the write workload. If lag
grows beyond the failure threshold, the stream transitions to
失敗. |
| BytesStreamed | Bytes streamed | bytes | The total bytes streamed through the CDC pipeline for billing purposes. This metric reflects the data volume used to calculate streaming charges. |
| StreamDPU | Stream DPU | DPU | The Distributed Processing Units (DPU) consumed by the CDC stream. This metric reflects the processing cost of streaming change data. |