Data Admin Service
Data Admin Service
All results for "
" in this service
All results for "
" in this service
What's New
Function Overview
Service Overview
What Is Data Admin Service?
Basic Concepts
Advantages
Permissions Management
Constraints
DAS and Other Services
Billing
Billing Overview
Billing Modes
Intelligent O&M Billing
Paid Instances
Billing Examples
Bills
Arrears
Billing Termination
Getting Started
Step 1: Logging In to a DB Instance
Step 2: Developing or Maintaining Databases
User Guide
Permissions Management
Creating a User and Granting Permissions
DAS Custom Policies
Differences Between IAM Permissions and Database Permissions
Logging in to a DB Instance
Logging in to a Huawei Cloud DB Instance
Logging In to a Database Built On Huawei Cloud ECSs
Step 1: Adding DB Instance Login Information
Step 2: Logging In to an ECS-Hosted DB Instance
Logging in to a DB Instance Shared by Others
Sharing a DB Instance with Others
Logging in to a DB Instance Shared by Others
Managing Login Information of DB Instances Shared by Others
MySQL
Account Management
Creating a Database User
Editing a Database User
Deleting a Database User
Database Management
Creating a Database
Dropping a Database
Viewing Data Dictionary of a Database
SQL Operations
SQL Window
Executing SQL Statements
SQL Execution Plan
SQL Favorites
SQL History
Table Management
Creating a Table
Opening a Table
Viewing Details of a Table
Altering a Table
Renaming a Table
Dropping a Table
Clearing a Table
Maintaining a Table
View Management
Creating a View
Opening a View
Altering a View
Dropping a View
Viewing Details of a View
Stored Procedure Management
Creating a Stored Procedure
Altering or Executing a Stored Procedure
Dropping a Stored Procedure
Viewing Details of a Stored Procedure
Event Management
Creating an Event
Altering an Event
Dropping an Event
Viewing Details of an Event
Trigger Management
Creating a Trigger
Altering a Trigger
Dropping a Trigger
Viewing Details of a Trigger
Function Management
Creating a Function
Altering or Executing a Function
Dropping a Function
Viewing Details of a Function
Data Import and Export
Importing Data
Exporting Data
Data Generator (Not Promoted)
Tracking and Rolling Back Data (Not Promoted)
Task Management
Scheduling Tasks (Not Promoted)
Scheduled Backup (Not Promoted)
Table Structure Comparison and Synchronization (Not Promoted)
Intelligent O&M (New Version)
Dashboard
Setting an Instance as Paid
Viewing the Overall Status of an Instance
Real-Time Performance
Real-Time Sessions
SQL
Slow Query Logs
Top SQL
SQL Insights
SQL Diagnosis
SQL Statement Concurrency Control
Auto Flow Control
Locks and Transactions
InnoDB Locks
Metadata Locks
Storage Analysis
Daily Reports
Inspection Score
Inspection Score
Scoring Rules
Intelligent O&M (Old Version)
Setting an Instance as Paid
Performance
Performance History
Real-Time Performance
Real-Time Diagnosis
Performance Trends Comparisons
Custom Graphs
Sessions
Sessions that Can Be Killed If Necessary
Real-Time Sessions
SQL
Slow Query Logs
SQL Explorer
SQL Diagnosis
SQL Statement Concurrency Control
Locks and Transactions
InnoDB Locks
Metadata Locks
Daily Reports
Microsoft SQL Server
Account Management
Creating a Login Name
Database User Management
Database Role Management
Database Management
Creating a Database
Dropping a Database
SQL Operations
SQL Window
Executing SQL Statements
Executing SQL Plan
SQL Favorites
SQL History
Table Management
Creating a Table
Opening a Table
Viewing Details of a Table
Altering a Table
Renaming a Table
Clearing a Table
Dropping a Table
View Management
Creating a View
Dropping a View
Opening a View
Altering a View
Viewing Details of a View
Stored Procedure Management
Creating a Stored Procedure
Altering or Executing a Stored Procedure
Dropping a Stored Procedure
Viewing Details of a Stored Procedure
Trigger Management
Creating a Trigger
Altering a Trigger
Dropping a Trigger
Viewing Details of a Trigger
Function Management
Creating a Function
Altering or Executing a Function
Dropping a Function
Viewing Details of a Function
Data Import and Export
Importing Data
Exporting Data
PostgreSQL
Account Management
Role Management
Database Management
Creating a Database
Deleting a Database
SQL Operations
SQL Window
Executing SQL Statements
Executing SQL Plan
SQL Favorites
SQL History
Table Management
Opening a Table
Viewing Details of a Table
View Management
Opening a View
Viewing Details of a View
Stored Procedure Management
Viewing Details of a Stored Procedure
Trigger Management
Viewing Details of a Trigger
Sequence Management
Viewing Details of a Sequence
Data Import and Export
Importing Data
Exporting Data
Intelligent O&M
Dashboard
Setting an Instance as Paid
SQL
Slow Query Logs
SQL Explorer
RDS for MariaDB
Account Management
Creating a User
Editing a User
Deleting a User
Database Management
SQL Operations
SQL Window
Executing SQL Statements
SQL Execution Plan
SQL Favorites
SQL History
Table Management
Creating a Table
Opening a Table
Viewing Details of a Table
Altering a Table
Renaming a Table
Clearing a Table
Dropping a Table
Maintaining a Table
View Management
Creating a View
Opening a View
Altering a View
Dropping a View
Viewing Details of a View
Stored Procedure Management
Creating a Stored Procedure
Altering or Executing a Stored Procedure
Dropping a Stored Procedure
Viewing Details of a Stored Procedure
Event Management
Creating an Event
Altering an Event
Dropping an Event
Viewing Details of an Event
Trigger Management
Creating a Trigger
Altering a Trigger
Dropping a Trigger
Viewing Details of a Trigger
Function Management
Creating a Function
Altering or Executing a Function
Dropping a Function
Viewing Details of a Function
Data Import and Export
Data Generator (Not Promoted)
Task Management
Scheduling Tasks (Not Promoted)
Scheduled Backup (Not Promoted)
Table Structure Comparison and Synchronization (Not Promoted)
Intelligent O&M
Dashboard
Setting an Instance as Paid
Viewing the Overall Status of an Instance
Real-Time Performance
SQL
Slow Query Logs
SQL Statement Concurrency Control
Auto Flow Control
Storage Analysis
Daily Reports
GaussDB
Account Management
Role Management
Database Management
Creating a Database
Deleting a Database
Creating a Schema
Opening a Schema
Dropping a Schema
SQL Operations
SQL Query
Executing SQL Statements
Executing SQL Plan
SQL Favorites
SQL History
Table Management
Opening a Table
Viewing Details of a Table
View Management
Opening a View
Viewing Details of a View
Stored Procedure Management
Creating a Stored Procedure
Altering or Executing a Stored Procedure
Viewing Details of a Stored Procedure
Dropping a Stored Procedure
Trigger Management
Viewing Details of a Trigger
Sequence Management
Viewing Details of a Sequence
Data Import and Export
Importing Data
Exporting Data
Intelligent O&M
Dashboard
Setting an Instance as Paid
Performance
Instance Performance
Single Node with Multiple Metrics
Multiple Nodes with a Single Metric
Real-Time sessions
SQL
Slow Query Logs
SQL Explorer
Daily Reports
WDR Reports
GaussDB(for MySQL)
Account Management
Creating a User
Editing a User
Deleting a user
Database Management
SQL Operations
SQL Window
Executing SQL Statements
SQL Execution Plan
SQL Favorites
SQL History
Table Management
Creating a Table
Opening a Table
Viewing Details of a Table
Altering a Table
Renaming a Table
Clearing a Table
Dropping a Table
Maintaining a Table
View Management
Creating a View
Opening a View
Altering a View
Dropping a View
Event Management
Creating an Event
Altering an Event
Dropping an Event
Stored Procedure Management
Creating a Stored Procedure
Altering or Executing a Stored Procedure
Dropping a Stored Procedure
Function Management
Creating a Function
Altering or Executing a Function
Dropping a Function
Trigger Management
Creating a Trigger
Altering a Trigger
Dropping a Trigger
Data Import and Export
Importing Data
Exporting Data
Data Generator (Not Promoted)
Task Management
Task Scheduling
Scheduled Backup (Not Promoted)
Table Structure Comparison and Synchronization (Not Promoted)
Intelligent O&M
Dashboard
Setting an Instance as Paid
Performance
Performance History
Real-Time Performance
Real-Time Diagnosis
Performance Trends Comparisons
Custom Graphs
Sessions
Sessions that Can Be Killed If Necessary
Real-Time Sessions
SQL
Slow Query Logs
SQL Explorer
SQL Diagnosis
SQL Statement Concurrency Control
Daily Reports
Locks and Transactions
InnoDB Locks
GeminiDB Cassandra
Account Management
Role Management
Keyspace Management
Overview
Creating a Keyspace
Deleting a Keyspace
SQL Operations
SQL Window
Executing SQL Statements
SQL Favorites
SQL History
Table Management
Creating a Table
Opening a Table
Viewing Details of a Table
Altering a Table
Clearing a Table
Dropping a Table
View Management
Opening a View
Viewing Details of a View
Keyspace Custom Types
Viewing Custom Type
Data Import and Export
Importing Data
Exporting Data
GaussDB(DWS)
Database Management
Creating a Database
Deleting a Database
SQL Operations
SQL Window
Executing SQL Statements
Executing SQL Plan
SQL Favorites
Executed SQL Statements
Table Management
Opening a Table
Viewing Details of a Table
View Management
Opening a View
Viewing Details of a View
Stored Procedure Management
Creating a Stored Procedure
Altering or Executing a Stored Procedure
Viewing Details of a Stored Procedure
Dropping a Stored Procedure
Trigger Management
Viewing Details of a Trigger
Sequence Management
Viewing Details of a Sequence
Operation Audit
DDS
Account Management
User Management
Role Management
Database Management
Creating a Database
Dropping a Database
Command Operation
Command Query
Command History
Collection Management
Creating a Collection
Opening a Collection
Altering Validator
Renaming a Collection
Clearing a Collection
Dropping a Collection
Creating an Index
Editing an Index
Deleting an Index
View Management
Creating a View
Opening a View
Editing a View
Dropping a View
Intelligent O&M
Querying the Number of Connections to an Instance
Sessions
Slow Query Logs
DDM
Account Management
User Management
Database Management
SQL Operations
SQL Window
Executing SQL Statements
Executing SQL Plan
SQL Favorites
SQL History
Table Management
Creating a Table
Opening a Table
Viewing Details of a Table
Altering a Table
Clearing a Table
Dropping a Table
Intelligent O&M
Setting an Instance as Paid
SQL
Slow Query Logs
SQL Explorer
Audit
DAS Key Operations Supported by CTS
Viewing Traces
Event Monitoring
Overview
Viewing Event Monitoring Data
Creating an Alarm Rule for Event Monitoring
Events Supported by Event Monitoring
Best Practices
How Do I Use DAS to Log In to an Instance Using a Read-Only Account?
How Do I Check and Optimize Tables by Checking Top SQL?
Fixing Slow SQL Queries
API Reference
Before You Start
Overview
API Calling
Endpoints
Constraints
Concepts
API Overview
Calling APIs
Making an API Request
Authentication
Response
APIs (in OBT)
API Version Queries
Querying API Versions
Querying a Specified API Version
Cloud DBA
Registering a Database User
Modifying a Database User
Deleting a Database User
Querying Intelligent O&M Quotas
Querying a Specified Database User
Querying Database Users
Killing Sessions
Querying the SQL Execution Plan (GET Request)
Querying SQL Execution Plan (POST Request)
Querying Metadata Locks
Querying Instance Sessions
Querying InnoDB Lock Waits
Enabling or Disabling SQL Explorer and Slow Query Log
Querying Whether SQL Explorer and Slow Query Log Are Enabled
Exporting Slow Query Logs
Exporting All SQL Statements
Querying Whether SQL Statement Concurrency Control Is Enabled
Enabling or Disabling SQL Statement Concurrency Control
Querying Concurrency Control Rules of SQL Statements
Generate Keywords of a Concurrency Control Rule from the Original SQL Statement
Creating a Concurrency Control Rule for SQL Statements
Deleting a Concurrency Control Rule of SQL Statements
Querying SQL Statement Concurrency Control Tasks
Exporting the Top SQL Template List
Exporting SQL Execution Time Distribution
Exporting Slow SQL Template List
Viewing the Instance List on the Intelligent O&M Page
Setting a Shared Link
Deleting a Shared Link
Executing a SQL Diagnosis
Obtaining Diagnosis Results
Deprecated APIs
Creating a Space Analysis Task
Obtaining the Space Analysis Data List
Permissions Policies and Supported Actions
Introduction
DAS Actions
Appendixes
Abnormal Request Results
Status Codes
Error Codes
Obtaining a Project ID
FAQs
Product Consulting
How Is DAS Billed?
Which Data Sources Does DAS Support?
Does DAS Support Multi-Region Access?
Where Is SQL Execution Records Saved If I Enable This Function?
What Should I Enter in the Database Column to Log In to a PostgreSQL DB Instance on the DAS Console?
Will I Be Changed If I Enable Collect Metadata Periodically and Show Executed SQL Statements on the Add Login Page?
Managing connections
What Should I Do If I Can't Connect to My DB Instance Due to Insufficient Permissions?
What Should I Do If I Can't Connect to My RDS for MySQL Instance?
What Should I Do If I Can't Connect to My ECS (MySQL) Instance?
What Should I Do If I Can't Connect to My RDS for SQL Server Instance?
What Should I Do If I Can't Connect to My ECS (Microsoft SQL Server) Instance?
What Should I Do If I Can't Connect to My RDS for PostgreSQL Instance?
What Should I Do If I Can't Connect to My ECS (PostgreSQL) Instance?
What Should I Do If I Can't Connect to My DDS Instance?
What Should I Do If I Can't Connect to My GaussDB(for MySQL) Instance?
What Should I Do If I Can't Connect to My GaussDB Instance?
What Should I Do If I Can't Connect to My DDM Instance?
How Do I View and Modify ECS Security Group Rules?
How Do I View and Modify Firewall Rules?
What Should I Do If My Connection Fails?
Usage
What Can I Do If Garbled Characters Are Displayed in the Exported Database Result Set?
What Are the Precautions for Connecting DAS to a Third-Party Client?
What Are the Username and Password for DAS?
What Should I Do If Table Obtaining Times Out?
How Do I Modify the Collation?
When a user creates a data tracking task, an error message indicating that the current user does not have the OBS operator permissions is displayed.
Resource Freezing, Release, Deletion, and Unsubscription
Glossary
Videos
More Documents
User Guide (ME-Abu Dhabi Region)
Service Overview
What Is Data Admin Service?
Basic Concepts
Advantages
Permissions Management
Billing
Getting Started
Intelligent O&M
Step 1: Log In to DAS
Step 2: Switch to Intelligent O&M
Step 3: Set an Instance as Paid
Step 4: Set the Instance as Free
Data Management
Overview
Step 1: Log In to DAS
Step 2: Add Database Login Information
Step 3: Log In to a Database
Step 4: Manage Data
User Guide
Permissions Management
Creating a User and Granting Permissions
DAS Custom Policies
Logging In to the DAS Console
Adding Login Information
Modifying Login Information
Deleting Login Information
Logging In to Databases Shared by Others
MySQL DB Instance Management (Development Tool)
Homepage
Overview
Creating a Database
Dropping a Database
Data Dictionary
SQL Operations
SQL Window
Executing SQL Statements
Executing SQL Plan
SQL Favorites
SQL History
Database Management
Table Management
Creating a Table
Opening a Table
Viewing Table Details
Altering a Table
Renaming a Table
Clearing a Table
Dropping a Table
Maintaining a Table
View Management
Creating a View
Opening a View
Altering a View
Dropping a View
Stored Procedure Management
Creating a Stored Procedure
Altering or Executing a Stored Procedure
Dropping a Stored Procedure
Viewing Stored Procedure Details
Event Management
Creating an Event
Altering an Event
Dropping an Event
Trigger Management
Creating a Trigger
Altering a Trigger
Dropping a Trigger
Function Management
Creating a Function
Altering or Executing a Function
Dropping a Function
Viewing Details of a Function
Import and Export
Data Import
Data Export
Structure Management
Table Structure Comparison and Synchronization
Data Scheme
Data Generator
Data Tracking and Rollback
Background Tasks
Task Scheduling
Scheduled Backup
Account Management
Database Account Security
Creating a User
Editing User Information
Deleting a User
Microsoft SQL Server DB Instance Management (Development Tool)
Homepage
Overview
Creating a Database
Dropping a Database
SQL Operations
SQL Window
Executing SQL Statements
Executing SQL Plan
SQL Favorites
SQL History
Database Management
Table Management
Creating a Table
Opening a Table
Viewing Table Details
Altering a Table
Renaming a Table
Clearing a Table
Dropping a Table
View Management
Creating a View
Dropping a View
Opening a View
Altering a View
Stored Procedure Management
Creating a Stored Procedure
Altering or Executing a Stored Procedure
Dropping a Stored Procedure
Viewing Stored Procedure Details
Trigger Management
Creating a Trigger
Altering a Trigger
Dropping a Trigger
Function Management
Creating a Function
Altering or Executing a Function
Dropping a Function
Viewing Function Details
Import and Export
Data Import
Data Export
Account Management
Creating a Login Name
Database User Management
Database Role Management
PostgreSQL DB Instance Management (Development Tool)
Homepage
Overview
Creating a Database
Dropping a Database
SQL Operations
SQL Window
Executing SQL Statements
Executing the SQL Plan
SQL Favorites
SQL History
Database Management
Table Management
Opening a Table
Viewing Table Details
View Management
Opening a View
Obtaining View Details
Stored Procedure Management
Viewing Stored Procedure Details
Trigger Management
Viewing Trigger Details
Sequence Management
Viewing Sequence Details
Import and Export
Data Import
Data Export
Account Management
Role Management
DDS DB Instance Management (Development Tool)
Homepage
Overview
Creating a Database
Dropping a Database
Command Operation
Command Window
Command History
Database Management
Collection Management
Creating a Collection
Opening a Collection
Altering Validator
Renaming a Collection
Clearing a Collection
Dropping a Collection
Creating an Index
Editing an Index
Deleting an Index
View Management
Creating a View
Opening a View
Editing a View
Dropping a View
Account Management
User Management
Role Management
Enterprise Change Approval
Introduction
What Is Enterprise Change Approval
User Roles
Scenarios
Enabling Enterprise Change Approval
Home Page
Tickets
Creating a Ticket
Instances/Databases/Sensitive Columns
Instances
Databases
Sensitive Columns
SQL Window
Database Management
My Permissions
Objects
Table Management
View Management
Stored Procedure Management
Event Management
Trigger Management
Function Management
SQL Window
Metadata Collection
Data Schemes
SQL Modification
Data Import
Data Export
System Management
Instance Management
User Management
Approval Process Management
Access Control
Operation Audit
Global Configuration Management
Intelligent O&M
MySQL DB Instances
Function Overview
Performance
Real-Time Performance
Sessions
Real-Time Sessions
Emergency Channel
Locks and Transactions
InnoDB Lock Query
Metadata Locks
RDS for PostgreSQL Instances
Function Overview
SQL
SQL Explorer
FAQs
Connection Management (Development Tool)
Permission Issues
MySQL
RDS Instances
DDS
Reference
Modifying ECS Security Group Rules
Modifying Firewall Rules
Usage
What Can I Do If Garbled Characters Are Displayed in the Exported Database Result Set?
What Are the Precautions for Connecting DAS to a Third-Party Client?
What Are the Username and Password for DAS?
What Should I Do If Table Obtaining Times Out?
Change History
General Reference
Glossary
Service Level Agreement
White Papers
Endpoints
Permissions