TaurusDB
TaurusDB

    All results for "" in this service

      All results for "" in this service

      • What's New
      • Function Overview
      • Service Overview
        • What Is TaurusDB?
        • Product Architecture
        • Basic Concepts
        • Product Benefits
        • Instance Description
          • Instance Specifications
          • Instance Statuses
          • DB Engines and Versions
          • Storage Types
        • Permissions
        • Constraints
        • Related Services
        • Differences Between TaurusDB and RDS for MySQL
      • 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
      • User Guide
        • Permissions Management
          • Creating a 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
        • Connecting to a DB Instance
          • Connection Methods
          • Connecting to a DB Instance Using DAS (Recommended)
          • Connecting to a DB Instance Through the mysql 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 JDBC
          • Connection Information Management
            • Configuring Security Group Rules
            • Binding an EIP
            • Changing a Database Port
            • Configuring and Changing a Private IP Address
        • Database Usage
          • Usage Rules
            • Database Permissions
            • Table Design
            • Index Design
            • SQL Usage
          • 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 Migration
          • Migrating Data to TaurusDB Using mysqldump
        • Instance Management
          • Instance Lifecycle Management
            • Changing a DB Instance Name
            • Changing a DB Instance Description
            • Deleting a DB Instance
            • Rebooting a DB Instance
            • Changing a Node Name
            • Exporting Instance Information
            • Rebuilding a Deleted Instance from Recycle Bin
          • Instance Modifications
            • Changing vCPUs and Memory of a DB Instance
            • Configuring Auto Scaling Policies
            • Changing a Maintenance Window
            • Selecting Instance Displayed Items
            • Upgrading a Minor Version
            • Enabling or Disabling Event Scheduler
        • Billing Management
          • 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 Backups
          • Backup Principles
          • Backup Types
          • Configuring a Same-Region Backup Policy
          • 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
        • Read Replicas
          • Introducing Read Replicas
          • Creating a Read Replica
          • Promoting a Read Replica to the Primary Node
        • Database Proxy (Read/Write Splitting)
          • Introducing Read/Write Splitting
          • Introducing Consistency Levels
          • Creating a Proxy Instance
          • Configuring Connection Pools
          • Configuring Transaction Splitting
          • Configuring a Routing Policy
          • Assigning Read Weights
          • Changing the Specifications of a Proxy Instance
          • Changing the Number of Nodes for a Proxy Instance
          • 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 Automatic Association of New Nodes with a Proxy Instance
          • Enabling or Disabling Access Control
          • Binding an EIP to or Unbinding an EIP from a Proxy Instance
          • Rebooting a Proxy Instance
          • Deleting a Proxy Instance
          • Using Hints for Read/Write Splitting
          • Testing Read/Write Splitting Performance
        • DBA Assistant
          • Function Overview
          • Dashboard
          • Sessions
          • Performance
          • Slow Query Logs
          • Top SQL
          • SQL Insights
          • Concurrency Control
          • Auto Flow Control
          • Storage Analysis
          • Anomaly Diagnosis
        • Parameter Template Management
          • Creating a Parameter Template
          • Modifying Parameters of a TaurusDB 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
        • Data Security
          • Resetting the Administrator Password
          • Changing a Security Group
          • Configuring SSL
          • Enabling TDE
        • Metrics and Alarms
          • Supported Monitoring Metrics
          • Viewing Monitoring Metrics
            • Viewing Instance Monitoring Metrics
          • Configuring Alarm Rules
            • Creating Alarm Rules for a DB Instance
          • Configuring Monitoring by Seconds
        • Logs and Auditing
          • Enabling or Disabling Log Reporting
          • Managing Error Logs
          • Managing Slow Query Logs
          • Enabling or Disabling SQL Explorer
          • Interconnection with CTS
            • Key Operations Supported by CTS
            • Viewing Tracing Events
        • Task Center
          • Viewing a Task
          • Deleting a Task Record
        • Managing Tags
        • Managing Quotas
      • Best Practices
        • 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
      • Performance White Paper
        • Test Method
        • Performance Data
          • Read/Write Mode
          • Read-only Mode
          • Write-only Mode
      • SDK Reference
        • SDK Overview
      • API Reference
        • Before You Start
        • Calling APIs
          • Making an API Request
          • Authentication
          • Response
        • APIs (Recommended)
          • API Version Queries
            • Querying API Versions
            • Querying API Information of a Specified Version
          • 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 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
            • 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
            • Querying DB Instances
            • Querying Details of a DB Instance
            • Querying Details of DB Instances in Batches
            • Modifying a Recycling Policy
            • Querying a Recycling Policy
            • Querying Instances in the Recycle Bin
            • Changing Node Names in Batches
            • Querying Historical Records of Auto Scaling
            • Changing the Failover Priority of a Read Replica
            • Querying an EIP
          • 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
            • Querying Incremental Backups
            • Restoring Tables to a Specified Point in Time
          • 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
          • Log Management
            • Enabling or Disabling SQL Explorer
            • Querying Whether SQL Explorer Is Enabled
            • 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 Database Error Logs
            • Querying Database Slow 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
            • Modifying the Description of a Database
            • Querying Databases
            • Deleting a Database
          • SQL Throttling
            • 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
        • 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 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
          • TaurusDB Actions
        • Appendix
          • Abnormal Request Results
          • Status Codes
          • Error Codes
          • Obtaining a Project ID
          • TaurusDB Metrics
        • Change History
      • FAQs
        • Product Consulting
          1. What Should I Pay Attention to When Using TaurusDB?
          2. What Can I Do About Slow Response of Websites When They Use TaurusDB?
          3. Does TaurusDB Support Automatic Failover?
          4. Does TaurusDB Support Decoupling of Compute and Storage?
        • Database Connections
          1. Can an External Server Access TaurusDB?
          2. What Do I Do If the Number of TaurusDB Connections Reaches the Upper Limit?
          3. What Is the Maximum Number of Connections to a TaurusDB Instance?
          4. What Should I Do If an ECS Cannot Connect to a TaurusDB Instance?
          5. How Can I Connect to a MySQL Database Through JDBC?
          6. How Can I Create and Connect to an ECS?
          7. What Should I Do If a Database Client Problem Causes a Connection Failure?
          8. Why Cannot I Ping My EIP After It Is Bound to a DB Instance?
          9. What Can I Do If the Connection Test Failed?
          10. Can I Access a TaurusDB Instance over an Intranet Connection Across Regions?
          11. Are There Any Potential Risks If There Are Too Many Connections to a TaurusDB Instance?
          12. What Should I Do If an ECS and a TaurusDB Instance Deployed in Different VPCs Cannot Communicate with Each Other?
          13. How Do I View All IP Addresses Connected to a Database?
        • Client Installation
          1. How Can I Install the MySQL Client?
        • Database Migration
          1. What Types of DB Engines Does TaurusDB Support for Importing Data?
        • Database Permissions
          1. Does TaurusDB Provide the Root Account or Super Permission?
        • Database Performance
          1. What Should I Do If the CPU Usage of My TaurusDB Instance Is High?
          2. How Do I Handle Slow SQL Statements Caused by Inappropriate Composite Index Settings?
          3. How Do I Handle a Large Number of Temporary Tables Being Generated for Long Transactions and High Memory Usage?
          4. What Should I Do If Locks on Long Transactions Block the Execution of Subsequent Transactions?
          5. What Is the CPU Usage of a TaurusDB Instance with Empty Load?
        • Database Usage
          1. Why Are the Results Inconsistent After the MATCH AGAINST Statement Is Executed, Respectively, on Primary Nods and Read Replicas?
          2. How Do I Add Columns Using INSTANT?
          3. How Do I Use LOAD DATA to Import Local Data?
          4. How Do I Write Data to or Create Indexes for an Ultra-large Table?
          5. What Are the Risks of Deleting an Index from an Ultra-large Table?
        • Backups
          1. How Long Can a TaurusDB Instance Backup Be Retained?
          2. How Do I Clear TaurusDB Backup Space?
          3. How Can I Back Up a TaurusDB Database to an ECS?
          4. How Do I View My Backup Storage Usage?
          5. Why Has My Automated Backup Failed?
          6. How Is TaurusDB Backup Data Billed?
        • Database Parameter Modification
          1. How Can I Change the Time Zone?
          2. How Do I Configure a Password Expiration Policy for TaurusDB Instances?
          3. How Do I Ensure that the Database Character Set of a TaurusDB Instance Is Correct?
          4. How Do I Use the utf8mb4 Character Set to Store Emojis in a TaurusDB Instance?
          5. How Do I Set Case Sensitivity for TaurusDB Table Names?
          6. Can I Use SQL Commands to Modify Global Parameters?
        • Network Security
          1. What Security Protection Policies Does TaurusDB Have?
          2. How Can I Prevent Untrusted Source IP Addresses from Accessing TaurusDB?
          3. How Do I Configure a Security Group to Enable Access to TaurusDB Instances?
          4. How Can I Import the Root Certificate to a Windows or Linux Server?
          5. How Do I Manage and Ensure TaurusDB Security?
        • Log Management
          1. Can I Enable general_log for TaurusDB?
          2. How Do I View All SQL Logs Executed by TaurusDB?
          3. How Do I View Slow Query Logs of TaurusDB?
          4. How Do I Enable Binlog and View Binlog Files of My TaurusDB Instance?
          5. How Do I Change the Binlog Retention Period?
          6. Why Are Slow SQL Statements Displayed in Slow Query Log Monitoring, but No Information About Them Is Displayed on the Slow Query Logs Tab Page in the Logs Module?
        • Version Upgrade
          1. How Can I Check a TaurusDB Instance Version?
      • 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 Reported When Data Containing Emojis Is Inserted or 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
          • 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
          • High Table Fragmentation Rate
        • Basic Issues
          • How Do I View 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