- Function Overview
- Product Bulletin
- Service Overview
- Billing
- Getting Started
- Kernels
- User Guide
- Best Practices
- Performance White Paper
-
API Reference
- Before You Start
- API Overview
- Calling APIs
-
API v3.1 (Recommended)
- Applying a Parameter Template
- Modifying Parameters of a Specified Instance
- Restoring Data to an Existing DB Instance
- Restoring Tables to a Specified Point in Time (RDS for MySQL)
- Querying Database Error Logs (MySQL)
- Querying Database Slow Logs (MySQL)
- Deleting a Database (RDS for SQL Server)
- Shrinking Database Logs
-
API v3 (Recommended)
- Querying Version Information About APIs
- Querying Version Information About a DB Engine
- Querying Database Specifications
- Querying the Storage Type of a Database
- Querying Storage Usage of a DB Instance
-
DB Instance Management
- Creating a DB Instance
- Creating a DB Instance (API v5)
- Changing the Billing Mode from Pay-per-Use to Yearly/Monthly
- Stopping an Instance
- Starting an Instance
- Changing a DB Instance Name
- Changing the Description of a DB Instance
- Applying for a Private Domain Name
- Modifying a Private Domain Name
- Querying the Domain Name of a DB Instance
- Querying the IPv6 Domain Name of a DB Instance
- Obtaining the Replication Status of a DB Instance
- Querying Available Instance Classes for a DB Instance
- Changing DB Instance Specifications
- Scaling Up Storage Space of a DB Instance
- Configuring an Autoscaling Policy
- Querying an Autoscaling Policy
- Changing a Single DB Instance to Primary/Standby DB Instances
- Rebooting a DB Instance
- Deleting a DB Instance
- Querying DB Instances
- Binding and Unbinding an EIP
- Changing the Failover Priority
- Manually Switching Primary/Standby DB Instances
- Changing the Data Replication Mode of Primary/Standby DB Instances
- Changing Read/Write Permissions
- Migrating a Standby DB Instance
- Configuring the Maintenance Window
- Upgrading the Minor Version of a DB Instance
- Configuring an Automatic Minor Version Upgrade Policy for a DB Instance (RDS for PostgreSQL)
- Querying the Automatic Minor Version Upgrade Policy of a DB Instance (RDS for PostgreSQL)
- Configuring a Monitoring by Seconds Policy
- Querying a Monitoring by Seconds Policy
- Enabling TDE for a DB Instance (RDS for SQL Server)
- Querying TDE Status of a DB Instance (RDS for SQL Server)
- Unlocking a DB Instance from the Read-Only State
- DR Instances
- Database Security
-
Backup and Restoration
- Setting an Automated Backup Policy
- Setting a Cross-Region Backup Policy
- Obtaining an Automated Backup Policy
- Querying Information About a Cross-Region Backup Policy
- Creating a Manual Backup
- Obtaining Backups
- Querying Cross-Region Backups
- Querying DB Instances for Which Cross-Region Backups Are Created
- Obtaining the Link for Downloading a Backup
- Deleting a Manual Backup
- Querying the Restoration Time Range
- Querying the Restoration Time Range of a Cross-Region Backup
- Restoring Data to a New DB Instance
- Stopping a Backup (RDS for PostgreSQL)
- Checking Whether Fast Restoration Can Be Used for Restoring Databases or Tables (RDS for MySQL)
- Querying Tables That Can Be Restored to a Specified Point in Time (RDS for PostgreSQL)
- Querying Databases That Can Be Restored to a Specified Point in Time
- Restoring Tables to a Specified Point in Time (RDS for PostgreSQL)
- Restoring Databases to a Specified Point in Time
- Querying Databases Contained in a Database-Level Backup (RDS for PostgreSQL)
- Configuring an Automatic Transfer Policy (RDS for MySQL)
- Transferring Backups to an OBS Bucket (RDS for MySQL)
- Querying Automatic Transfer Policies (RDS for MySQL)
- Querying Transfer Tasks (RDS for MySQL)
-
Upgrading a Major Version
- Querying the Target Version to Which a DB Instance Can Be Upgraded (RDS for PostgreSQL)
- Performing a Major Version Upgrade Pre-Check for a DB Instance (RDS for PostgreSQL)
- Querying the Major Version Check Status or Upgrade Status of a DB Instance (RDS for PostgreSQL)
- Querying the Major Version Upgrade Check History of a DB Instance (RDS for PostgreSQL)
- Upgrading a Major Version of a DB Instance (RDS for PostgreSQL)
- Querying the Major Version Upgrade History of a DB Instance (RDS for PostgreSQL)
-
Log Information Queries
- Showing Original Logs
- Querying Slow Query Log Files (SQL Server)
- Querying Extended Logs (RDS for SQL Server)
- Obtaining Links for Downloading Extended Logs (RDS for SQL Server)
- Obtaining Slow Query Log Statistics (RDS for MySQL)
- Obtaining Links for Downloading Slow Query Logs
- Obtaining Links for Downloading Error Logs (RDS for PostgreSQL)
- Setting SQL Audit
- Querying the Policy for SQL Audit Logs
- Obtaining Audit Logs
- Obtaining the Links for Downloading Audit Logs
- Setting the Local Retention Period of Binlogs
- Obtaining the Local Retention Period of Binlogs
- Instance Diagnosis
-
SQL Statement Concurrency Control (RDS for PostgreSQL)
- Adding a SQL Statement Concurrency Control Rule for a Database
- Deleting a SQL Statement Concurrency Control Rule
- Modifying a SQL Statement Concurrency Control Rule
- Querying SQL Statement Concurrency Control Rules
- Enabling or Disabling a SQL Statement Concurrency Control Rule or Disabling All SQL Statement Concurrency Control Rules
- Database Proxy (RDS for MySQL)
-
Database and Account Management (MySQL)
- Precautions
- Creating a Database
- Querying Details About a Database (Discarded)
- Querying Databases
- Querying Authorized Databases of a Specified User
- Modifying the Database Remarks of a Specified DB Instance
- Deleting a Database
- Creating a Database Account
- Querying Database Users of a DB Instance (Discarded)
- Querying Database Users
- Querying Authorized Users of a Specified Database
- Modifying Remarks of a Database Account
- Deleting a Database Account
- Configuring a Password for a Database Account
- Authorizing a Database Account
- Revoking Permissions of a Database Account
- Resetting the Password for User root
-
Database and Account Management (PostgreSQL)
- Creating a Database
- Creating a Database Account
- Creating a Database Schema
- Granting Read or Write Permissions to a Database Account
- Resetting a Password for a Database Account
- Querying Databases
- Querying Database Users
- Querying Database Schemas
- Configuring Account Permissions
- Changing the Database Owner
- Granting a Role to a User
- Revoking a Role from a User
- Querying Roles
- Querying pg_hba.conf of a DB Instance
- Modifying or Adding One or More Records in pg_hba.conf
- Overwriting pg_hba.conf
- Deleting One or More Records from pg_hba.conf
- Querying the pg_hba.conf Change History of a DB Instance
-
Database and Account Management (Microsoft SQL Server)
- Querying the Available SQL Server Character Set
- Creating a Database
- Querying Databases
- Creating a Database Account
- Configuring a Password for a Database Account
- Querying Database Users
- Querying Authorized Users of a Specified Database
- Deleting a Database Account
- Authorizing a Database Account
- Revoking Permissions of a Database Account
- Adding Host Addresses for MSDTC
- Querying MSDTC Hosts
-
Parameter Management
- Obtaining a Parameter Template List
- Creating a Parameter Template
- Modifying a Parameter Template
- Replicating a Parameter Template
- Querying Change History of Instance Parameters
- Obtaining the Parameter Template of a Specified DB Instance
- Obtaining Parameters in a Specified Parameter Template
- Deleting a Parameter Template
- Extension Management (RDS for PostgreSQL)
- Configuring Replication Delay for a Read Replica (RDS for PostgreSQL)
- Recycling a DB Instance
- Tag Management
- Quota Management
- Obtaining Task Information
-
Historical APIs
-
API v3
- Querying API Versions
- Upgrading a Minor Version
- Applying a Parameter Template
- Modifying Parameters of a Specified DB Instance
- Restoring Data to an Existing DB Instance
- Restoring Tables to a Specified Point in Time (RDS for MySQL)
- Querying Database Error Logs
- Querying Slow Query Logs
- Deleting a Database (RDS for SQL Server)
- Shrinking Database Logs (Not Recommended)
- Database Proxy (PostgreSQL)
-
API v3
- Permissions and Supported Actions
- Appendix
- SDK Reference
- FAQs
- Troubleshooting
- Videos
- Glossary
-
More Documents
-
User Guide (ME-Abu Dhabi Region)
- Introduction
- Getting Started with RDS for MySQL
- Getting Started with RDS for PostgreSQL
- Getting Started with RDS for SQL Server
-
Working with RDS for MySQL
- Data Migration
- Instance Management
- Instance Modifications
- Read Replicas
-
Backups and Restorations
- Working with Backups
- Configuring an Intra-Region Backup Policy
- Creating a Manual Backup
- Downloading a Backup File
- Downloading a Binlog Backup File
- Setting a Local Retention Period for MySQL Binlogs
- Restoring from Backup Files to RDS for MySQL
- Restoring a DB Instance to a Point in Time
- Restoring a Table to a Specified Point in Time
- Replicating a Backup
- Deleting a Manual Backup
-
Parameter Template Management
- Suggestions on Tuning MySQL Parameters
- Creating a Parameter Template
- Modifying Parameters
- Exporting a Parameter Template
- 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
- Modifying a Parameter Template Description
- Deleting a Parameter Template
- Connection Management
- Database Management
- Account Management (Non-Administrator)
- Database Account Security
- Data Security
- Metrics
- Log Management
- Task Center
- Managing Tags
-
Working with RDS for PostgreSQL
- Data Migration
- PostgreSQL Enhanced Edition
- Instance Management
- Instance Modifications
- Read Replicas
- Backups and Restorations
-
Parameter Template Management
- Creating a Parameter Template
- Modifying Parameters
- Exporting a Parameter Template
- 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
- Modifying a Parameter Template Description
- Deleting a Parameter Template
- Connection Management
- Database Account Security
- Data Security
- Metrics
- Log Management
- Task Center
- Plugin Management
- Managing Tags
-
Working with RDS for SQL Server
- Instance Management
- Instance Modifications
- Read Replicas
- Backups and Restorations
-
Parameter Template Management
- Creating a Parameter Template
- Modifying Parameters
- Exporting a Parameter Template
- 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
- Modifying a Parameter Template Description
- Deleting a Parameter Template
- Connection Management
- Data Security
- Metrics
- Log Management
- Task Center
- Usage of Stored Procedures
- Managing Tags
-
FAQs
-
Product Consulting
- What Precautions Should Be Taken When Using RDS?
- What Is the Availability of RDS DB Instances?
- Can I Use a Template to Create DB Instances?
- What Are the Differences Between RDS and Other Database Solutions?
- Will My RDS DB Instances Be Affected by Other Users' DB Instances?
- Does RDS Support Cross-AZ High Availability?
- Can RDS Primary/Standby DB Instances Be Changed to Single DB Instances?
- What Should I Do If Garbled Characters Are Displayed After SQL Query Results Are Exported to an Excel File?
- What Can I Do About Websites Responding Slower After Using RDS?
- How Does a Cloud Database Perform a Primary/Standby Switchover?
- Can Multiple ECSs Connect to the Same RDS DB Instance?
- Why an Error is Reported When I Attempt to Delete a Database from RDS SQL Server Primary/Standby DB Instances?
- Can Primary and Standby RDS DB Instances Be Deployed in the Same AZ?
-
Resource and Disk Management
- Which Types of Logs and Files Occupy RDS Storage Space?
- Which Items Occupy the Storage Space of My RDS DB Instances?
- What Overhead Does the Storage Space Have After I Applied for an RDS DB Instance?
- How Much Storage Space Is Required for DDL Operations?
- How Many DB Instances Can Run on RDS?
- How Many Databases Can Run on an RDS DB Instance?
-
Database Connection
- Can an External Server Access the RDS Database?
- How Do I Troubleshoot If the Number of RDS Database Connections Reaches the Upper Limit?
- What Is the Maximum Number of Connections to an RDS DB Instance?
- How Can I Create and Connect to an ECS?
- What Should I Do If an ECS Cannot Connect to an RDS DB Instance?
- What Should I Do If a Database Client Problem Causes a Connection Failure?
- What Should I Do If an RDS Database Problem Causes a Connection Failure?
- How Do My Applications Access an RDS DB Instance in a VPC?
- Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
- How Can I Connect to a PostgreSQL Database Through JDBC?
- What Should I Do If an RDS for SQL Server DB Instance Failed to Be Connected?
- Can I Access an RDS DB Instance Over an Intranet Across Regions?
- Is an SSL Connection to a DB Instance Interrupted After a Primary/Standby Switchover or Failover Occurs?
- Does MySQL Support SSL Connections?
- Why Does the New Password Not Take Effect After I Reset the Administrator Password?
- Database Migration
- Database Permission
- Database Storage
- Client Installation
-
Backup and Restoration
- How Long Does RDS Store Backup Data?
- Can My Database Be Used in the Backup Window?
- How Can I Back Up RDS Databases to an ECS?
- Why Has My Automated Backup Failed?
- What Happens to Database Backups After an RDS DB Instance Is Deleted?
- Will My Backups Be Deleted If I Delete My Cloud Account?
- Why Is a Table or Data Missing from My Database?
- Database Monitoring
- Capacity Expansion and Specification Change
- Database Parameter Modification
- Log Management
-
Network Security
- What Security Protection Policies Does RDS Have?
- How Can I Ensure the Security of RDS DB Instances in a VPC?
- How Can Data Security Be Ensured During Transmission When I Access RDS Through an EIP?
- How Can I Prevent Untrusted Source IP Addresses from Accessing RDS?
- How Can I Import the Root Certificate to the Windows or Linux OS?
- How Can I Identify Data Corruption?
-
Product Consulting
-
API Reference (ME-Abu Dhabi Region)
- Before You Start
- API Overview
- Calling APIs
- Obtaining an API Version
-
API v3 (Recommended)
- Querying Version Information About a DB Engine
- Querying Database Specifications
- Querying the Storage Type of a Database
-
DB Instance Management
- Creating a DB Instance
- Changing DB Instance Specifications
- Scaling Up Storage Space of a DB Instance
- Changing a Single DB Instance to Primary/Standby DB Instances
- Rebooting a DB Instance
- Querying the Available SQL Server Character Set
- Deleting a DB Instance
- Querying Details About DB Instances
- Binding and Unbinding an EIP
- Resetting a Database Password
- Changing the Failover Priority
- Manually Switching Primary/Standby DB Instances
- Changing the Data Synchronize Model of Primary/Standby DB Instances
- Migrating a Standby DB Instance
- Configuring the Maintenance Window
- Database Security
-
Parameter Configuration
- Obtaining a Parameter Template List
- Creating a Parameter Template
- Modifying a Parameter Template
- Applying a Parameter Template
- Modifying Parameters of a Specified DB Instance
- Obtaining the Parameter Template of a Specified DB Instance
- Obtaining Parameters in a Specified Parameter Template
- Deleting a Parameter Template
-
Backup and Restoration
- Setting an Automated Backup Policy
- Obtaining an Automated Backup Policy
- Creating a Manual Backup
- Obtaining Details About Backups
- Obtaining the Link for Downloading a Backup File
- Deleting a Manual Backup
- Querying the Restoration Time Range
- Restoring Data to a New DB Instance
- Restoring Data to an Existing DB Instance
- Restoring Tables to a Specified Point in Time (MySQL)
- Log Information Queries
-
Database and Account Management (MySQL)
- Precautions
- Creating a Database
- Querying Details About Databases
- Querying Authorized Databases of a Specified User
- Deleting a Database
- Creating a Database Account
- Querying Details About Database Users
- Querying Authorized Users of a Specified Database
- Deleting a Database Account
- Configuring a Password for a Database Account
- Authorizing a Database Account
- Revoking Permissions of a Database Account
- Database and Account Management (Microsoft SQL Server)
- Appendix
-
User Guide (Paris Region)
- Introduction
- Getting Started with RDS for MySQL
- Getting Started with RDS for PostgreSQL
-
Working with RDS for MySQL
-
Instance Management
- Changing a DB Instance Name
- Changing the Failover Priority
- Changing a DB Instance Class
- Scaling Up Storage Space
- Rebooting a DB Instance
- Changing a DB Instance Type from Single to Primary/Standby
- Manually Switching Between Primary and Standby DB Instances
- Selecting Displayed Items
- Exporting DB Instance Information
- Creating a Same DB Instance
- Deleting a DB Instance or Read Replica
- Read Replicas
- Backups and Restorations
-
Parameter Template Management
- Suggestions on Tuning MySQL Parameters
- Creating a Parameter Template
- Modifying Parameters
- Exporting a Parameter Template
- 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
- Modifying a Parameter Template Description
- Deleting a Parameter Template
- Connection Management
- Data Migration
- Data Security
- Metrics and Alarms
- Log Management
- Task Center
-
Instance Management
-
Working with RDS for PostgreSQL
-
Instance Management
- Changing a DB Instance Name
- Changing the Failover Priority
- Changing a DB Instance Class
- Scaling Up Storage Space
- Rebooting a DB Instance
- Changing a DB Instance Type from Single to Primary/Standby
- Manually Switching Between Primary and Standby DB Instances
- Selecting Displayed Items
- Exporting DB Instance Information
- Creating a Same DB Instance
- Deleting a DB Instance or Read Replica
- Read Replicas
- Backups and Restorations
-
Parameter Template Management
- Creating a Parameter Template
- Modifying Parameters
- Exporting a Parameter Template
- 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
- Modifying a Parameter Template Description
- Deleting a Parameter Template
- Connection Management
- Data Migration
- Data Security
- Metrics and Alarms
- Log Management
- Task Center
- Plugin Management
-
Instance Management
-
FAQs
-
Product Consulting
- What Precautions Should Be Taken When Using RDS?
- What Is the Availability of RDS DB Instances?
- Can I Use a Template to Create DB Instances?
- What Are the Differences Between RDS and Other Database Solutions?
- Will My RDS DB Instances Be Affected by Other Users' DB Instances?
- Does RDS Support Cross-AZ High Availability?
- Can RDS Primary/Standby DB Instances Be Changed to Single DB Instances?
- What Should I Do If Garbled Characters Are Displayed After SQL Query Results Are Exported to an Excel File?
- What Can I Do About Websites Responding Slower After Using RDS?
- How Does a Cloud Database Perform a Primary/Standby Switchover?
- Can Multiple ECSs Connect to the Same RDS DB Instance?
- Can Primary and Standby RDS DB Instances Be Deployed in the Same AZ?
-
Resource and Disk Management
- Which Types of Logs and Files Occupy RDS Storage Space?
- Which Items Occupy the Storage Space of My RDS DB Instances?
- What Overhead Does the Storage Space Have After I Applied for an RDS DB Instance?
- How Much Storage Space Is Required for DDL Operations?
- How Many DB Instances Can Run on RDS?
- How Many Databases Can Run on an RDS DB Instance?
-
Database Connection
- Can an External Server Access the RDS Database?
- How Do I Troubleshoot If the Number of RDS Database Connections Reaches the Upper Limit?
- What Is the Maximum Number of Connections to an RDS DB Instance?
- How Can I Create and Connect to an ECS?
- What Should I Do If an ECS Cannot Connect to an RDS DB Instance?
- What Should I Do If a Database Client Problem Causes a Connection Failure?
- What Should I Do If an RDS Database Problem Causes a Connection Failure?
- How Do My Applications Access an RDS DB Instance in a VPC?
- Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
- How Can I Connect to a PostgreSQL Database Through JDBC?
- Can I Access an RDS DB Instance Over an Intranet Across Regions?
- Is an SSL Connection to a DB Instance Interrupted After a Primary/Standby Switchover or Failover Occurs?
- Does MySQL Support SSL Connections?
- Why Does the New Password Not Take Effect After I Reset the Administrator Password?
- Database Migration
- Database Permission
- Database Storage
- Client Installation
-
Backup and Restoration
- How Long Does RDS Store Backup Data?
- Can My Database Be Used in the Backup Window?
- How Can I Back Up RDS Databases to an ECS?
- Why Has My Automated Backup Failed?
- What Happens to Database Backups After an RDS DB Instance Is Deleted?
- Will My Backups Be Deleted If I Delete My Cloud Account?
- Why Is a Table or Data Missing from My Database?
- Database Monitoring
- Capacity Expansion and Specification Change
- Database Parameter Modification
- Log Management
-
Network Security
- What Security Protection Policies Does RDS Have?
- How Can I Ensure the Security of RDS DB Instances in a VPC?
- How Can Data Security Be Ensured During Transmission When I Access RDS Through an EIP?
- How Can I Prevent Untrusted Source IP Addresses from Accessing RDS?
- How Can I Import the Root Certificate to the Windows or Linux OS?
- How Can I Identify the Validity Period of an SSL Root Certificate?
- How Can I Identify Data Corruption?
-
Product Consulting
-
API Reference (Paris Region)
- Before You Start
- API Overview
- Calling APIs
- Obtaining an API Version
-
API v3 (Recommended)
- Querying Version Information About a DB Engine
- Querying Database Specifications
- DB Instance Management
-
Parameter Configuration
- Obtaining a Parameter Template List
- Creating a Parameter Template
- Modifying a Parameter Template
- Applying a Parameter Template
- Modifying Parameters of a Specified DB Instance
- Obtaining the Parameter Template of a Specified DB Instance
- Obtaining Parameters in a Specified Parameter Template
- Deleting a Parameter Template
-
Backup and Restoration
- Setting an Automated Backup Policy
- Obtaining an Automated Backup Policy
- Creating a Manual Backup
- Obtaining Details About Backups
- Obtaining the Link for Downloading a Backup File
- Deleting a Manual Backup
- Querying the Restoration Time Range
- Restoring Data to a New DB Instance
- Restoring Data to an Existing or Original DB Instance
- Log Information Queries
- Tag Management
- Obtaining Task Information
- Appendix
-
User Guide (Kuala Lumpur Region)
- Introduction
- Getting Started with RDS for MySQL
- Getting Started with RDS for PostgreSQL
- Getting Started with RDS for SQL Server
-
Working with RDS for MySQL
- Data Migration
- Parameter Tuning
- Instance Lifecycle
-
Instance Modifications
- Upgrading a Major Version
- Changing a DB Instance Name
- Changing the Failover Priority
- Changing a DB Instance Class
- Scaling up Storage Space
- Changing the Maintenance Window
- Changing a DB Instance Type from Single to Primary/Standby
- Promoting a Read Replica Into a Single DB Instance
- Manually Switching Between Primary and Standby DB Instances
- Migrating a Standby DB Instance
- Read Replicas
-
Backups and Restorations
- Working with Backups
- Configuring an Automated Backup Policy
- Setting a Cross-Region Backup Policy
- Creating a Manual Backup
- Downloading a Backup File
- Downloading a Binlog Backup File
- Setting a Local Retention Period for MySQL Binlogs
- Restoring from Backup Files to DB Instances
- Restoring a DB Instance to a Point in Time
- Replicating a Backup
-
Parameter Template Management
- Creating a Parameter Template
- Modifying Parameters
- Exporting a Parameter Template
- 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
- Modifying a Parameter Template Description
- Deleting a Parameter Template
- Connection Management
- Database Management
- Account Management (Non-Administrator)
- Database Account Security
- Data Security
- Metrics and Alarms
- Interconnection with CTS
- Log Management
- Task Center
-
Working with RDS for PostgreSQL
- Data Migration
- Parameter Tuning
- PostgreSQL Enhanced Edition
- PostgreSQL Kernel Functions
- Instance Lifecycle
- Instance Modifications
- Read Replicas
-
Backups and Restorations
- Working with Backups
- Configuring an Automated Backup Policy
- Set a Cross-Region Backup Policy
- Creating a Manual Backup
- Downloading a Full Backup File
- Downloading an Incremental Backup File
- Restoring from Backup Files to RDS for PostgreSQL
- Restoring a DB Instance to a Point in Time
- Replicating a Backup
-
Parameter Template Management
- Creating a Parameter Template
- Modifying Instance Parameters
- Exporting a Parameter Template
- 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
- Modifying a Parameter Template Description
- Deleting a Parameter Template
- Connection Management
- Plugin Management
- Database Account Security
- Data Security
- and AlarmsMetrics and Alarms
- Interconnection with CTS
- Task Center
-
Working with RDS for SQL Server
- Instance Lifecycle
- Instance Modifications
- Read Replicas
- Backups and Restorations
-
Parameter Template Management
- Creating a Parameter Template
- Modifying Parameters
- Exporting a Parameter Template
- 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
- Modifying a Parameter Template Description
- Deleting a Parameter Template
- Connection Management
- Data Security
- and AlarmsMetrics and Alarms
- Interconnection with CTS
- Task Center
- Usage of Stored Procedures
-
FAQs
-
Product Consulting
- What Should I Pay Attention to When Using RDS?
- What Is the Availability of RDS DB Instances?
- Can I Use a Template to Create DB Instances?
- What Are the Differences Between RDS and Other Database Solutions?
- Will My RDS DB Instances Be Affected by Other User Instances?
- Does RDS Support Cross-AZ High Availability?
- Can RDS Primary/Standby DB Instances Be Changed to Single DB Instances?
- What Should I Do If Garbled Characters Are Displayed After SQL Query Results Are Exported to an Excel File?
- How Do I Create an AD Domain?
- What Can I Do About Slow Respond of Websites When They Use RDS?
- How Does a Cloud Database Perform a Primary/Standby Switchover?
- Can Multiple ECSs Connect to the Same RDS DB Instance?
- Why Is an Error Reported When I Attempt to Delete a Database from RDS SQL Server Primary/Standby DB Instances?
-
Resource and Disk Management
- Which Types of Logs and Files Occupy RDS Storage Space?
- Which Items Occupy the Storage Space of My RDS DB Instances?
- What Overhead Does the Storage Space Have After I Applied for an RDS DB Instance?
- How Much Storage Space Is Required for DDL Operations?
- How Many DB Instances Can Run on RDS?
- How Many Databases Can Run on an RDS DB Instance?
-
Database Connection
- Can an External Server Access the RDS Database?
- What Do I Do If the Number of RDS Database Connections Reaches the Upper Limit?
- What Is the Maximum Number of Connections to an RDS DB Instance?
- How Can I Create and Connect to an ECS?
- What Should I Do If an ECS Cannot Connect to an RDS DB Instance Through a Private Network?
- What Should I Do If a Database Client Problem Causes a Connection Failure?
- What Should I Do If an RDS Database Problem Causes a Connection Failure?
- How Do My Applications Access an RDS DB Instance in a VPC?
- Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
- How Can I Connect to a PostgreSQL Database Through JDBC?
- What Should I Do If an RDS for SQL Server DB Instance Failed to Be Connected?
- Can I Access an RDS DB Instance Over an Intranet Connection Across Regions?
- Is an SSL Connection to a DB Instance Interrupted After a Primary/Standby Switchover or Failover?
- Does MySQL Support SSL Connections?
- Why Did the New Password Not Take Effect After I Reset the Administrator Password?
- Database Migration
- Database Permission
- Database Storage
- Client Installation
-
Backup and Restoration
- How Long Does RDS Store Backup Data For?
- Can My Database Be Used in the Backup Window?
- How Can I Back Up an RDS Database to an ECS?
- Why Has My Automated Backup Failed?
- What Happens to Database Backups After an RDS DB Instance Is Deleted?
- Will My Backups Be Deleted If I Delete My Cloud Account?
- Why Is a Table or Data Missing from My Database?
- Database Monitoring
- Capacity Expansion and Specification Change
- Database Parameter Modification
- Log Management
-
Network Security
- What Security Protection Policies Does RDS Have?
- How Can I Ensure the Security of RDS DB Instances in a VPC?
- How Can Data Security Be Ensured During Transmission When I Access RDS Through an EIP?
- How Can I Prevent Untrusted Source IP Addresses from Accessing RDS?
- How Can I Import the Root Certificate to a Windows or Linux OS?
- How Can I Identify the Validity Period of an SSL Root Certificate?
- How Can I Identify Data Corruption?
-
Product Consulting
-
API Reference (Kuala Lumpur Region)
- Before You Start
- API Overview
- Calling APIs
- Obtaining an API Version
-
API v3 (Recommended)
- Querying Version Information About a DB Engine
- Querying Database Specifications
- Querying the Storage Type of a Database
-
DB Instance Management
- Creating a DB Instance
- Changing DB Instance Specifications
- Scaling Up Storage Space of a DB Instance
- Changing a Single DB Instance to Primary/Standby DB Instances
- Rebooting a DB Instance
- Querying the Available SQL Server Character Set
- Deleting a DB Instance
- Querying Details About DB Instances
- Binding and Unbinding an EIP
- Resetting a Database Password
- Changing the Failover Priority
- Manually Switching Primary/Standby DB Instances
- Changing the Data Synchronize Model of Primary/Standby DB Instances
- Migrating a Standby DB Instance
- Database Security
-
Parameter Configuration
- Obtaining a Parameter Template List
- Creating a Parameter Template
- Modifying a Parameter Template
- Applying a Parameter Template
- Modifying Parameters of a Specified DB Instance
- Obtaining the Parameter Template of a Specified DB Instance
- Obtaining Parameters in a Specified Parameter Template
- Deleting a Parameter Template
-
Backup and Restoration
- Setting an Automated Backup Policy
- Obtaining an Automated Backup Policy
- Creating a Manual Backup
- Obtaining Details About Backups
- Obtaining the Link for Downloading a Backup File
- Deleting a Manual Backup
- Querying the Restoration Time Range
- Restoring Data to a New DB Instance
- Restoring Data to an Existing DB Instance
- Restoring Tables to a Specified Point in Time (MySQL)
- Log Information Queries
-
Database and Account Management (MySQL)
- Precautions
- Creating a Database
- Querying Details About Databases
- Querying Authorized Databases of a Specified User
- Deleting a Database
- Creating a Database Account
- Querying Details About Database Users
- Querying Authorized Users of a Specified Database
- Deleting a Database Account
- Configuring a Password for a Database Account
- Authorizing a Database Account
- Revoking Permissions of a Database Account
- Database and Account Management (Microsoft SQL Server)
- Tag Management
- Obtaining Task Information
- Appendix
-
User Guide (Ankara Region)
- Introduction
- Getting Started with RDS for MySQL
- Getting Started with RDS for PostgreSQL
-
Working with RDS for MySQL
- Database Migration
- Parameter Tuning
- Permissions Management
- Instance Lifecycle
-
Instance Modifications
- Changing a DB Instance Name
- Changing the Failover Priority
- Changing a DB Instance Class
- Scaling up Storage Space
- Changing the Maintenance Window
- Changing a DB Instance Type from Single to Primary/Standby
- Promoting a Read Replica Into a Single DB Instance
- Manually Switching Between Primary and Standby DB Instances
- Migrating a Standby DB Instance
- Read Replicas
-
Backups and Restorations
- Working with Backups
- Configuring an Automated Backup Policy
- Setting a Cross-Region Backup Policy
- Creating a Manual Backup
- Downloading a Backup File
- Downloading a Binlog Backup File
- Restoring from Backup Files to DB Instances
- Restoring a DB Instance to a Point in Time
- Restoring a Table to a Point in Time
- Replicating a Backup
- Deleting a Manual Backup
-
Parameter Template Management
- Creating a Parameter Template
- Modifying Parameters
- Exporting a Parameter Template
- 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
- Modifying a Parameter Template Description
- Deleting a Parameter Template
- Connection Management
-
Database Proxy (Read/Write Splitting)
- Introducing Read/Write Splitting
- Best Practices for Database Proxy
- Enabling Read/Write Splitting
- Configuring Delay Threshold and Distributing Read Weight
- Changing the Read/Write Splitting Address
- Changing the Instance Class of a DB Proxy Instance
- Upgrading the Kernel Version of Database Proxy
- Enabling or Disabling Access Control
- Disabling Read/Write Splitting
- Rules for Distributing Weights
- Testing Read/Write Splitting Performance
- Data Security
- Metrics and Alarms
- Log Management
- Task Center
-
Working with RDS for PostgreSQL
- Database Migration
- Parameter Tuning
- Permissions Management
- Instance Lifecycle
- Instance Modifications
- Read Replicas
-
Backups and Restorations
- Working with Backups
- Configuring an Automated Backup Policy
- Set a Cross-Region Backup Policy
- Creating a Manual Backup
- Downloading a Full Backup File
- Downloading an Incremental Backup File
- Restoring from Backup Files to RDS for PostgreSQL
- Restoring a DB Instance to a Point in Time
- Replicating a Backup
- Deleting a Manual Backup
-
Parameter Template Management
- Creating a Parameter Template
- Modifying Instance Parameters
- Exporting a Parameter Template
- 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
- Modifying a Parameter Template Description
- Deleting a Parameter Template
- Connection Management
- Plugin Management
- Tablespace Management
- Data Security
- Metrics and Alarms
- Log Management
- Task Center
-
FAQs
-
Product Consulting
- What Should I Pay Attention to When Using RDS?
- What Is the Availability of RDS DB Instances?
- Does RDS Support Cross-AZ High Availability?
- What Can I Do About Slow Responses of Websites When They Use RDS?
- Can I Change the Replication Mode Between Primary DB Instances and Read Replicas?
- What Is the Time Delay for Primary/Standby Replication?
- What Are the Restrictions on MySQL DB Instances After GTID Is Enabled?
- How Many Databases Can Run on an RDS DB Instance?
- What Is the Maximum Size Allowed for a Single Table in MySQL Instances?
- Resource and Disk Management
-
Database Connection
- What Should I Do If I Can't Connect to My RDS DB Instance?
- Can an External Server Access the RDS Database?
- What Do I Do If the Number of RDS Database Connections Reaches the Upper Limit?
- What Is the Maximum Number of Connections to an RDS DB Instance?
- How Can I Create and Connect to an ECS?
- What Should I Do If an ECS Cannot Connect to an RDS DB Instance Through a Private Network?
- What Should I Do If a Database Client Problem Causes a Connection Failure?
- What Should I Do If an RDS Database Problem Causes a Connection Failure?
- Do Applications Need to Support Reconnecting to the RDS DB Instance Automatically?
- How Can I Connect to an RDS for PostgreSQL Database Through JDBC?
- Why Cannot I Ping My EIP After It Is Bound to a DB Instance?
- How Can I Obtain the IP Addreenabled SQL auditss of an Application?
- Can I Access an RDS DB Instance Over an Intranet Connection Across Regions?
- Why Did the New Password Not Take Effect After I Reset the Administrator Password?
- How Do I Set the Encoding Format of the MySQL 8.0 Character Set?
- What Should I Do If the ECS and RDS Are Deployed in Different VPCs and They Cannot Communicate with Each Other?
- How Do I View All IP Addresses Connected to a Database?
- Can I Access Standby RDS DB Instances?
- How Do I Check the Connections to an RDS for MySQL Instance?
- Database Migration
- Database Permission
- Database Storage
- Client Installation
- Database Usage
-
Backup and Restoration
- How Long Does RDS Store Backup Data For?
- How Do I Clear RDS Backup Space?
- Can My Database Be Used in the Backup Window?
- How Do I View My Backup Storage Usage?
- How Can I Back Up an RDS Database to an ECS?
- Will Backups Be Retained After My RDS Instance Is Deleted?
- Why Has My Automated Backup Failed?
- Why Is a Table or Data Missing from My Database?
- How Do I Restore a Local Database Backup to RDS?
- Does RDS for PostgreSQL Support Table PITR?
- Can I Dump Backup Files to OBS Buckets?
- Does RDS for MySQL Support Table-Level Backup to a Specified OBS Bucket?
- Can I Delete the RDS for MySQL Backup Policy?
- Database Monitoring
- Capacity Expansion and Specification Change
-
Database Parameter Modification
- What Inappropriate Parameter Settings Cause Unavailability of the RDS for PostgreSQL Database?
- How Can I Change the Time Zone?
- How Do I Configure a Password Expiration Policy for RDS for MySQL DB Instances?
- How Do I Change the RDS Transaction Isolation Level?
- Does RDS for PostgreSQL Support the test_decoding Plugin?
- How Do I Use the utf8mb4 Character Set to Store Emojis in an RDS for MySQL DB Instance?
- Can I Use SQL Commands to Modify Global Parameters?
- How Do I Set Case Sensitivity for RDS for MySQL Table Names?
- Can I Enable Query Caching for My RDS for MySQL Instance?
-
Network Security
- What Security Protection Policies Does RDS Have?
- How Can Data Security Be Ensured During Transmission When I Access RDS Through an EIP?
- How Can I Prevent Untrusted Source IP Addresses from Accessing RDS?
- How Do I Configure a Security Group to Enable Access to RDS DB Instances?
- How Can I Import the Root Certificate to a Windows or Linux OS?
- How Can I Identify the Validity Period of an SSL Root Certificate?
- What Are the Possible Causes for Data Corruption?
- Version Upgrade
-
Product Consulting
- Change History
-
API Reference (Ankara Region)
- Before You Start
- API Overview
- Calling APIs
-
API v3 (Recommended)
- Querying Version Information About APIs
- Querying Version Information About a DB Engine
- Querying Database Specifications
- Querying the Storage Type of a Database
-
DB Instance Management
- Creating a DB Instance
- Stopping an Instance
- Starting an Instance
- Changing DB Instance Specifications
- Scaling Up Storage Space of a DB Instance
- Changing a Single DB Instance to Primary/Standby DB Instances
- Rebooting a DB Instance
- Deleting a DB Instance
- Querying Details About DB Instances
- Binding and Unbinding an EIP
- Changing the Failover Priority
- Manually Switching Primary/Standby DB Instances
- Changing the Data Replication Mode of Primary/Standby DB Instances
- Migrating a Standby DB Instance
- Configuring the Maintenance Window
- Database Security
-
Parameter Configuration
- Obtaining a Parameter Template List
- Creating a Parameter Template
- Modifying a Parameter Template
- Applying a Parameter Template
- Modifying Parameters of a Specified Instance
- Obtaining the Parameter Template of a Specified DB Instance
- Obtaining Parameters in a Specified Parameter Template
- Deleting a Parameter Template
-
Backup and Restoration
- Setting an Automated Backup Policy
- Setting a Cross-Region Backup Policy
- Obtaining an Automated Backup Policy
- Querying Information About a Cross-Region Backup Policy
- Creating a Manual Backup
- Obtaining Details About Backups
- Querying Details About Cross-Region Backups
- Querying Details About DB Instances for Which Cross-Region Backups Are Created
- Obtaining the Link for Downloading a Backup File
- Deleting a Manual Backup
- Querying the Restoration Time Range
- Querying the Restoration Time Range of a Cross-Region Backup
- Restoring Data to a New DB Instance
- Restoring Data to an Existing or Original DB Instance
- Restoring Tables to a Specified Point in Time (MySQL)
- Log Information Queries
-
Database and Account Management (MySQL)
- Precautions
- Creating a Database
- Querying Details About a Database
- Querying Details About Databases
- Querying Authorized Databases of a Specified User
- Deleting a Database
- Creating a Database Account
- Querying Details About a Database User
- Querying Details About Database Users
- Querying Authorized Users of a Specified Database
- Deleting a Database Account
- Configuring a Password for a Database Account
- Authorizing a Database Account
- Revoking Permissions of a Database Account
- Resetting the Password for User Root
- Obtaining Task Information
- Appendix
- Change History
-
User Guide (ME-Abu Dhabi Region)
- General Reference
Copied.
Viewing and Downloading Slow Query Logs
Scenarios
Slow query logs record statements that exceed long_query_time (1 second by default). You can view log details to identify statements that are executing slowly and optimize the statements. You can also download slow query logs for service analysis.
Parameter Description
Parameter |
Description |
---|---|
long_query_time |
Specifies the time greater than or equal to which slow query logs are recorded. The precision is microsecond. The default value is 1s. When the execution time of an SQL statement exceeds the value of this parameter, the SQL statement is recorded in slow query logs. You can modify the slow log threshold as required.
|
Viewing Slow Query Logs
- Log in to the management console.
- Click
in the upper left corner and select a region and a project.
- Click Service List. Under Database, click Relational Database Service. The RDS console is displayed.
- On the Instance Management page, click the target DB instance.
- In the navigation pane on the left, choose Logs. On the Slow Query Logs page, click
to enable the slow query log function.
- The generated slow query logs are displayed.
NOTE:
Enabling slow query log slightly affects DB instance performance.
- Connect to the DB instance through the Microsoft SQL Server client.
- After the DB instance is connected, run the following command to view slow query log details:
select * from ::fn_trace_gettable('D:\SQLTrace\audit\XXX', default)
Example:
select * from ::fn_trace_gettable('D:\SQLTrace\audit\SQLTrace.trc', default)
The result is shown in Figure 1.
Downloading a Log
- Log in to the management console.
- Click
in the upper left corner and select a region and a project.
- Click Service List. Under Database, click Relational Database Service. The RDS console is displayed.
- On the Instance Management page, click the target DB instance.
- In the navigation pane on the left, choose Logs. On the Slow Query Logs page, click
to enable the slow query log function.
NOTE:
Enabling slow query log slightly affects DB instance performance.
- Locate a log to be downloaded and click Download in the Operation column.
- The system automatically loads the downloading preparation tasks. The loading duration is determined by the log file size and network environment.
- During the downloading preparation, the log status is Preparing.
- After the downloading preparation is complete, the log status is Preparation completed.
- If the downloading preparation fails, the log status is Abnormal.
- In the displayed dialog box, click OK to download the log whose status is Preparation completed. If you click Cancel, the system does not download the log.
The download link is valid for 5 minutes. After the download link expires, a message is displayed indicating that the download link has expired. You can close the window and repeat the procedure 6 to try to download a log again.
NOTE:
After downloading slow query logs to a local PC, you can use SSMS to connect to the local database and run the following SQL statement to view the slow query log details:
select * from ::fn_trace_gettable('XXX', default)
In the preceding command, XXX indicates the local path for storing slow query logs.
- The system automatically loads the downloading preparation tasks. The loading duration is determined by the log file size and network environment.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot