TaurusDB
TaurusDB
Enterprise Edition
All results for "
" in this service
Enterprise Edition
All results for "
" in this service
What's New
Function Overview
Product Bulletin
Product Bulletin
GaussDB(for MySQL) Will Be Renamed TaurusDB
TaurusDB Resource Display Pages Will Be Adjusted on the Console
Serverless DB Instances Will Be Released Commercially on Jan 19, 2024, 00:00 GMT+08:00
HTAP of Standard Edition Will Be Released Commercially on Jan 6, 2025, 00:00 GMT+08:00
Product Release Notes
TaurusDB Version Release Policy
Service Overview
TaurusDB Infographic
What Is TaurusDB Enterprise Edition?
Product Architecture
Basic Concepts
Advantages
Instance Description
DB Engines and Versions
DB Instance Types
Instance Specifications
Storage Types
Instance Statuses
Security
Shared Responsibilities
Identity Authentication and Access Control
Data Protection
Audit and Logs
Monitoring and Alarms
Instance DR
Certificates
Permissions
Constraints
Related Services
Differences Between TaurusDB and RDS for MySQL
Billing
Billing Overview
Billing Items
TaurusDB Instance Billing Items
HTAP Instance Billing Items
TaurusDB Cross-Region Backup Billing Items
Billing Modes
Overview
Yearly/Monthly Billing
Pay-per-Use Billing
Serverless 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
Getting Started
Buying a DB Instance and Connecting to It Using the mysql Client
Buying a DB Instance and Connecting to It Using MySQL-Front
Getting Started with Common Practices
Kernel
TaurusDB Kernel Version Release History
Common Kernel Functions
Parallel Query
Overview
Supported and Unsupported Scenarios
Enabling Parallel Query
Testing Parallel Query Performance
Near Data Processing
Introduction
Enabling or Disabling NDP
Configuring ndp_mode in Sessions
Adding a Table-level Hint
Using Other EXPLAIN Formats
DDL Optimization
Parallel DDL
DDL Fast Timeout
Non-blocking DDL
Progress Queries for Creating Secondary Indexes
Fast Binlog Positioning
Backward Index Scan
Statement Outline
Idle Transaction Disconnection
Introduction
Parameter Description
Example
LIMIT...OFFSET Pushdown
Introduction
Usage
Performance Tests
Conversion of IN Predicates Into Subqueries
Introduction
Precautions
Usage
Performance Tests
DISTINCT Optimization for Multi-Table Joins
Diagnosis on Large Transactions
Enhanced Partitioned Tables
Subpartitioning
Introduction
Precautions
RANGE-RANGE
RANGE-LIST
LIST-RANGE
LIST-LIST
HASH-HASH
HASH-KEY
HASH-RANGE
HASH-LIST
KEY-HASH
KEY-KEY
KEY-RANGE
KEY-LIST
LIST DEFAULT HASH
INTERVAL RANGE
Partition-level MDL
Hot Row Update
Multi-tenancy
Overview
Configuring Multi-tenancy
Using Multi-tenancy for Resource Isolation
Migrating Multi-tenant Data Using DRS
Column Compression
Database/Table Recycle Bin
Cold Data Preloading for Read Replicas
Self-Healing of Read Replicas upon a Replication Latency
User Guide
Suggestions on TaurusDB Instance Selection
Using IAM to Grant Access to TaurusDB
Creating an IAM User and Granting TaurusDB Permissions
Creating a TaurusDB Custom Policy
Buying a DB Instance
Buying a Pay-per-Use DB Instance
Buying a Yearly/Monthly DB Instance
Buying a Serverless DB Instance
Connecting to a DB Instance
Connection Methods
Connecting to a DB Instance Through DAS (Recommended)
Connecting to a DB Instance Through mysql (the MySQL Command-Line Client)
Connecting to a DB Instance over a Private Network
Connecting to a DB Instance over a Public Network
Connecting to a DB Instance Through MySQL-Front
Connecting to a DB Instance Through an Application
Connecting to a DB Instance Through JDBC
Connecting to a DB Instance Through Python
Connection Information Management
Configuring Security Group Rules
Binding or Unbinding an EIP
Changing a Database Port
Applying for and Changing a Private Domain Name
Configuring and Changing a Private IP Address
Database Usage
Usage Guidelines
Database Permissions
Table Design
Index Design
SQL Usage
Database Management
Creating a Database
Granting Database Permissions
Deleting a Database
Modifying the Description of a Database
Account Management (Non-Administrator)
Creating an Account
Resetting the Password of an Account
Changing Permissions for Accounts
Deleting an Account
Data Migration
Data Migration Schemes
Migrating Data to TaurusDB Using mysqldump
Migrating Data to TaurusDB Using the Export and Import Functions of DAS
Migrating Data to TaurusDB Enterprise Edition (OBT)
Instance Management
Viewing the Overall Status of DB Instances
Viewing Metrics
Instance Lifecycle Management
Changing a DB Instance or Node Name
Modifying a DB Instance Description
Rebooting a DB Instance or Node
Exporting DB Instance Information
Deleting a DB Instance
Unsubscribing from a Yearly/Monthly DB Instance
Modifying a Recycling Policy
Rebuilding a DB Instance
Configuration Changes
Changing the vCPUs and Memory of a DB Instance or Node
Changing the Storage Space of a DB Instance Manually
Configuring an Auto Scaling Policy for a DB Instance
Configuring Autoscaling for a DB Instance
Changing a Single DB Instance to a Cluster DB Instance
Changing the Maintenance Window of a DB Instance
Customizing Displayed Items of the Instance List
Enabling or Disabling Event Scheduler
Updating the OS of a DB Instance
Version Upgrades
Upgrading the Minor Version of a DB Instance
Data Backups
Backup Principles
Backup Types
Backup Space and Billing
Creating an Automated Backup
Configuring a Same-Region Backup Policy
Configuring a Cross-Region Backup Policy
Creating a Manual Backup
Enabling or Disabling Encrypted Backup
Exporting Backup Information
Data Restorations
Restoration Schemes
Restoring a DB Instance from Backups
Restoring a DB Instance to a Point in Time (PITR)
Restoring Tables to a Point in Time (PITR)
Restoring Data Across Regions
Serverless Instances
What Is a Serverless Instance?
Changing the Compute Range of a Serverless Instance
Changing the Maximum and Minimum Numbers of Serverless Read Replicas
Adding Serverless Read Replicas
Read Replica Management
Introducing Read Replicas
Adding Read Replicas to a DB Instance
Promoting a Read Replica to Primary
Deleting a Read Replica
Unsubscribing from a Read Replica
Changing the Private IP Address for Read of a Read Replica
Log Management
Introduction to TaurusDB Logs
Configuring Log Reporting
Managing Error Logs of a DB Instance
Managing Slow Query Logs of a DB Instance
Configuring SQL Explorer for a DB Instance
Querying and Downloading Binlogs
Enabling SQL Audit
Downloading SQL Audit Logs
Database Proxy (Read/Write Splitting)
What Is Database Proxy?
Creating a Proxy Instance for Read/Write Splitting
Changing Configurations of a Proxy Instance
Changing the Consistency Level of a Proxy Instance
Enabling the Connection Pool for a Proxy Instance
Enabling Transaction Splitting for a Proxy Instance
Changing the Routing Policy of a Proxy Instance
Changing Read Weights of Nodes
Changing the Multi-statement Processing Mode of a Proxy Instance
Enabling Automatic Association of New Nodes with a Proxy Instance
Enabling Access Control for a Proxy Instance
Enabling Binlog Pull for a Proxy Instance
Changing the Specifications of a Proxy Instance
Changing the Number of Nodes for a Proxy Instance
Applying for a Private Domain Name for a Proxy Instance (OBT)
Changing the Port of a Proxy Instance
Changing the Proxy Address of a Proxy Instance
Modifying Parameters of a Proxy Instance
Binding an EIP to a Proxy Instance (OBT)
Proxy Instance Lifecycle
Rebooting a Proxy Instance
Deleting a Proxy Instance
Proxy Instance Kernel Versions
Proxy Instance Kernel Version Release History
Upgrading the Kernel Version of a Proxy Instance
Using Hints for Read/Write Splitting
DBA Assistant
What Is DBA Assistant?
Performance Monitoring
Viewing the Overall Status of a DB Instance
Viewing Real-Time Performance Metrics
Problem Diagnosis
Managing Real-Time Sessions
Managing Storage
Viewing Anomaly Snapshots
Managing Locks and Transactions
SQL Analysis and Tunning
Viewing Slow Query Logs
Viewing Top SQL Statements
Creating a SQL Insights Task
Configuring SQL Throttling
Configuring Auto Throttling
Cold and Hot Data Separation
What Is Cold and Hot Data Separation?
Constraints
Configuring a Cold Table
HTAP Analysis (Standard Edition)
What Is HTAP Standard Edition?
Constraints
Getting Started with HTAP Standard Edition
Enabling Request Distribution Among Row Store and Column Store Nodes for Complex OLAP Queries
Connecting to a Standard HTAP Instance
Connecting to a Standard HTAP Instance Through DAS
Connecting to a Standard HTAP Instance Through JDBC
Instance Management
Rebooting a Standard HTAP Instance
Rebooting a Node of a Standard HTAP Instance
Deleting a Pay-per-Use Standard HTAP Instance
Unsubscribing from a Yearly/Monthly Standard HTAP Instance
Configuration Changes
Changing the Nodes Specifications of a Standard HTAP Instance
Changing Storage Space of a Standard HTAP Instance
Adding Read Replicas to a Standard HTAP Instance
Setting a Repair Mode for Abnormal Tables
Adjusting Blacklisted or Whitelisted Tables of a Standard HTAP Instance and Repairing Tables
Instance Upgrades
Upgrading the Minor Version of a Standard HTAP Instance
Data Synchronization Using Standard HTAP Instances
Replicating and Rebuilding a Synchronization Task (OBT)
Data Security
Configuring SSL for a Standard HTAP Instance
Log Management
Viewing Error Logs of a Standard HTAP Instance
Viewing Slow Query Logs of a Standard HTAP Instance
DBA Assistant
What Is DBA Assistant of HTAP Standard Edition?
Configuring SQL Throttling for a Standard HTAP Instance
Configuring Auto Throttling for a Standard HTAP Instance
Monitoring Metrics and Event Alarms
Viewing Metrics of a Standard HTAP Instance or Nodes
Event Monitoring for Standard HTAP Instances
Account Management
Syntax and Data Type Mappings Between HTAP and TaurusDB Instances
Performance Tuning
Security and Encryption
Configuring Database Security
Resetting the Administrator Password
Changing the Security Group of a DB Instance
Configuring SSL for a DB Instance
Enabling TDE for a DB Instance
Parameter Management
Viewing Parameters of a DB Instance
Modifying Parameters of a DB Instance
Viewing Suggestions on TaurusDB Parameter Tuning
Introducing the High-Performance Parameter Template
Using a Parameter Template
Creating a Custom Parameter Template
Applying a Parameter Template
Replicating a Parameter Template
Resetting a Parameter Template
Comparing Parameter Templates
Exporting a Parameter Template
Modifying the Description of a Parameter Template
Deleting a Parameter Template
Multi-primary Instances (OBT)
What Is a Multi-primary Instance?
Buying and Connecting to a Multi-primary Instance
Adding Read/Write Nodes to a Multi-primary Instance
Deleting a Read/Write Node of a Multi-primary Instance
Application Lossless and Transparent (ALT)
What Is ALT?
Enabling ALT
Example: Using ALT to Promote a Read Replica to Primary
RegionlessDB Clusters (OBT)
What Is a RegionlessDB Cluster?
Using a RegionlessDB Cluster for Remote Multi-Active DR
Using a RegionlessDB Cluster for Remote DR
Performing a Failover in a RegionlessDB Cluster
Removing a Standby Instance from a RegionlessDB Cluster
Deleting a RegionlessDB Cluster
Viewing the Replication Latency and Traffic of a RegionlessDB Cluster
Metrics and Alarms
TaurusDB Metrics
Viewing TaurusDB Metrics
Configuring Monitoring by Seconds
Configuring TaurusDB Alarm Rules
Event Monitoring
Introducing Event Monitoring
Viewing Event Monitoring Data
Creating Alarm Rules for Event Monitoring
Events Supported by Event Monitoring
Interconnection with CTS
Key Operations Supported by CTS
Viewing Tracing Events
Task Center
Viewing a Task
Deleting a Task Record
Tag Management
Quota Management
TaurusDB Memory Acceleration
Overview
Enabling and Using Memory Acceleration
Modifying and Deleting a Memory Acceleration Rule
Viewing and Removing Mappings
Best Practices
Overview
From ECS-hosted MySQL to TaurusDB
Overview
Resource Planning
Operation Process
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 a MySQL Client on It
Cloud Migration
Creating a TaurusDB Instance
Creating a DRS Migration Task
Checking the Migration Results
From Other Cloud MySQL to TaurusDB
Overview
Resource Planning
Creating a VPC and Security Group
Creating a TaurusDB Instance
Configuring a MySQL Instance on Other Clouds
Creating a DRS Migration Task
Checking Migration Results
Enabling Read/Write Splitting
User Authentication
Connection Pool Configuration
Routing Read Requests to the Primary Node
Backup and Restoration Best Practices
Restoration Methods
Restoring Data of a Deleted Instance
Restoring Data of Multiple Deleted Databases
Restoring Data of Deleted Tables
Security Best Practices
Enabling Cold and Hot Data Separation
Suggestions on TaurusDB Metric Alarm Configuration
Performance White Paper
Test Method
Performance Data
Read/Write Mode
Read-only Mode
Write-only Mode
API Reference
Before You Start
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
Rebooting a DB Instance
Deleting/Unsubscribing from a DB Instance
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 Monitoring by Seconds
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
Changing a Security Group
Changing a Private IP Address
Changing a Database Port
Modifying the Description of a DB Instance
Applying for a Private Domain Name
Changing a Private Domain Name
Querying the Kernel Version
Configuring an Auto Scaling Policy
Querying an Auto Scaling Policy
Pre-Checking Resources
Querying DB Instances
Querying Details of a DB Instance
Querying Details of DB Instances in Batches
Configuring a Recycling Policy
Querying a Recycling Policy
Querying Instances in the Recycle Bin
Changing Node Names in Batches
Querying Historical Records of Auto Scaling
Setting a Policy for a Serverless DB Instance
Changing the Failover Priority of a Read Replica
Querying an EIP
Querying a Storage Autoscaling Policy
Modifying a Storage Autoscaling Policy
Querying Database and Table Information of an Instance
Upgrading Minor Versions of Instances in Batches
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 Available Tables for Table-level PITR
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
Querying Application Records of a Parameter Template
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 the Specifications of a Proxy Instance
Assigning Read Weights
Changing the Routing Policy of a Proxy Instance
Enabling or Disabling Transaction Splitting for a Proxy Instance
Enabling or Disabling Automatic 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
Upgrading the Kernel Version of a Proxy Instance
Changing the Name of a Proxy Instance
Querying Access Control Settings of a Proxy Instance
Querying the Minor Version of a Proxy Instance
Modifying Parameters of a Proxy Instance
Querying Kernel Parameters of a Proxy Instance
Enabling or Disabling Access Control
Configuring Access Control Rules
Enabling or Disabling SSL for a Proxy Instance
Rebooting a Proxy Instance
Querying Proxy Instance Specifications by AZ
Applying for a Private Domain Name for a Proxy Instance
Changing the Private Domain Name of a Proxy Instance
Deleting the Private Domain Name of 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
Querying LTS Configurations of an Instance
Deleting LTS Configurations in Batches
Creating LTS Configurations in Batches
Querying Whether Show Original Log Is Enabled
Enabling or Disabling Show Original Log
Querying Slow Query Log Statistics
Obtaining Links for Downloading Slow Query Logs
Downloading an Error Log
Obtaining Audit Logs
Setting SQL Audit
Querying the Policy for SQL Audit Logs
Obtaining Links for Downloading Audit Logs
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 Database Users
Modifying the Description 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
Querying Databases
Deleting a Database
Modifying the Description of a Database
Traffic Management
Enabling or Disabling SQL Throttling
Querying Whether SQL Throttling Is Enabled
Configuring SQL Throttling Rules
Querying SQL Throttling Rules
Deleting SQL Throttling Rules
Querying User Session Threads on a Node
Terminating User Session Threads on a Node
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
HTAP (Standard Edition)
Restoring a Data Synchronization Task for a StarRocks Instance
Querying Tables of a Primary HTAP Instance
Stopping a Data Synchronization Task for a StarRocks Instance
Checking Table Configurations for HTAP Data Synchronization
Creating a StarRocks Instance
Querying a StarRocks Instance
Deleting a StarRocks Instance
Rebooting a StarRocks Instance
Rebooting a StarRocks Node
Checking StarRocks Resources
Querying HTAP Engine Resources
Obtaining the Storage Type of an HTAP Instance
Querying Specifications of an HTAP Instance
Querying HTAP Instances
Creating a Data Synchronization Task for a StarRocks Instance
Deleting a Data Synchronization Task for a StarRocks Instance
Querying Data Synchronization Tasks of a StarRocks Instance
Modifying StarRocks Data Synchronization Configurations
Checking Database Configurations for HTAP Data Synchronization
Querying Configurations of a StarRocks Data Synchronization Task
Querying Database Parameter Settings for StarRocks Data Synchronization
Querying Databases of a StarRocks Instance
Querying Database Accounts of a StarRocks Instance
Creating a Database Account for a StarRocks Instance
Deleting a Database Account of a StarRocks Instance
Changing the Password of a Database Account for a StarRocks Instance
Changing Permissions of a Database Account for a StarRocks Instance
Changing the Specifications of a StarRocks Instance
Querying Parameters
Modifying Parameters
Enabling Assign Requests to Row and Column Store Nodes for a StarRocks Instance
Comparing Parameters
Upgrading the Kernel Version of a StarRocks Instance
Querying Databases of a Primary HTAP Instance
Querying Error Logs
Changing the Security Group of a StarRocks Instance
Querying LTS Configurations of an Instance
Querying Node Information
Multi-tenancy
Querying the Status of Multi-tenancy
Enabling or Disabling Multi-tenancy
Historical APIs
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
Querying Available Tables for Table-level PITR
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
TaurusDB Actions
Appendix
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
TaurusDB Metrics
SDK Reference
SDK Overview
FAQs
Product Consulting
Is There Anything Special I Need to Note When Using TaurusDB?
What Can I Do About Slow Responses of Websites When They Use TaurusDB?
Resource Freezing, Unfreezing, Release, Deletion, and Unsubscription
Database Connections
What Should I Do If I Can't Connect to My TaurusDB Instance?
What Should I Do If an ECS Can't Connect to a TaurusDB Instance?
Can an External Server Access a TaurusDB Instance?
What Is the Maximum Number of Connections to a TaurusDB Instance?
What Do I Do If There Are Too Many Database Connections?
Are There Any Risks If There Are Too Many Connections to a TaurusDB Instance?
What Should I Do If the Network Connectivity Test Fails?
Can I Access a TaurusDB Instance over an Intranet Connection Across Regions?
How Do I Check the Connections to a TaurusDB Instance?
How Do I Enable Availability Detection for a Connection Pool in the Service Code?
Client Installation
How Can I Install a MySQL Client?
Database Migration
What Types of DB Engines Does TaurusDB Support for Importing Data?
Database Permissions
Does TaurusDB Provide the Root Account or Super Permissions?
Database Performance
What Should I Do If the CPU Usage of My TaurusDB 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 Disks of TaurusDB?
What Is the CPU Usage of a TaurusDB Instance with Empty Load?
Database Usage
Why Are the Results Inconsistent After the MATCH AGAINST Statement Is Executed, Respectively, on the Primary Node and Read Replicas?
How Do I Add Columns Using INSTANT?
How Do I Use LOAD DATA to Import Local Data?
How Do I Write Data to or Create Indexes for an Ultra-large Table?
What Are the Risks of Deleting an Index from an Ultra-large Table?
What Should I Do If a MySQL Auto-Increment Primary Key Reaches the Maximum Value?
Backups
How Long Does TaurusDB Store Backup Data?
How Can I Check and Clear My TaurusDB Backup Space?
How Can I Back Up a TaurusDB Database to an ECS?
Why Did My Automated Backup Fail?
How Is TaurusDB Backup Data Billed?
Database Parameter Modification
How Do I Change the Time Zone of a TaurusDB Instance?
What Parameters Should I Pay Attention to When Creating a DB Instance?
How Do I Configure a Password Expiration Policy for TaurusDB Instances?
How Do I Ensure that the Database Character Set of a TaurusDB Instance Is Correct?
How Do I Use the utf8mb4 Character Set to Store Emojis in a TaurusDB Instance?
How Do I Set Case Sensitivity for TaurusDB Table Names?
Can I Use SQL Commands to Modify Global Parameters of My TaurusDB Instance?
Network Security
How Can I Prevent Untrusted Source IP Addresses from Accessing TaurusDB?
How Can I Import the Root Certificate to a Windows or Linux Server?
Log Management
Can I Enable general_log for TaurusDB?
How Do I View All SQL Statements Executed by TaurusDB?
How Do I Enable Binlog and View Binlog Files of My TaurusDB Instance?
How Do I Change the Binlog Retention Period?
How Do I View Deadlock Logs of TaurusDB?
Why Are Slow SQL Statements Displayed in Slow Query Log Monitoring, but No Information About Them Is Displayed on the Slow Query Logs Tab in the Logs Module?
Version Upgrade
How Can I Check the Version of a TaurusDB Instance?
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 Privileges 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
Duplicate Data Exists After ORDER BY LIMIT Is Executed
Error Message Reported When select * from sys.innodb_lock_waits Is Executed
Parameter-related Issues
Global Parameters Failed to Be Modified on the Client
Connection Exit Due to Improper Timeout Parameter Settings
long_query_time Changes Fail to Take Effect
Timeout Parameters
Performance Issues
High CPU Usage
Out of Memory (OOM) Errors
Tablespace Bloat
Read Replica Uses Far More Storage Than the Primary Node
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 the Used Storage of My TaurusDB Instance?
Renaming Databases and Tables
Character Set and Collation Settings
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
"handle_sync_msg_from_slave my_net_read error:-1" Displayed on the Error Logs Tab Page
ERROR 1290 (HY000): The MySQL server is running with the --sql-replica-on option so it cannot execute this statement
Videos
General Reference
Glossary
Service Level Agreement
White Papers
Endpoints
Permissions