• About PolarDB-X
  • Key Features
    • High Availability and Disaster Recovery
    • Distributed Transactions
    • Distributed Linear Scalability
    • Compatibility with the MySQL Ecosystem
    • Global Secondary Index
    • HTAP
    • Capture Data Change(CDC)
  • Quick Start
    • PXD Quick Start
    • Deploy via PXD
    • Deploy via K8S
    • Build From Source Code
  • Deploy Production Cluster
    • Deploy Process
    • Hardware and Software Configuration
    • System Configuration
    • Download Software Package
    • Installing Docker and Image Repository
    • Installing Kubernetes
    • Database Deployment (Distributed Version)
      • Deploying with PXD
      • Deploying with Kubernetes
    • Database Deployment (Centralized Version)
      • Deploying with RPM
  • Performance White Paper
    • Performance White Paper (Centralized Version)
      • Sysbench Test Report
      • TPC-C Test Report
    • Performance White Paper (Distributed Version)
      • Sysbench Test Report
      • TPC-C Test Report
  • Developer Guide
    • Connect PolarDB-X
    • SQL syntax overview
    • Limits on database development
    • Data types
      • Numeric data types
      • String data types
      • Collation types
      • Date and time data types
      • JSON types
    • Operators
      • Logical operators
      • Arithmetic operators
      • Comparison operators
      • Bitwise operators
      • Assignment operators
      • Operator precedence
    • Functions
      • Sharding functions
        • HASH
        • STR_HASH
        • UNI_HASH
        • RANGE_HASH
        • RIGHT_SHIFT
        • MM
        • DD
        • YYYYDD
        • WEEK
        • MMDD
        • YYYYMM
        • YYYYWEEK
      • Date and time functions
      • String functions
      • Conversion functions
      • Aggregate functions
      • Mathematical functions
      • Comparison functions
      • Bit functions
      • Flow control functions
      • Information functions
      • Encryption functions and compression functions
      • Window functions
      • JSON functions
      • Other functions
    • DDL statements
      • Shading Syntax
        • CREATE DATABASE
        • DROP DATABASE
        • CREATE TABLE
        • DROP TABLE
        • ALTER TABLE
        • TRUNCATE TABLE
        • RENAME TABLE
        • CREATE INDEX
        • API Reference
        • CREATE VIEW
        • DROP VIEW
      • Partition Syntax
        • CREATE DATABASE
        • DROP DATABASE
        • CREATE TABLEGROUP
        • DROP TABLEGROUP
        • ALTER TABLEGROUP
        • CREATE TABLE
        • DROP TABLE
        • ALTER TABLE
        • TRUNCATE TABLE
        • RENAME TABLE
        • CREATE INDEX
        • API Reference
        • CREATE VIEW
        • DROP VIEW
    • DML statements
      • INSERT
      • REPLACE
      • UPDATE
      • DELETE
      • SOURCE
      • EXPORT
      • LOAD DATA
    • DQL statements
      • SELECT
      • Subqueries
      • GROUPING SETS, ROLLUP, and CUBE extensions
    • Data Access Language (DAL) statements
      • DDL management statements
        • SHOW DDL
        • SHOW DDL RESULT
        • CANCEL DDL
        • PAUSE DDL
        • CONTINUE DDL
      • SHOW
        • SHOW HELP
        • Rule and topology query statements
        • Slow SQL queries
        • Statistics queries
        • SHOW PROCESSLIST
        • SHOW GLOBAL INDEX
        • SHOW INDEX
        • SHOW METADATA LOCK
        • SHOW TABLEGROUP
      • SET
        • SET statement for setting variables
        • SET CHARACTER SET
        • SET NAMES
      • CHECK TABLE
      • CHECK GLOBAL INDEX
      • KILL
      • USE
      • EXPLAIN
      • SQL throttling
    • TCL statements
    • Prepared statements
    • Permission management
      • Manage accounts and permissions
      • Manage role permissions
      • Three-role Mode Overview
      • Permission management in the three-role mode
    • Replication
    • Sequence
      • Overview
      • Limits
      • Explicit Usage
        • Create Sequence
        • Alter Sequence
        • Query Sequence
        • Drop Sequence
      • Implicit Usage
        • CREATE TABLE
        • ALTER TABLE
        • Query Table And Sequence
    • Metadatabases and data dictionaries
    • Parameters
      • Parameters for compute node settings
      • Storage layer parameters
    • Transparent Sharding Mode
      • Primary Key Splitting
      • Clustered indexes
      • Change sharding rule(DRDS mode)
      • Change partitioning rule
    • FAQ
      • DDL FAQ
      • How to use global secondary indexes
      • How to use hints
      • How to specify a timeout period for an SQL statement
      • Specify database shards to execute SQL statements
      • Scan all or specific table shards in all or specific database shards
      • How to use INDEX hints
    • Error Codes
  • PolarDB-X Operator Operations Guide
    • Installation and Deployment
      • Installation
        • Modify Data Directory
        • Modify Default Image
        • Modify Default Image Repository
      • Uninstallation
      • Upgrade
    • PolarDB-X CRD API
      • PolarDBXCluster
      • XStore
    • Operations and Management
      • Lifecycle Management
        • Create Enterprise Edition Cluster
          • Cluster Topology Rule - Node Selector
          • Cluster Topology Rule - Stateless Node Rule (Compute, Log Node)
          • Cluster Topology Rule - Stateful Node Rule (GMS, Storage Node)
          • Cluster Topology Rule - Disaster Recovery Deployment Example
          • Container Host Network Mode
          • Minimal Deployment Mode (ShareGMS)
        • Setting Up a Standard Cluster
        • Creating Read-Only Clusters
        • Deleting
        • Updating
        • Upgrading
        • Scaling Out
        • Scaling In
        • Interrupting Operations/Rolling Back
          • Exceptional Cases
        • Handling Complex Operations
        • Managing Components
          • Operations and Maintenance for Compute Nodes
            • Checking Compute Node Status
            • Liveness and Availability Configuration
            • Accessing Compute Node Containers
            • Checking Compute Node Logs
            • Recreating Compute Nodes
      • Storage Node Operation and Maintenance
        • Check Node Status
        • Login to Internal Node
        • Retrieve Internal Node Logs
        • Get Storage Node Connection Information
        • Get Storage Node Task Information
        • Delete/Rebuild Internal Node
      • Log Node Operation and Maintenance
        • Create Log Node
        • Check Node Status
        • Login to Log Node Container
        • Delete and Rebuild Log Node
      • Connect to PolarDB-X Database
        • Get Username and Password
        • K8S In-cluster Connection
        • K8S Out-of-cluster Connection
        • Internet Connection
      • Database Parameter Settings
        • CN Static Parameters
        • CN Dynamic Parameters
          • Create Database Parameter Operation Object
          • Modify Database Parameters
          • Delete Database Parameter Operation Object
        • DN Parameters
        • Parameter Templates
        • Dynamic Parameters
      • Monitoring and Alerts
        • Install Monitoring Components
        • Create Monitoring Objects for Existing Clusters
        • View Monitoring
        • Configure Prometheus + Grafana
        • Alert Configuration
      • Log Collection
        • Log Collection
        • Log Fields
      • Backup and Restore
        • Backup Set Storage Configuration
        • Cluster Backup
        • Backup Scheduling
        • Incremental Log Backup
        • Cluster Restore
        • Point-In-Time Recovery
      • Standby Rebuild
        • Health Check
        • Rebuild Follower Node
        • Rebuild Learner Node
        • Rebuild Logger Node
    • FAQ
      • How to Obtain System Component Logs
      • Cluster Creation Stuck in 'Creating' Status
      • Cluster Deletion Stuck in 'Deleting' Status
      • No Leader for Storage Node
      • Pod Restarted Inccidentally
      • Pod Not in Running State
      • Dump Memory for Compute Node
      • Copy Core File for Storage Node
      • Get Flame Graph for Compute Node
      • Get Flame Graph for Storage Node
      • Pod Blocks in ImagePullBackOff State
      • Pod Restarts after Killing a Process
      • Get Logs from a Terminated Pod
      • How to Build an Image
      • How to Turn On/Off Private RPC
      • How to Modify Transaction Policy
      • How to Create One Replica Cluster
      • Port Conflicts in Host Network
  • Replication
    • Replication
    • Import
  • Operation and Maintenance Guide
    • Account and Permissions
      • Account Management
      • Role Management
      • Triple Authority
    • Parameter Settings
      • Compute Node Parameters
      • Data Node Parameters
      • Setting Parameters
    • Import and export data
      • Use mysqldump to migrate data
      • Use a program to import data
      • Use Batch Tool to export and import data
      • PolarDB-X CDC
        • Flink
        • Kafka
        • Elasticsearch
    • SQL Concurrency Control
    • Monitor
  • SQL Tuning Guide
    • SQL query optimization rules
    • SQL execution plans
    • Advanced SQL tuning
      • Query optimizers
      • Push down and rewrite queries
      • Introduction to the query executor
      • Optimize and execute JOIN operations
      • Optimize and execute subqueries
      • Optimize and execute aggregation operations
      • Optimize and execute sorting operators
      • Execution plan management
    • Intelligent index recommendation
    • Methods that are used to optimize slow queries
  • Best Practice
    • Configure a connection pool for an application to connect to a PolarDB-X instance
    • Identify and resolve database issues
    • Handle DDL exceptions
    • Analyze and optimize slow SQL queries
    • Throttle slow SQL requests
    • Asynchronously delete the data files associated with a large table
    • Update hot rows
    • Analyze and handle data skew
    • Use IN queries in an efficient manner
    • Optimize batch insert queries
    • Optimize data import and export
    • Optimize the way in which full data is extracted
    • Use blobs
    • Practice and optimization in high concurrency scenarios
    • Practice and optimization in analysis scenarios
    • Practice and optimization of HTAP
  • Tool kit
    • Importing and Exporting Data using Batch Tool
    • Using Benchmark Boot for Performance Testing
  • Published with GitBook
  • 浙公网安备 33011002016148号
  • 浙ICP备12022327号-1016

Monitoring and Alerts

Monitoring and Alerts

Install Monitoring Components Enable Monitoring for Existing Clusters View Monitoring Configure Prometheus + Grafana Alert Configuration

results matching ""

    No results matching ""