API ini digunakan untuk menanyakan detail log lambat suatu instance.
Deskripsi operasi
Mesin yang berlaku
RDS MySQL
RDS PostgreSQL
RDS SQL Server
RDS MariaDB
Catatan
Parameter respons API ini diperbarui sekali per menit.
Ada keterlambatan tertentu saat API ini dipanggil untuk menarik data. Mohon menunggu dengan sabar hingga hasil pemanggilan kembali.
Mulai 1 September 2024, karena optimisasi algoritma templating SQL, nilai field SQLHash akan berubah saat API ini dipanggil. Untuk detail, lihat [Pemberitahuan] Optimisasi algoritma templating SQL lambat.
Coba sekarang
Test
RAM authorization
Parameter permintaan
|
Parameter |
Type |
Required |
Description |
Example |
| DBInstanceId |
string |
Yes |
ID instance. Anda dapat memanggil operasi DescribeDBInstances untuk menanyakan ID instance. |
rm-uf6wjk5**** |
| SQLHASH |
string |
No |
Pengidentifikasi unik dari pernyataan SQL dalam statistik log lambat. Digunakan untuk memperoleh detail log lambat dari pernyataan SQL. |
U2FsdGVk**** |
| StartTime |
string |
Yes |
Awal rentang waktu yang akan ditanyakan. Waktu mulai tidak boleh lebih awal dari 30 hari sebelum waktu saat ini. Tentukan waktu dalam format yyyy-MM-ddTHH:mmZ. Waktu harus dalam UTC. |
2020-06-17T16:00Z |
| EndTime |
string |
Yes |
Akhir rentang waktu yang akan ditanyakan. Waktu akhir harus lebih lambat dari waktu mulai. Tentukan waktu dalam format yyyy-MM-ddTHH:mmZ. Waktu harus dalam UTC. |
2020-06-18T16:00Z |
| DBName |
string |
No |
Nama database. |
testdb |
| PageSize |
integer |
No |
Jumlah entri yang akan dikembalikan pada setiap halaman. Nilai yang valid: 30 hingga 100. Catatan
Nilai default: 30. |
30 |
| PageNumber |
integer |
No |
Nomor halaman. Nilai yang valid: bilangan bulat positif bukan nol yang tidak melebihi nilai maksimum dari tipe data Integer. Catatan
Nilai default: 1. |
1 |
| NodeId |
string |
No |
ID node. Penting Parameter ini hanya berlaku untuk instance yang menjalankan RDS Cluster Edition. Anda dapat menentukan node untuk menanyakan log node tersebut. Jika Anda tidak menentukan parameter ini, log dari node utama akan dikembalikan secara default. |
rn-p1fm78s90x5**** |
Elemen respons
|
Element |
Type |
Description |
Example |
|
object |
Detail parameter yang dikembalikan. |
||
| DBInstanceId |
string |
ID instance. |
rm-uf6wjk5**** |
| Engine |
string |
Mesin database. |
MySQL |
| Items |
object |
||
| SQLSlowRecord |
array<object> |
Daftar detail log lambat. |
|
|
object |
Detail entri log lambat. |
||
| ApplicationName |
string |
The name of the application that is connected to the instance. Catatan
This parameter is returned only for instances that run SQL Server. |
example |
| ClientHostName |
string |
The hostname of the client. Catatan
This parameter is returned only for instances that run SQL Server. |
example |
| CpuTime |
integer |
The duration during which the SQL statement is processed by the CPU. Unit: milliseconds. Catatan
This parameter is returned only for instances that run SQL Server. |
0.002 |
| DBName |
string |
The name of the database. |
testDB |
| ExecutionStartTime |
string |
The time when the execution of the SQL statement started. The time follows the ISO 8601 standard in the yyyy-MM-ddTHH:mm:ssZ format. The time is displayed in UTC. |
2020-06-18T01:40:44Z |
| HostAddress |
string |
The name and IP address of the client that is connected to the database. |
****[****] @ [1XX.XX.XX.XX] |
| LastRowsAffectedCount |
integer |
The number of rows that are affected by the last SQL statement. Catatan
This parameter is returned only for instances that run SQL Server. |
2 |
| LockTimes |
integer |
The lock duration of the query. Unit: seconds. |
0 |
| LogicalIORead |
integer |
The number of logical reads. Catatan
This parameter is returned only for instances that run SQL Server. |
383 |
| ParseRowCounts |
integer |
The number of parsed rows. |
1 |
| PhysicalIORead |
integer |
The number of physical reads. Catatan
This parameter is returned only for instances that run SQL Server. |
200 |
| QueryTimeMS |
integer |
The execution duration of the query. Unit: milliseconds. |
2001 |
| QueryTimes |
integer |
The execution duration of the query. Unit: seconds. |
2 |
| ReturnRowCounts |
integer |
The number of rows returned. |
1 |
| RowsAffectedCount |
integer |
The number of affected rows. Catatan
This parameter is returned only for instances that run SQL Server. |
34 |
| SQLHash |
string |
The unique ID of the SQL statement. |
U2FsdGVk**** |
| SQLText |
string |
The details of the SQL statement. |
select sleep(2) |
| UserName |
string |
The name of the user. Catatan
This parameter is returned only for instances that run SQL Server. |
user |
| WriteIOCount |
integer |
The number of I/O writes. Catatan
This parameter is returned only for instances that run SQL Server. |
22 |
| LockTimeMS |
integer |
2001 |
|
| PageNumber |
integer |
Nomor halaman. |
1 |
| PageRecordCount |
integer |
Jumlah pernyataan SQL pada halaman saat ini. |
1 |
| RequestId |
string |
ID permintaan. |
4DBB1BB0-E5D8-4D41-B1C9-142364DB**** |
| TotalRecordCount |
integer |
Jumlah total entri yang dikembalikan. |
1 |
Contoh
Respons sukses
JSONformat
{
"DBInstanceId": "rm-uf6wjk5****",
"Engine": "MySQL",
"Items": {
"SQLSlowRecord": [
{
"ApplicationName": "example",
"ClientHostName": "example",
"CpuTime": 0.002,
"DBName": "testDB",
"ExecutionStartTime": "2020-06-18T01:40:44Z",
"HostAddress": "****[****] @ [1XX.XX.XX.XX]",
"LastRowsAffectedCount": 2,
"LockTimes": 0,
"LogicalIORead": 383,
"ParseRowCounts": 1,
"PhysicalIORead": 200,
"QueryTimeMS": 2001,
"QueryTimes": 2,
"ReturnRowCounts": 1,
"RowsAffectedCount": 34,
"SQLHash": "U2FsdGVk****",
"SQLText": "select sleep(2)",
"UserName": "user",
"WriteIOCount": 22,
"LockTimeMS": 2001
}
]
},
"PageNumber": 1,
"PageRecordCount": 1,
"RequestId": "4DBB1BB0-E5D8-4D41-B1C9-142364DB****",
"TotalRecordCount": 1
}Kode kesalahan
|
HTTP status code |
Error code |
Error message |
Description |
|---|---|---|---|
| 400 | InvalidSearchTimeRange | search time range cannot be longer than a month. | |
| 400 | IO.Exception | IO exception, retry later. | |
| 400 | Order.ComboInstanceNotAllowOperate | A package instance is not allowed to operate independently. | |
| 400 | Price.PricingPlanResultNotFound | Pricing plan price result not found. | |
| 400 | Order.NoRealNameAuthentication | You have not passed the real-name authentication and do not meet the purchase conditions. Please log in to the user center for real-name authentication. | |
| 400 | InsufficientAvailableQuota | Your account quota limit is less than 0, please recharge before trying to purchase. | |
| 400 | CommodityServiceCalling.Exception | Failed to call commodity service. | |
| 400 | RegionDissolvedEOM | Dear customer, Alibaba Cloud plans to optimize and adjust the current region. Cloud services in this region will cease operations. You are currently unable to operate new purchase orders. Thank you for your understanding and support. | |
| 400 | Commodity.InvalidComponent | The module you purchased is not legal, please buy it again. | |
| 400 | RegionEndTimeDissolvedAustralia | Cloud services in the Australia (Sydney) region will be discontinued. Set the validity date to September 30, 2024 or earlier than September 30, 2024. | |
| 400 | Price.CommoditySys | Commodity system call exception. | |
| 400 | Pay.InsufficientBalance | Insufficient available balance. | |
| 400 | Order.PeriodInvalid | There is a problem with the period you selected, please choose again. | |
| 400 | pay.noCreditCard | Account not bound to credit card. | |
| 400 | Order.InstHasUnpaidOrder | There is an unpaid order for the service you have purchased. Please pay or void it before placing the order. | |
| 400 | noAvailablePaymentMethod | No payment method is specified for your account. We recommend that you add a payment method. | |
| 400 | BasicInfoUncompleted | Your information is incomplete. Complete your information before the operation. | |
| 400 | Risk.RiskControlRejection | Your account is abnormal, please contact customer service for details. | |
| 400 | Api.NotSupport | Specified api is not supported. | |
| 400 | ContainForbiddenLabelError | There is a label that prohibits placing orders. Please contact your distributor for assistance. | |
| 400 | InvalidDBInstanceId.NotFound | The DBInstanceId provided does not exist in records. | |
| 400 | InvalidInstanceLevel.DiskType | Specified instance level not support request disk type | |
| 400 | InvalidParam | Sepcified wal level Parameter is invalid. There are still logical slots in instance, so it can not be set as replica. | |
| 400 | KmsApiError | User secret key invalid. | |
| 400 | System.SaleValidateFailed | Sales expression validation system error. | |
| 400 | Abs.InvalidAccount.NotFound | account is not found. | |
| 400 | SqlExecuteFailedOrTimeout | sql command execution failed or timed out:%s. | |
| 400 | ColdData.EngineVersionNotSupport | The current instance engine version not support coldDataEnabled. | |
| 400 | ColdData.MinorVersionNotSupport | The current instance minor version not support coldDataEnabled. | |
| 400 | IncorrectTargetClasscode | The current instance type does not support this operation. | |
| 400 | InvalidConnectionString.Duplicate | Specified connection string already exists in the RDS. | |
| 400 | RequiredParam.NotFound | Required input param is not found. | |
| 400 | Parameters.Invalid | Parameter error, please check the parameters. | |
| 400 | BackupPolicyNotSupport | Cold Data won't open with CrossBackup or Flash Backup, please check Backup Policy. | |
| 400 | InvalideStatus.Format | The instance status does not support this operation. | |
| 400 | InvalidReleasedKeepPolicy.Format | Specified Released Keep Policy is not valid. | |
| 400 | InvalidDBInstanceEngineType.Format | the DB instance engine type does not support this operation. | |
| 400 | Pay.NoCreditCard | No credit cards. | |
| 400 | VpcNetworkTypeNotSupport | The vpc network type instance does not support this operation. | |
| 400 | MirrorInsExists | Specified DB instance mirror ins already existed. | |
| 400 | UnsupportedClassCode | The specified DB instance class stops selling. | |
| 400 | InvalidBackupSet | The specified database does not exist in the backup set. | |
| 400 | OrdTCommodityQueryError | Failed to query for product. | |
| 400 | ProductInstanceReleased | The instance has been released. Please check before placing the order. | |
| 400 | RegionEndTimeDissolvedIndia | The region is no longer supported. | |
| 500 | ExternalFailure | The request processing has failed due to external service failure. | |
| 500 | RequestMetaDataFailed | The service request failed. Please try again later or contact service personnel. | |
| 500 | InvokeProxyFailure | The request processing has failed due to service failure of rds api. | |
| 403 | OrderStatus.UnPaid | The specified db instance has unpaid order. | |
| 403 | InvalidReduceDiskSize | The storage capacity after the scale-down must be larger than the used amount. | |
| 403 | CloudSSDNotSupport | Cloud ssd does not support this operation, please upgrade to essd. | |
| 403 | InvalidUserOperatorPermission | The user permission does not support this operation. | |
| 403 | InvalidVswitchId | Specified conn vswitch id is not valid. | |
| 403 | IncorrectMinorVersion | Current engine minor version does not support operations. | |
| 403 | OperationDenied.ZoneResource | There is no available zone for inventory. | |
| 403 | NotInFlowController | Sorry,no permission. | |
| 403 | InvalidKmsKey | Kms key is disabled. | |
| 403 | InvalidInstanceLevel.Malformed | Current DB instance level does not support this operation. | |
| 404 | InvalidClusterKms | The current instance does not authorized to access the Key Management Service. | |
| 404 | Request.NotFound | The requested resource is not available. | |
| 404 | HostInfo.NotFound | The specified host info is not found. | |
| 408 | RequestTimeout | Query timed out.Please try again or narrow down the query scope. |
Lihat Error Codes untuk daftar lengkap.
Catatan rilis
Lihat Release Notes untuk daftar lengkap.