All Documentation
GaussDB(for MySQL)
GaussDB(for MySQL)
All results for "
" in this service
All results for "
" in this service
What's New
Function Overview
Product Bulletin
Product Bulletin
Serverless DB Instances Will Be Released Commercially on Jan 19, 2024, 00:00 (GMT+08:00)
Changing URLs about GaussDB(for MySQL) in Huawei Cloud Help Center
Product Release Notes
Kernel Version Release History
Version Release Policy
Service Overview
GaussDB(for MySQL) Infographics
What Is GaussDB(for MySQL)?
Product Architecture
Basic Concepts
Product Benefits
Instance Description
Instance Specifications
Instance Statuses
DB Engines and Versions
Security
Shared Responsibilities
Identity Authentication and Access Control
Data Protection
Audit and Logs
Risk Monitoring
Fault Rectification
Certificates
Permissions Management
Constraints
Billing
Related Services
Differences Between GaussDB(for MySQL) and RDS for MySQL
Change History
Billing
Billing Overview
Billing Modes
Overview
Yearly/Monthly Billing
Pay-per-Use Billing
Billing Examples
Billing Mode Changes
Overview
Pay-per-Use to Yearly/Monthly
Yearly/Monthly to Pay-per-Use
Renewing Subscriptions
Overview
Manually Renewing a DB Instance
Auto-renewing a DB Instance
Bills
Arrears
Billing Termination
Cost Management
Cost Composition
Cost Allocation
Cost Analysis
Cost Optimization
Getting Started
Operation Guide
Step 1: Buy a DB Instance
Buying a Pay-per-Use DB Instance
Buying a Yearly/Monthly DB Instance
Buying a Serverless DB Instance
Step 2: Connect to the DB Instance
Overview
Connecting to a DB Instance Using DAS (Recommended)
Connecting to a DB Instance over a Private Network
Process
Connecting to a DB Instance from a Linux ECS
Connecting to a DB Instance from a Windows ECS
Configuring Security Group Rules
Connecting to a DB Instance over a Public Network
Process
Binding an EIP
Connecting to a DB Instance from a Linux ECS
Connecting to a DB Instance from a Windows ECS
Configuring Security Group Rules
Connecting to a DB Instance Using JDBC
Getting Started with Common Practices
Change History
User Guide
Usage Rules
Design Rules
Database Table Usage
Index Usage
Database Permissions
Development Rules
SQL Usage
Permissions Management
Creating a User and Granting GaussDB(for MySQL) Permissions
Creating a GaussDB(for MySQL) Custom Policy
Billing Management
Manually Renewing a DB Instance
Auto-Renewing a DB Instance
Changing the Billing Mode from Yearly/Monthly to Pay-per-Use
Changing the Billing Mode from Pay-per-Use to Yearly/Monthly
Unsubscribing a Yearly/Monthly Instance
Data Migration
Migration Solution Overview
Migrating Data to GaussDB(for MySQL) Using DRS
Migrating Data to GaussDB(for MySQL) Using mysqldump
Serverless
Billing
Buying a Serverless DB Instance
Changing the Compute Range of a Serverless Instance
Changing Serverless Compute Resources
Database Proxy (Read/Write Splitting)
Introducing Read/Write Splitting
Introducing Consistency Levels
Create a Proxy Instance
Configuring Connection Pools
Configuring Transaction Splitting
Configuring a Routing Policy
Assigning Read Weights
Configuring Multi-Statement Processing Mode
Changing the Specifications of a Proxy Instance
Changing the Number of Proxy Instance Nodes
Upgrading the Kernel Version of a Proxy Instance
Using a Private Domain Name for a Proxy Instance
Changing the IP Address of a Proxy Instance
Changing the Port of a Proxy Instance
Changing Consistency Level
Modifying Proxy Instance Parameters
Enabling or Disabling Access Control
Rebooting a Proxy Instance
Deleting a Proxy Instance
Introducing Read Weight Assignment Rules
Testing Read/Write Splitting Performance
Instance Lifecycle Management
Changing a DB Instance Name
Changing a DB Instance Description
Deleting a DB Instance
Rebooting a DB Instance
Rebooting a Node
Changing a Node Name
Exporting Instance Information
Introducing Heterogeneous DR Instances
Rebuilding a Deleted Instance from Recycle Bin
Instance Modifications
Changing vCPUs and Memory of a DB Instance
Changing Storage of a Yearly/Monthly DB Instance
Configuring Auto Scaling Policies
Changing a Maintenance Window
Selecting Instance Displayed Items
Upgrading a Minor Version
Upgrading the OS of a DB Instance
Read Replicas
Introducing Read Replicas
Creating a Read Replica
Managing a Read Replica
Promoting a Read Replica to the Primary Node
Deleting a Pay-per-Use Read Replica
Unsubscribing a Yearly/Monthly Read Replica
HTAP Analysis
What Is HTAP?
Constraints
Usage Rules
HTAP Instance Lifecycle Management
Creating an HTAP instance
Rebooting an HTAP Instance
Deleting an HTAP Instance
HTAP Instance Modifications
Binding and Unbinding an EIP
Scaling up Storage
Changing vCPUs and Memory
Managing Accounts
Viewing Metrics
Data Security
Configuring SSL
Data Synchronization
Introducing DDLs that Cannot Be Synchronized
Synchronizing Data
Adding or Deleting Tables in the Blacklist or Whitelist
Log Management
Viewing Slow Query Logs
Connecting to an HTAP Instance
Connecting to an HTAP Instance Through DAS
Connecting to an HTAP Instance Through JDBC
Connecting to an HTAP Instance Through HTTPS
Developer Guide
Data Type Conversion
Syntax
Database Status
DB Engines
Table Engines
Database Management
Creating a Database
Deleting a Database
Account Management (Non-Administrator)
Creating a Database Account
Resetting a Password for a Database Account
Changing Permissions for Database Accounts
Deleting a Database Account
Data Security
Resetting the Administrator Password
Changing a Security Group
Configuring Database Account Security
Configuring SSL
Enabling TDE
Data Backups
Backup Principles
Backup Types
Backup Space and Billing
Configuring a Same-Region Backup Policy
Configuring a Cross-Region Backup Policy
Enabling or Disabling Encrypted Backup
Creating a Manual Backup
Exporting Backup Information
Deleting a Manual Backup
Data Restorations
Restoring a DB Instance
Restoring Instance Data to a Specific Point in Time
Restoring Data to a DB Instance
Restoring Table Data to a Specific Point in Time
Connection Management
Binding and Unbinding an EIP
Changing a Database Port
Applying for and Changing a Private Domain Name for a DB Instance
Configuring and Changing a Private IP Address
Parameter Template Management
Creating a Parameter Template
Modifying Parameters of a GaussDB(for MySQL) DB Instance
Exporting Parameters
Comparing Parameter Templates
Viewing Parameter Change History
Replicating a Parameter Template
Resetting a Parameter Template
Applying a Parameter Template
Viewing Application Records of a Parameter Template
Editing a Parameter Template Description
Deleting a Parameter Template
Metrics and Alarms
Introducing GaussDB(for MySQL) Metrics
Viewing Monitoring Metrics
Viewing Instance Monitoring Metrics
Viewing Proxy Monitoring Metrics
Configuring Alarm Rules
Creating Alarm Rules for a DB Instance
Creating Alarm Rules for a Proxy Instance
Event Monitoring
Introducing Event Monitoring
Viewing Event Monitoring Data
Creating Alarm Rules for Event Monitoring
Events Supported by Event Monitoring
Configuring Monitoring by Seconds
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Log Management
Enabling or Disabling Log Reporting
Viewing Error Logs
Viewing Slow Query Logs
Enabling or Disabling SQL Explorer
DBA Assistant
Function Overview
Dashboard
Sessions
Performance
Slow SQL Analysis
Top SQL
SQL Insights
Concurrency Control
Task Center
Viewing a Task
Deleting a Task Record
Managing Tags
Managing Quotas
Kernel Functions
Parallel Query
Overview
Usage
Application Scenarios
Constraints
Parameters and Variables
Enabling or Disabling Parallel Query
Viewing the Statuses of Parallel Query
Performance Tests
Test Method
Test Results
Near Data Processing
NDP Overview
DDL Optimization
Parallel DDL
DDL Fast Timeout
Statement Outline
Idle Transaction Disconnection
Function
Parameter Description
Example
LIMIT...OFFSET Pushdown
Function
Usage
Performance Tests
Conversion of IN Predicates Into Subqueries
Function
Scenarios
Usage
Performance Tests
Diagnosis on Large Transactions
Change History
Best Practices
Overview
From ECS-hosted MySQL to GaussDB(for MySQL)
Overview
Resource Planning
Operation Guide
Procedure
ECS-hosted MySQL Server
Creating a VPC and Security Group
Creating an ECS (MySQL Server)
Installing a MySQL Database (Community Edition)
Creating an ECS and Installing the MySQL Client on It
Cloud Migration
Creating a GaussDB(for MySQL) Instance
Creating a DRS Migration Task
Checking the Migration Results
From Other Cloud MySQL to GaussDB(for MySQL)
Overview
Resource Planning
Operation Process
Creating a VPC and Security Group
Creating a GaussDB(for MySQL) Instance
Configuring a MySQL Instance on Other Clouds
Creating a DRS Migration Task
Checking Migration Results
Enabling Read/Write Splitting for a GaussDB(for MySQL) Instance
User Authentication
Connection Pool Configuration
Routing Read Requests to the Primary Node
Security Best Practices
Performance White Paper
Test Method
Performance Data
Read/Write Mode
Read-only Mode
Write-only Mode
API Reference
Before You Start
Overview
API Calling
Endpoints
Constraints
Concepts
API Overview
Calling APIs
Making an API Request
Authentication
Response
APIs (Recommended)
DB Engine Version Queries
Querying Version Information About a DB Engine
Database Specification Queries
Querying Database Specifications
Instance Management
Creating a DB Instance
Querying DB instances
Rebooting a DB Instance
Deleting or Unsubscribing from a DB Instance
Querying Details of a DB Instance
Querying Details of DB Instances in Batches
Creating a Read Replica
Deleting or Unsubscribing from a Read Replica
Scaling up Storage of a Yearly/Monthly DB Instance
Changing a DB Instance Name
Resetting a Database Password
Changing DB Instance Specifications
Querying Dedicated Resource Pools
Querying Dedicated Resources
Configuring the Monitoring By Seconds Function
Querying the Configuration of Monitoring by Seconds
Rebooting a Node
Upgrading the Kernel Version of a DB Instance
Enabling or Disabling SSL
Binding an EIP
Unbinding an EIP
Promoting a Read Replica to Primary
Changing a Maintenance Window
Modifying a Security Group
Changing a Private IP Address
Changing a Database Port
Changing a DB Instance Description
Applying for a Private Domain Name
Changing a Private Domain Name
Querying the Kernel Version
Modifying Auto Scaling Policies
Querying Auto Scaling Policies
Pre-Checking Resources
Backup Management
Configuring a Same-Region Backup Policy
Creating a Manual Backup
Querying Full Backups
Querying an Automated Backup Policy
Deleting a Manual Backup
Restoring Data to the Original Instance or an Existing Instance
Querying the Restoration Time Range
Enabling or Disabling Encrypted Backup
Checking Whether Encrypted Backup Is Enabled
Querying Incremental Backups
Configuring a Cross-Region Backup Policy
Restoring Tables to a Specified Point in Time
Querying Tables for Table-level Point-in-Time Recovery
Parameter Template Management
Querying Parameter Templates
Creating a Parameter Template
Deleting a Parameter Template
Obtaining Details About a Parameter Template
Modifying Parameters in a Parameter Template
Applying a Parameter Template
Replicating a Parameter Template
Comparing Parameter Templates
Querying Instances That a Parameter Template Can Be Applied To
Viewing Parameter Change History
Obtaining Parameter Information of a Specified DB Instance
Modifying Parameters of a Specified DB Instance
Replicating the Parameter Template of a DB Instance
Quota Management
Querying the Instance Quotas of a Tenant
Querying the Resource Quotas of a Specified Enterprise Project
Configuring Resource Quotas for a Specified Enterprise Project
Modifying the Resource Quotas of a Specified Enterprise Project
Querying Enterprise Projects
Database Proxy
Creating a Proxy Instance
Deleting a Proxy Instance
Querying Proxy Instances
Querying Proxy Instance Specifications
Adding Proxy Nodes
Deleting Proxy Nodes
Changing Specifications of a Proxy Instance
Assigning Read Weights
Changing the Routing Policy of a Proxy Instance
Enabling or Disabling Transaction Splitting of a Proxy Instance
Enabling or Disabling Association of New Nodes with Proxy Instances
Changing Session Consistency of a Proxy Instance
Changing the Connection Pool Type of a Proxy Instance
Changing the Port of a Proxy Instance
Modifying Parameters of a Proxy Instance
Enabling or Disabling Access Control
Configuring Access Control Rules
Enabling or Disabling SSL for a Proxy Instance
Log Management
Enabling or Disabling SQL Explorer
Querying Whether SQL Explorer Is Enabled
Querying Slow Query Logs
Querying Error Logs
Obtaining the Temporary Link for Downloading Full SQL
Tag Management
Querying Resource Tags
Querying Project Tags
Adding or Deleting Tags in Batches
Database User Management
Creating a Database Account
Querying Database Users
Deleting a Database User
Modifying Remarks of a Database User
Changing Password of a Database User
Granting Permissions to a Database User
Deleting Permissions of a Database User
Database Management
Querying Available Database Character Sets
Creating a Database
Modifying Database Remarks
Querying Databases
Deleting a Database
SQL Statement Concurrency Control
Enabling or Disabling SQL Statement Concurrency Control
Querying Whether SQL Statement Concurrency Control Is Enabled
Configuring Concurrency Control Rules of SQL Statements
Querying Concurrency Control Rules of SQL Statements
Deleting Concurrency Control Rules of SQL Statements
Task Center
Obtaining Information About a Task with a Specified ID
Obtaining Instant Tasks
Obtaining Scheduled Tasks
Canceling a Scheduled Task
Deleting a Task Record
Deleting a Scheduled Task Record
Intelligent Diagnosis
Querying Abnormal Instances by Each Metric
Querying Abnormal Instance Information by a Specific Metric
APIs (Unavailable Soon)
DB Engine Version Queries
Querying Version Information About a DB Engine
Database Specification Queries
Querying Database Specifications
Instance Management
Creating a DB Instance
Querying DB Instances
Querying DB Instances
Deleting a DB Instance
Querying Details of a DB Instance
Querying Details of DB Instances in Batches
Querying Details of a DB Instance
Creating a Read Replica
Deleting a Read Replica
Scaling up Storage of a Yearly/Monthly DB Instance
Changing a DB Instance Name
Resetting a Database Password
Modifying DB Instance Specifications
Backup Management
Modifying the Automated Backup Policy
Creating a Manual Backup
Querying Backups
Querying an Automated Backup Policy
Parameter Template Management
Querying Parameter Templates
Quota Management
Querying the Instance Quotas of a Tenant
Querying Resource Quotas
Configuring Resource Quotas
Modifying Resource Quotas
Database Proxy
Creating Proxy Instance
Deleting a Proxy Instance
Querying Information About a Proxy Instance
Querying Proxy Instance Information
Querying Proxy Instance Specifications
Adding Proxy Nodes
Log Management
Querying Database Error Logs
Querying Database Error Logs
Querying Database Slow Logs
Querying Database Slow Logs
Task Information Queries
Obtaining Information About a Task
Permissions Policies and Supported Actions
Permissions Policies and Supported Actions
GaussDB(for MySQL) Actions
Appendix
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
GaussDB(for MySQL) Monitoring Metrics
Change History
SDK Reference
SDK Overview
FAQs
Product Consulting
What Should I Pay Attention to When Using GaussDB(for MySQL)?
What Can I Do About Slow Response of Websites When They Use GaussDB(for MySQL)?
Does GaussDB(for MySQL) Support Automatic Failover?
Does GaussDB(for MySQL) Support Decoupling of Compute and Storage?
Resource Freezing, Release, Deletion, and Unsubscription
Database Connections
What Should I Do If I Can't Connect to My GaussDB(for MySQL) Instance?
Can an External Server Access the GaussDB(for MySQL) Database?
What Do I Do If the Number of GaussDB(for MySQL) Database Connections Reaches the Upper Limit?
What Is the Maximum Number of Connections to a GaussDB(for MySQL) Instance?
What Should I Do If an ECS Cannot Connect to a GaussDB(for MySQL) Instance?
How Can I Connect to a MySQL Database Through JDBC?
How Can I Create and Connect to an ECS?
What Should I Do If a Database Client Problem Causes a Connection Failure?
Why Cannot I Ping My EIP After It Is Bound to a DB Instance?
What Can I Do If the Connection Test Failed?
Can I Access a GaussDB(for MySQL) Instance over an Intranet Connection Across Regions?
Are There Any Potential Risks If There Are Too Many Connections to a GaussDB(for MySQL) Instance?
What Should I Do If an ECS and a GaussDB(for MySQL) instance Deployed in Different VPCs Cannot Communicate with Each Other?
How Do I View All IP Addresses Connected to a Database?
Client Installation
How Can I Install the MySQL Client?
Database Migration
What Types of DB Engines Does GaussDB(for MySQL) Support for Importing Data?
Database Permissions
Does GaussDB(for MySQL) Provide the Root Account or Super Permission?
Database Performance
What Should I Do If the CPU Usage of My Instance Is High?
How Do I Handle Slow SQL Statements Caused by Inappropriate Composite Index Settings?
How Do I Handle a Large Number of Temporary Tables Being Generated for Long Transactions and High Memory Usage?
What Should I Do If Locks on Long Transactions Block the Execution of Subsequent Transactions?
How Can I Use Temporary Disk of GaussDB(for MySQL)?
Database Usage
Why Are the Results Inconsistent After the MATCH AGAINST Statement Is Executed, Respectively, on Primary Nods and Read Replicas?
How Do I Add Columns Using INSTANT?
How Do I Use LOAD DATA to Import Local Data?
Backups
How Long Does GaussDB(for MySQL) Store Backup Data?
How Do I Clear GaussDB(for MySQL) Backup Space?
How Can I Back Up a GaussDB(for MySQL) Database to an ECS?
How Do I View My Backup Storage Usage?
Why Has My Automated Backup Failed?
How Is GaussDB(for MySQL) Backup Data Billed?
Database Parameter Modification
How Can I Change the Time Zone?
How Do I Configure a Password Expiration Policy for GaussDB(for MySQL) Instances?
How Do I Ensure that the Database Character Set of a GaussDB(for MySQL) Instance Is Correct?
How Do I Use the utf8mb4 Character Set to Store Emojis in a GaussDB(for MySQL) Instance?
How Do I Set Case Sensitivity for GaussDB(for MySQL) Table Names?
Can I Use SQL Commands to Modify Global Parameters?
Network Security
What Security Assurance Measures Does GaussDB(for MySQL) Have?
How Can I Prevent Untrusted Source IP Addresses from Accessing GaussDB(for MySQL)?
How Do I Configure a Security Group to Enable Access to a GaussDB(for MySQL) Instance?
How Can I Import the Root Certificate to a Windows or Linux Server?
How Do I Manage and Ensure GaussDB(for MySQL) Security?
Log Management
Can I Enable general_log for GaussDB(for MySQL)?
How Do I View All SQL Logs Executed by GaussDB(for MySQL)?
How Do I View Slow Query Logs of GaussDB(for MySQL)?
How Do I Enable and View Binlog of My GaussDB(for MySQL) Instance?
How Do I Change the Binlog Retention Period?
How Do I View Deadlock Logs of GaussDB(for MySQL)?
Version Upgrade
How Can I Check a GaussDB(for MySQL) Instance Version?
Can I Upgrade GaussDB(for MySQL) Versions of Instances?
Change History
Troubleshooting
Backup and Restoration Issues
Insufficient Permissions During Data Export Using mysqldump
How Do I use mysqlbinlog to Obtain Binlog Files?
Canal Fails to Parse Binlogs
Precautions for Exporting Large Tables Through mysqldump
Commands for Exporting Data Through mysqldump
System Inaccessible After Field Addition to a Database Table
SQL Statements Such as SET @@SESSION.SQL_LOG_BIN Displayed After You Run mysqldump
Insufficient Permissions Reported for Canal
Connection Issues
Login Failed After ssl_type of root Is Changed to ANY
Failed to Connect to a DB Instance Using SSL
Description of Each IP Address
SSL Connection Failed Due to Inconsistent TLS Versions
Error Message "connection established slowly"
"Access denied" Displayed During Database Connection
Failed to Connect to a Database Using mariadb-connector in SSL Mode
Failed to Connect to a Database as User root
Client Automatically Disconnected from a DB Instance
Disconnection Occurs Every 45 Days Due to the istio-citadel Certificate Mechanism
SQL Issues
Invalid TIMESTAMP Default Value during Table Creation
Failed to Change the VARCHAR Length Due to the Index Length Limit
Slow SQL Queries After a Large Amount of Data Is Deleted from a Large Table
Error 1366 Reported When Data Containing Emojis Is Updated
Slow Stored Procedure Execution Due to Inconsistent Collations
ERROR [1412] Reported for a DB Instance
Failed to Delete a Table with a Foreign Key
Incorrect GROUP_CONCAT Results
Error Message "Too many keys specified" Displayed When a Secondary Index Is Created
DISTINCT and GROUP BY Optimization
Equivalent Comparison Failures with Floating-Point Numbers
A Large Number of SELECT Requests Routed to The Primary Instance After Database Proxy Is Enabled
Tablespace Bloat
ERROR 1396 Reported When a User Is Created
Error Message Reported When alter table xxx discard/import tablespace Is Executed
Native Error 1461 Reported by a DB Instance
"Row size too large" Reported When a Table Failed to Be Created
Parameter-related Issues
Global Parameters Fail to Change on the Client
Connection Exit Due to Improper Timeout Parameter Settings
long_query_time Changes Fail to Take Effect
Timeout Parameters
Performance Issues
Slow SQL Execution Due to Hot and Cold Data Problems
Full Storage Caused by Complex Queries
Slow Response Due to Deadlocks
CPU Usage Increase
CPU Resource Exhaustion Caused by Too Many Concurrent Slow Queries
Basic Issues
How Do I View Used Storage of My GaussDB(for MySQL) Instance?
Auto-Increment Field Value Jump
Starting Value and Increment of AUTO_INCREMENT
Changing the AUTO_INCREMENT Value of a Table
Failed to Insert Data Because Values for the Auto-increment Primary Key Field Reach the Upper Limit
Auto-increment Field Values
AUTO_INCREMENT Not Displayed in the Table Structure
Impact of Creating an Empty Username
No Scanned Rows Recorded in Slow Query Logs
Change History
Videos
General Reference
Glossary
Service Level Agreement
White Papers
Endpoints
Permissions