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
Database Deployment (Centralized Version)
Database Deployment (Centralized Version)
results matching "
"
No results matching "
"