检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
DSC will delete the keyword during migration. Input 1 2 3 4 5 6 7 8 9 10 11 12 CREATE TABLE `public`.
Deleting a Data Source Function This API is used to delete a data source. Call Method For details, see Calling APIs.
Deleting Tags in Batches Function This API is used to batch delete tags from a specified cluster. Call Method For details, see Calling APIs.
Deleting a Node Function This API is used to delete a node. Call Method For details, see Calling APIs.
GAUSS-50209: "Failed to delete the %s directory." SQLSTATE: None Description: Failed to delete the file. Solution: Check and modify the user permissions on this directory. GAUSS-50210: "The %s must be a file."
Click Delete in the Operation column of a report to delete the report record and file. Configuring Workload Report Parameters Log in to the GaussDB(DWS) console. Choose Dedicated Clusters > Clusters and locate the cluster whose load needs to be analyzed.
If there are a large number of UPDATE and DELETE operations, select the User tables. If there are a large number of CREATE and DELETE operations, select System catalogs. Click Next: Configure Schedule to configure the schedule and Vacuum type.
ALGORITHM=INSTANT: Users can add columns instantly and delete columns instantly anywhere in a table, and evaluate row size limits when adding a column. This is not supported by GaussDB(DWS) and is deleted by DSC during the migration.
Solution: Delete the CHECK constraint. GAUSS-01222: "cannot copy to view '%s'" SQLSTATE: 42809 Description: Failed to use COPY to copy data to a view. Solution: Do not use COPY to copy data to a view.
TRUNCATE (Table Deletion) In MySQL, the TABLE keyword can be omitted when the TRUNCATE statement is used to delete table data. GaussDB(DWS) does not support this usage. In addition, DSC will add CONTINUE IDENTITY RESTRICT to the TRUNCATE statement for migration.
Deleting a Subscribed Event Function This API is used to delete a subscribed event. Call Method For details, see Calling APIs. URI DELETE /v2/{project_id}/event-subs/{event_sub_id} Table 1 URI parameters Parameter Mandatory Type Description project_id Yes String Project ID.
Deleting an Alarm Subscription Function This API is used to delete a subscribed alarm. Call Method For details, see Calling APIs. URI DELETE /v2/{project_id}/alarm-subs/{alarm_sub_id} Table 1 URI parameters Parameter Mandatory Type Description project_id Yes String Project ID.
DROP (Table Deletion) Both GaussDB(DWS) and MySQL support using the DROP statement to delete tables. However, GaussDB(DWS) does not support the RESTRICT | CASCADE keyword in the DROP statement. DSC will delete the keywords during migration.
After you delete data stored in GaussDB(DWS) data warehouses, dirty data may be generated possibly because the disk space is not released. This results in disk space waste and deteriorates snapshot creation and restoration performance.
SQL Self-Diagnosis Performance problems may occur when you run the INSERT/UPDATE/DELETE/SELECT/MERGE INTO or CREATE TABLE AS statement. The product supports automatic performance diagnosis and saves related diagnosis information to the Real-time Top SQL.
SQL Self-Diagnosis Performance issues may occur when you run the INSERT/UPDATE/DELETE/SELECT/MERGE INTO or CREATE TABLE AS statement. The product supports automatic performance diagnosis and saves related diagnosis information to Real-time Top SQL.
SQL Self-Diagnosis Performance issues may occur when you run the INSERT/UPDATE/DELETE/SELECT/MERGE INTO or CREATE TABLE AS statement. The product supports automatic performance diagnosis and saves related diagnosis information to Real-time Top SQL.
However, you can add, delete, or modify rules of the current security group. To edit the cluster security group: Log in to the GaussDB(DWS) management console. In the navigation pane on the left, click Clusters.
GAUSS-02721 -- GAUSS-02730 GAUSS-02725: "partition %u deleted while still in use" SQLSTATE: XX000 Description: The SQL statement failed to be scheduled. Solution: The partition in use cannot be deleted. Modify the scheduling statement. GAUSS-02726: "partition %u is still open" SQLSTATE
After a GaussDB(DWS) cluster is created, you can add, delete, or modify rules in its current security group. Modify an existing security group rule: Log in to the GaussDB(DWS) management console. Choose Dedicated Clusters > Clusters in the navigation pane.
