Help Center/ Data Admin Service/ User Guide/ Audit/ DAS Key Operations Supported by CTS
Updated on 2025-07-08 GMT+08:00

DAS Key Operations Supported by CTS

With CTS, you can record DAS key operations for later query, audit, and backtracking.

Table 1 Key operations on DAS

Operation

Resource Type

Trace Name

Generating a new order

order

applyService

Asynchronously exporting a result set

connection

asyncExportData

Automatically filling in a SQL statement

connection

autoFill

Adding shared connections in batches

connection

batchAddSharedConnections

Deleting connections in batches

connection

batchDeleteConnections

Canceling the execution of a SQL statement

connection

cancelExecute

Canceling a shared connection

connection

cancelShareConnections

Setting the deadlock switch

instance

changeDeadLockSwitch

Enabling or disabling the switch for collecting all query logs

instance

changeFullSqlSwitch

Configuring auto throttling

instance

changeKillTaskSwitch

Setting the lock block switch

instance

changeLockBlockingSwitch

Enabling or disabling SQL statements

instance

changeSqlSwitch

Enabling or disabling historical transactions

instance

changeTransactionSwitchStatus

Clearing connections

connection

clearConnections

Closing SQL Query

connection

closeWindow

Creating a database in a GeminiDB Cassandra instance

connection

createCassandraDatabases

Creating a connection

instance

createConnection

Creating a database

connection

createDatabases

Creating a login connection

connection

createDBLogin

Creating an analysis task for a daily database health report

instance

CreateHealthReportTask

Creating a task for exporting index usage

instance

createIndexUsageExportTask

Adding a task for automatically killing sessions

instance

createKillTask

Creating a task for exporting missing indexes

instance

createMissingIndexExportTask

Setting a shared connection

connection

createShareConnections

Creating a task for exporting slow query logs

instance

createSlowLogExportTask

Executing a space analysis task

instance

createSpaceAnalysisTask

Adding a SQL throttling rule

connection

createSqlLimitRules

Creating an RDS for SQL Server database

connection

createSqlServerDatabases

Creating a task for generating test data

connection

createTestDataTask

Logging in to, retrying login to, and logging out of a database

connection

databaseLoginActions

Creating a database

connection

databases

Logging in to a database

instance

dbsConnection

Logging in to a DDS database

connection

ddsConnection

Killing all sessions by one click

instance

deleteAllSessions

Deleting a batch diagnosis task

connection

deleteBatchTuning

Deleting a role of a GeminiDB Cassandra instance

connection

deleteCassandraRole

Deleting roles of a GeminiDB Cassandra instance in batches

connection

deleteCassandraRoles

Deleting a connection

connection

deleteConnection

Deleting login information

connection

deleteDBLogin

Deleting an object

connection

deleteDbObj

Deleting a created database user

instance

deleteDbUser

Deleting sql execution records

connection

deleteExecSqlRecord

Deleting OBS files of a task for exporting slow query logs

instance

deleteExportTaskObsFile

Deleting data of a specified instance and time range

instance

deleteFullSqlLogData

Deleting a role of a GaussDB V5 instance

connection

deleteGaussDBV5Role

Deleting roles of a GaussDB V5 instance in batches

connection

deleteGaussDBV5Roles

Deleting a session

connection

deleteProcess

Deleting a resource

order

deleteService

Deleting data of a specified instance and time range

instance

deleteSlowLogData

Deleting a task for generating test data

connection

deleteTestDataTask

Deleting a diagnosis task

connection

deleteTune

Deleting a user permission

connection

deleteUserPrivilege

Deleting a user or role of an RDS for SQL Server instance

connection

deleteUserRole

Deleting users or roles of an RDS for SQL Server instance

connection

deleteUserRoles

Deleting a SQL throttling rule

connection

delSqlLimitingRecord

Editing result sets

connection

editDatas

Creating a batch diagnosis task

connection

exeBatchTuning

Executing the role script of a GeminiDB Cassandra instance

connection

execCassandraRoleScript

Executing the role script of a GaussDB V5 instance

connection

execGaussDBV5RoleScript

Executing a user permission script

connection

execUserPrivilegeSql

Executing a SQL statement

connection

executeSql

Running SQL statements for GeminiDB Influx instances

connection

exeInflux

Running SQL statements for GeminiDB Redis instances

connection

exeRedis

Executing a SQL diagnosis task

connection

exeTuning

Performing SQL diagnosis tasks synchronously

connection

exeTuningSync

Exporting result sets

connection

exportData

Querying statistics on slow query logs

instance

exportSlowSqlStatistics

Obtaining a SQL template of slow query logs

instance

exportSlowSqlTemplatesDetails

Obtaining the quantity trend of slow query logs

instance

exportSlowSqlTrendDetails

Creating a task for exporting result sets of all query logs

instance

exportSqlStatements

Exporting risky instances

instance

exportTopRiskInstances

Obtaining the SQL template list

instance

exportTopSqlTemplatesDetails

Obtaining the percentage of SQL execution duration ranges

instance

exportTopSqlTrendDetails

Formatting a SQL statement

connection

formatSql

Obtaining the execution script of a GeminiDB Cassandra instance

connection

getCassandraRoleScript

Running the SQL statement for obtaining collation

connection

getCharSetCollations

Obtaining the script for creating user permissions

connection

getCreateUserPrivilegeSql

Obtaining the script for creating or modifying a role of an RDS for SQL Server instance

connection

getDbRoleExeScript

Obtaining the script for creating or modifying a user of an RDS for SQL Server instance

connection

getDbUserExeScript

Obtaining SQL statements being executed in the SQL window

connection

getExecuteResult

Obtaining exported result sets

connection

getExportDataResult

Obtaining the execution script of a GaussDB V5 instance

connection

getGaussDBV5RoleScript

Querying a SQL execution plan

instance

getPlan

Obtaining the script for creating or modifying user configuration archives of a GaussDB instance

connection

getProfileSql

Obtaining the script for creating or modifying a role of a GaussDB instance

connection

getRoleSql

Obtaining the script for obtaining and modifying user permissions of a MySQL instance

connection

getUpdateUserPrivilegeSql

Obtaining the script for creating or modifying a user

connection

getUserSql

Saving a user-defined SQL statement

connection

insertUserSql

Obtaining the DAS instance list

instance

listCloudDbaInstances

Querying a connection

connection

listDbUsers

Obtaining daily database health check tasks

instance

ListHealthReportTask

Querying lock waits

connection

listInnodbLocks

Checking instance distribution on the tenant dashboard

instance

ListInstanceDistribution

Obtaining data of a single metric on multiple nodes

instance

ListInstanceMultiNodesSingleMetric

Obtaining information about a single instance node on Intelligent O&M

instance

ListInstanceNodesInfo

Querying top slow query logs on the tenant dashboard

instance

ListInstanceTopSlowLog

Obtaining a metadata lock

instance

listMetadataLocks

Querying sessions of an instance

instance

listProcesses

Querying risky instances on the tenant dashboard

connection

ListRiskItems

Querying the risk trend on the tenant dashboard

connection

ListRiskTrend

Querying the object list and space

instance

listSpaceAnalysis

Querying SQL throttling rules

instance

listSqlLimitRules

Querying top slow query logs on the tenant dashboard

connection

ListTopSlowLog

Querying historical transactions

instance

listTransactions

Modifying a connection

connection

modifyConnection

Modifying a database

connection

modifyDatabase

Changing specifications

order

modifyService

Generating keywords of a SQL throttling rule based on the original SQL statement

instance

parseSqlLimitRules

Previewing a task for killing sessions

instance

previewSessionForKillProcessTask

Previewing test data

connection

previewTestDataCreate

Updating security protocol intent

instance

putDataPolicy

Calculating the number of rows in a result set

connection

queryResultRows

Re-collecting index usage

instance

recollectIndexUsage

Re-collecting missing indexes

instance

recollectMissingIndex

Creating a database user

instance

registerDbUser

Renaming a login account

connection

renameDBLogin

Renaming a role of a GaussDB V5 instance

connection

renameGaussDBV5Role

Renaming a user or role

connection

renameUserRole

Setting the switch of full deadlocks

instance

setFullDeadLockSwitch

Setting the switch of historical locks

instance

setHistoryTransactionSwitch

Setting the switch of index usage

instance

setIndexUsageSwitch

Setting the switch of long historical locks

instance

setLongHistoryTransactionSwitch

Setting the switch of missing indexes

instance

setMissingIndexSwitch

Configuring slow query logs

instance

setSlowLogConfig

Configuring the switch for collecting slow query logs

instance

setSlowLogSwitch

Configuring SQL throttling

connection

setSqlLimitingSwitch

Configuring metric thresholds on the tenant dashboard

connection

SetThresholdForMetric

Querying database users

instance

showDbUser

Obtaining daily database health reports

instance

ShowInstanceHealthReport

Querying a single metric of multiple nodes on the tenant dashboard

connection

ShowMetricNamesSupport

Querying resource quotas

connection

showQuotas

Querying a SQL execution plan

instance

showSqlExecutionPlan

Querying information about a SQL throttling task

instance

showSqlLimitJobInfo

Querying whether SQL throttling is enabled

instance

showSqlLimitSwitchStatus

Querying the log switch

instance

showSqlSwitchStatus

Querying the switch status of historical transactions

instance

showTransactionSwitchStatus

Obtaining SQL diagnosis results

connection

showTuning

Splitting SQL statements

connection

splitSql

Stopping diagnosis tasks in a batch

connection

stopBatchTuning

Stopping a task for automatically killing sessions

instance

stopKillTask

Stopping a task for automatically generating test data

connection

stopTestDataTaskCreate

Submitting feedback

connection

submitTuningFeedback

Enabling or disabling a single SQL throttling rule

connection

switchSqlLimitingRule

Synchronizing the instance list on Intelligent O&M

instance

SynchronizeInstanceList

Testing the connection

connection

testConnection

Triggering archiving of slow query logs

instance

triggerSlowLogArchive

Obtaining the snapshot list

connection

triggerWdr

Updating quotas

connection

udpateQuota

Modifying login information

connection

updateDBLogin

Modifying a created database user

instance

updateDbUser

Modifying a SQL throttling rule

instance

updateSqlLimitingRecord

Editing a user-defined SQL statement

connection

updateUserSql

Verifying a connection

connection

verifyConnection

Creating a task for exporting SQL result sets

connection

createExportSqlResultsetTask

Creating a database backup task

connection

createExportDatabaseTask

Creating a quick database export task

connection

createExportQuickDatabaseTask

Deleting an export task

connection

deleteExportTask

Stopping an export task

connection

stopExportTask

Creating a task for importing a SQL file

connection

createImportSqlFileTask

Creating a task for importing a CSV file

connection

createImportCsvFileTask

Deleting an import task

connection

deleteImportTask

Stopping an import task

connection

stopImportTask

Creating a bucket

connection

createBucket

Uploading an initialized file

connection

initFileUpload

Uploading file fragments

connection

uploadFilePart

Combining file fragments

connection

mergeFilePart