TencentDB account information
Used by actions: ModifyAccountPrivileges.
Name | Type | Required | Description |
---|---|---|---|
User | String | Yes | Account name |
Host | String | Yes | Host address |
Column permission information
Used by actions: ModifyAccountPrivileges.
Name | Type | Required | Description |
---|---|---|---|
Database | String | Yes | Database name |
Table | String | Yes | Table name |
Column | String | Yes | Column name |
Privileges | Array of String | Yes | Permission information |
Range of constraint type values
Used by actions: DescribeDBParameters.
Name | Type | Description |
---|---|---|
Min | String | Minimum value when the constraint type is section |
Max | String | Maximum value when the constraint type is section |
TencentDB account information
Used by actions: DescribeAccounts.
Name | Type | Description |
---|---|---|
UserName | String | Username |
Host | String | Host from which a user can log in (corresponding to the host field for a MySQL user; a user is uniquely identified by username and host; this parameter is in IP format and ends with % for IP range; % can be entered; if this parameter is left empty, % will be used by default). |
Description | String | User remarks |
CreateTime | Timestamp | Creation time |
UpdateTime | Timestamp | Last updated time |
ReadOnly | Integer | Read-only flag. 0: no; 1: for the account's SQL requests, the replica will be used first, and if it is unavailable, the primary will be used; 2: the replica will be used first, and if it is unavailable, the operation will fail. |
DelayThresh | Integer | This field is meaningful for read-only accounts, indicating that a replica should be selected if its delay from the primary is less than this value. Note: This field may return null, indicating that no valid values can be obtained. |
SlaveConst | Integer | Whether to specify a replica server for read-only account. Valid values: 0 (No replica server is specified, which means that the proxy will select another available replica server to keep connection with the client if the current replica server doesn’t meet the requirement). 1 (The replica server is specified, which means that the connection will be disconnected if the specified replica server doesn’t meet the requirement.) |
MaxUserConnections | Integer | Maximum number of connections. 0 indicates no limit. |
TencentDB instance details.
Used by actions: DescribeDBInstances.
Name | Type | Description |
---|---|---|
InstanceId | String | Instance ID, which uniquely identifies a TDSQL instance |
InstanceName | String | Customizable instance name |
AppId | Integer | Application ID of instance |
ProjectId | Integer | Project ID of instance |
Region | String | Instance region name, such as ap-shanghai |
Zone | String | Instance AZ name, such as ap-guangzhou-1 |
VpcId | Integer | VPC ID, which is 0 if the basic network is used |
SubnetId | Integer | Subnet ID, which is 0 if the basic network is used |
Status | Integer | Instance status. Valid values: 0 (creating), 1 (running task), 2 (running), 3 (uninitialized), -1 (isolated), 4 (initializing), 5 (eliminating), 6 (restarting), 7 (migrating data) |
Vip | String | Private IP address |
Vport | Integer | Private network port |
WanDomain | String | Domain name for public network access, which can be resolved by the public network |
WanVip | String | Public IP address, which can be accessed over the public network |
WanPort | Integer | Public network port |
CreateTime | Timestamp | Instance creation time in the format of 2006-01-02 15:04:05 |
UpdateTime | Timestamp | Last updated time of instance in the format of 2006-01-02 15:04:05 |
AutoRenewFlag | Integer | Auto-renewal flag. 0: no, 1: yes |
PeriodEndTime | Timestamp | Instance expiration time in the format of 2006-01-02 15:04:05 |
Uin | String | Instance account |
TdsqlVersion | String | TDSQL version information |
Memory | Integer | Instance memory size in GB |
Storage | Integer | Instance storage capacity in GB |
UniqueVpcId | String | VPC ID in string type |
UniqueSubnetId | String | VPC subnet ID in string type |
OriginSerialId | String | Original ID of instance (this field is obsolete and should not be depended on) |
NodeCount | Integer | Number of nodes. 2: one master and one slave, 3: one master and two slaves |
IsTmp | Integer | Whether it is a temp instance. 0: no, non-zero value: yes |
ExclusterId | String | Dedicated cluster ID. If this parameter is empty, the instance is a general instance |
Id | Integer | Numeric ID of instance (this field is obsolete and should not be depended on) |
Pid | Integer | Product type ID |
Qps | Integer | Maximum QPS value |
Paymode | String | Billing mode Note: this field may return null, indicating that no valid values can be obtained. |
Locker | Integer | Async task flow ID when an async task is in progress on an instance Note: this field may return null, indicating that no valid values can be obtained. |
StatusDesc | String | Current instance running status description Note: this field may return null, indicating that no valid values can be obtained. |
WanStatus | Integer | Public network access status. 0: not enabled, 1: enabled, 2: disabled, 3: enabling |
IsAuditSupported | Integer | Whether the instance supports audit. 1: yes, 0: no |
Machine | String | Model |
IsEncryptSupported | Integer | Whether data encryption is supported. 1: yes, 0: no |
Cpu | Integer | Number of CPU cores of instance |
Ipv6Flag | Integer | Indicates whether the instance uses IPv6 Note: this field may return null, indicating that no valid values can be obtained. |
Vipv6 | String | Private network IPv6 address Note: this field may return null, indicating that no valid values can be obtained. |
WanVipv6 | String | Public network IPv6 address Note: this field may return null, indicating that no valid values can be obtained. |
WanPortIpv6 | Integer | Public network IPv6 port Note: this field may return null, indicating that no valid values can be obtained. |
WanStatusIpv6 | Integer | Public network IPv6 status Note: this field may return null, indicating that no valid values can be obtained. |
DbEngine | String | Database engine Note: this field may return null, indicating that no valid values can be obtained. |
DbVersion | String | Database version Note: this field may return null, indicating that no valid values can be obtained. |
DcnFlag | Integer | DCN type. Valid values: 0 (null), 1 (primary instance), 2 (disaster recovery instance) Note: this field may return null, indicating that no valid values can be obtained. |
DcnStatus | Integer | DCN status. Valid values: 0 (null), 1 (creating), 2 (syncing), 3 (disconnected) Note: this field may return null, indicating that no valid values can be obtained. |
DcnDstNum | Integer | The number of DCN disaster recovery instances Note: this field may return null, indicating that no valid values can be obtained. |
InstanceType | Integer | Instance type. Valid values: 1 (dedicated primary instance), 2 (primary instance), 3 (disaster recovery instance), and 4 (dedicated disaster recovery instance).Note: this field may return null, indicating that no valid values can be obtained. |
ResourceTags | Array of ResourceTag | Instance tag information Note: this field may return null , indicating that no valid values can be obtained. |
DbVersionId | String | Database version Note: This field may return null, indicating that no valid values can be obtained. |
TencentDB parameter information.
Used by actions: CreateDBInstance, CreateHourDBInstance, ModifyDBParameters.
Name | Type | Required | Description |
---|---|---|---|
Param | String | Yes | Parameter name |
Value | String | Yes | Parameter value |
DCN configuration
Used by actions: DescribeDBInstanceDetail, DescribeDcnDetail.
Name | Type | Description |
---|---|---|
RoReplicationMode | String | DCN running status. Valid values: START (running), STOP (pause)Note: This field may return null, indicating that no valid values can be obtained. |
DelayReplicationType | String | Delayed replication type. Valid values: DEFAULT (no delay), DUE_TIME (specified replication time)Note: This field may return null, indicating that no valid values can be obtained. |
DueTime | String | Specified time for delayed replication Note: This field may return null, indicating that no valid values can be obtained. |
ReplicationDelay | Integer | The number of seconds to delay the replication Note: This field may return null, indicating that no valid values can be obtained. |
DCN status information
Used by actions: DescribeDBInstanceDetail, DescribeDcnDetail.
Name | Type | Description |
---|---|---|
Status | String | DCN running status. Valid values: START (running), STOP (pause).Note: This field may return null, indicating that no valid values can be obtained. |
Delay | Integer | The current delay, which takes the delay value of the replica instance. |
Database information
Used by actions: DescribeDatabases.
Name | Type | Description |
---|---|---|
DbName | String | Database name |
Database function information
Used by actions: DescribeDatabaseObjects.
Name | Type | Description |
---|---|---|
Func | String | Function name |
Database permission
Used by actions: ModifyAccountPrivileges.
Name | Type | Required | Description |
---|---|---|---|
Privileges | Array of String | Yes | Permission information |
Database | String | Yes | Database name |
Database stored procedure information
Used by actions: DescribeDatabaseObjects.
Name | Type | Description |
---|---|---|
Proc | String | Stored procedure name |
Database table information
Used by actions: DescribeDatabaseObjects.
Name | Type | Description |
---|---|---|
Table | String | Table name |
Database view information
Used by actions: DescribeDatabaseObjects.
Name | Type | Description |
---|---|---|
View | String | View name |
DCN details
Used by actions: DescribeDcnDetail.
Name | Type | Description |
---|---|---|
InstanceId | String | Instance ID |
InstanceName | String | Instance name |
Region | String | Region where the instance resides |
Zone | String | Availability zone where the instance resides |
Vip | String | Instance IP address |
Vipv6 | String | Instance IPv6 address |
Vport | Integer | Instance port |
Status | Integer | Instance status |
StatusDesc | String | Instance status description |
DcnFlag | Integer | DCN flag. Valid values: 1 (primary), 2 (disaster recovery) |
DcnStatus | Integer | DCN status. Valid values: 0 (none), 1 (creating), 2 (syncing), 3 (disconnected) |
Cpu | Integer | Number of CPU cores of the instance |
Memory | Integer | Instance memory capacity in GB |
Storage | Integer | Instance storage capacity in GB |
PayMode | Integer | Billing mode |
CreateTime | String | Creation time of the instance in the format of 2006-01-02 15:04:05 |
PeriodEndTime | String | Expiration time of the instance in the format of 2006-01-02 15:04:05 |
InstanceType | Integer | Instance type. Valid values: 1 (dedicated primary instance), 2 (non-dedicated primary instance), 3 (non-dedicated disaster recovery instance), 4 (dedicated disaster recovery instance) |
ReplicaConfig | DCNReplicaConfig | Configuration information of DCN replication. This field is null for a primary instance. Note: This field may return null, indicating that no valid values can be obtained. |
ReplicaStatus | DCNReplicaStatus | DCN replication status. This field is null for the primary instance. Note: This field may return null, indicating that no valid values can be obtained. |
EncryptStatus | Integer | Whether KMS is enabled. |
Order information
Used by actions: DescribeOrders.
Name | Type | Description |
---|---|---|
DealName | String | Order number |
OwnerUin | String | Account |
Count | Integer | Number of items |
FlowId | Integer | ID of the associated process, which can be used to query the process execution status. |
InstanceIds | Array of String | The ID of the created instance, which is required only for the order that creates an instance. Note: This field may return null, indicating that no valid values can be obtained. |
PayMode | Integer | Payment mode. Valid values: 0 (postpaid), 1 (prepaid) |
Function permission information
Used by actions: ModifyAccountPrivileges.
Name | Type | Required | Description |
---|---|---|---|
Database | String | Yes | Database name |
FunctionName | String | Yes | Function name |
Privileges | Array of String | Yes | Permission information |
Backup file details of an instance
Used by actions: DescribeBackupFiles.
Name | Type | Description |
---|---|---|
InstanceId | String | Instance ID |
InstanceName | String | Instance name |
InstanceStatus | Integer | Instance status |
ShardId | String | Shard ID Note: This field may return null, indicating that no valid values can be obtained. |
FilePath | String | File path |
FileName | String | File name |
FileSize | Integer | File size |
BackupType | String | Backup type. Valid values: Data (data backup), Binlog (Binlog backup), Errlog (error log), Slowlog (slow log). |
ManualBackup | Integer | Manual backup. Valid values: 0 (no), 1 (yes). |
StartTime | String | Backup start time |
EndTime | String | Backup end time |
Pulled log information
Used by actions: DescribeDBLogFiles.
Name | Type | Description |
---|---|---|
Mtime | Integer | Last modified time of log |
Length | Integer | File length |
Uri | String | Uniform resource identifier (URI) used during log download |
FileName | String | Filename |
Instance node information
Used by actions: DescribeDBInstanceDetail, DescribeInstanceNodeInfo.
Name | Type | Description |
---|---|---|
NodeId | String | Node ID |
Role | String | Node role. Valid values: master , slave |
Parameter constraint
Used by actions: DescribeDBParameters.
Name | Type | Description |
---|---|---|
Type | String | Constraint type, such as enum and section . |
Enum | String | List of valid values when constraint type is enum |
Range | ConstraintRange | Range when constraint type is section Note: This field may return null, indicating that no valid values can be obtained. |
String | String | List of valid values when constraint type is string |
Database parameter description
Used by actions: DescribeDBParameters.
Name | Type | Description |
---|---|---|
Param | String | Parameter name |
Value | String | Current parameter value |
SetValue | String | Previously set value, which is the same as value after the parameter takes effect.Note: This field may return null, indicating that no valid values can be obtained. |
Default | String | Default value |
Constraint | ParamConstraint | Parameter constraint |
HaveSetValue | Boolean | Whether a value has been set. false: no, true: yes |
NeedRestart | Boolean | Whether restart is required. false: no; true: yes. |
Parameter modification result
Used by actions: ModifyDBParameters.
Name | Type | Description |
---|---|---|
Param | String | Renames parameter |
Code | Integer | Result of parameter modification. 0: success; -1: failure; -2: invalid parameter value. |
Stored procedure permission information
Used by actions: ModifyAccountPrivileges.
Name | Type | Required | Description |
---|---|---|---|
Database | String | Yes | Database name |
Procedure | String | Yes | Stored procedure name |
Privileges | Array of String | Yes | Permission information |
Information of the reserved network resource
Used by actions: DescribeDBInstanceDetail.
Name | Type | Description |
---|---|---|
VpcId | String | VPC |
SubnetId | String | Subnet |
Vip | String | Reserved private network IP under VpcId and SubnetId |
Vports | Array of Integer | Port under Vip |
RecycleTime | String | Valid hours of VIP |
Tag object, including tag key and tag value
Used by actions: CreateDBInstance, CreateHourDBInstance, DescribeDBInstanceDetail, DescribeDBInstances.
Name | Type | Required | Description |
---|---|---|---|
TagKey | String | Yes | Tag key |
TagValue | String | Yes | Tag value |
Security group details
Used by actions: DescribeDBSecurityGroups, DescribeProjectSecurityGroups.
Name | Type | Description |
---|---|---|
ProjectId | Integer | Project ID |
CreateTime | String | Creation time in the format of yyyy-mm-dd hh:mm:ss |
SecurityGroupId | String | Security group ID |
SecurityGroupName | String | Security group name |
SecurityGroupRemark | String | Security group remarks |
Inbound | Array of SecurityGroupBound | Inbound rule |
Outbound | Array of SecurityGroupBound | Outbound rule |
Security group inbound/outbound rule
Used by actions: DescribeDBSecurityGroups, DescribeProjectSecurityGroups.
Name | Type | Description |
---|---|---|
Action | String | Policy, which can be ACCEPT or DROP |
CidrIp | String | Source IP or source IP range, such as 192.168.0.0/16 |
PortRange | String | Port |
IpProtocol | String | Network protocol. UDP and TCP are supported. |
Information of a slow query that has been logged
Used by actions: DescribeDBSlowLogs.
Name | Type | Description |
---|---|---|
CheckSum | String | Statement checksum for querying details |
Db | String | Database name |
FingerPrint | String | Abstracted SQL statement |
LockTimeAvg | String | Average lock time |
LockTimeMax | String | Maximum lock time |
LockTimeMin | String | Minimum lock time |
LockTimeSum | String | Total lock time |
QueryCount | String | Number of queries |
QueryTimeAvg | String | Average query time |
QueryTimeMax | String | Maximum query time |
QueryTimeMin | String | Minimum query time |
QueryTimeSum | String | Total query time |
RowsExaminedSum | String | Number of scanned rows |
RowsSentSum | String | Number of sent rows |
TsMax | String | Last execution time |
TsMin | String | First execution time |
User | String | Account |
ExampleSql | String | Sample SQL Note: This field may return null, indicating that no valid values can be obtained. |
Host | String | Host address of account |
Database column information
Used by actions: DescribeDatabaseTable.
Name | Type | Description |
---|---|---|
Col | String | Column name |
Type | String | Column type |
Table permission
Used by actions: ModifyAccountPrivileges.
Name | Type | Required | Description |
---|---|---|---|
Database | String | Yes | Database name |
Table | String | Yes | Table name |
Privileges | Array of String | Yes | Permission information |
Temp instance
Used by actions: DescribeDBTmpInstances.
Name | Type | Description |
---|---|---|
AppId | Integer | Application ID Note: This field may return null, indicating that no valid values can be obtained. |
CreateTime | Timestamp | Creation time Note: This field may return null, indicating that no valid values can be obtained. |
InstanceRemark | String | Instance remarks Note: This field may return null, indicating that no valid values can be obtained. |
TempType | Integer | Whether it is a temp instance. Valid values: 0 (non-temp instance), 1 (invalid temp instance), 2 (valid temp rollback instance).Note: This field may return null, indicating that no valid values can be obtained. |
Status | Integer | Instance status. Valid values: 0 (to be initialized), 1 (in process), 2 (running), -1 (isolated), -2 (eliminated).Note: This field may return null, indicating that no valid values can be obtained. |
InstanceId | String | Instance ID in the format of tdsql-ow728lmc Note: This field may return null, indicating that no valid values can be obtained. |
Vip | String | Virtual instance IP Note: This field may return null, indicating that no valid values can be obtained. |
Vport | Integer | Virtual instance port Note: This field may return null, indicating that no valid values can be obtained. |
PeriodEndTime | Timestamp | Validity end time Note: This field may return null, indicating that no valid values can be obtained. |
SrcInstanceId | String | Source instance ID in the format of tdsql-ow728lmc Note: This field may return null, indicating that no valid values can be obtained. |
StatusDesc | String | Instance status description Note: This field may return null, indicating that no valid values can be obtained. |
Region | String | Instance region Note: This field may return null, indicating that no valid values can be obtained. |
Zone | String | AZ of the instance Note: This field may return null, indicating that no valid values can be obtained. |
Vipv6 | String | Virtual IPv6 of the instance Note: This field may return null, indicating that no valid values can be obtained. |
Ipv6Flag | Integer | Instance IPv6 flag Note: This field may return null, indicating that no valid values can be obtained. |
View permission information
Used by actions: ModifyAccountPrivileges.
Name | Type | Required | Description |
---|---|---|---|
Database | String | Yes | Database name |
View | String | Yes | View name |
Privileges | Array of String | Yes | Permission information |
本页内容是否解决了您的问题?