检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
检测到您已登录华为云国际站账号，为了您更好的体验，建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Queries per second (QPS) indicates the number of SQL statements, including INSERT, SELECT, UPDATE, and DELETE statements, executed per second.
To avoid unnecessary fees, if you do not want to continue using HTAP of Standard Edition, unsubscribe from or delete standard HTAP instances on the TaurusDB console before Jan 6, 2025, 00:00 GMT+08:00. Click here for more information about HTAP instances.
After migrating a cold table back, you must manually delete the cold data on the console after the automated backup retention period expires to avoid ongoing billing for the cold data.
If you directly delete the frozen DB instance, its automated backups will also be deleted and the backup space will not be charged any longer. Parent Topic: Backups
Length Due to the Index Length Limit Slow SQL Queries After a Large Amount of Data Is Deleted from a Large Table Error 1366 Reported When Data Containing Emojis Is Updated Slow Stored Procedure Execution Due to Inconsistent Collations ERROR [1412] Reported for a DB Instance Failed to Delete
If a MySQL table contains a foreign key and has a foreign key relationship, the error message "ERROR 1451 (23000): Cannot delete or update parent row: a foreign key constraint fails" will be displayed when you attempt to delete the table.
URI DELETE /v3/{project_id}/instances/{instance_id}/nodes/{node_id}/processes Table 1 URI parameters Parameter Mandatory Type Description project_id Yes String Definition: Project ID of a tenant in a region. To obtain this value, see Obtaining a Project ID.
To delete a selected database, locate the database and click × in the Operation column. Figure 1 Changing permissions On the Accounts page, check that the authorized databases and permissions of the account have been changed.
In the displayed dialog box, enter DELETE as prompted and click OK. Figure 1 Unsubscribing from an HTAP instance On the page for unsubscribing from resources, confirm the refund information and click Confirm.
Manual full backups You can manually delete manual backups. For details, see Deleting a Manual Backup. Parent Topic: Backups
To delete binlog files manually, connect to the database and run flush logs; to forcibly generate a new binlog file. Parent Topic: Log Management
To avoid incurring service fees, if you do not want to continue using serverless DB instances, delete them on the console before Jan 19, 2024, 00:00 GMT+08:00.
You cannot create or delete databases on read replicas. You cannot create database accounts for read replicas. There may be a latency between the read replicas and the primary node. The latency of the full-text index is significant due to its special mechanism.
In the displayed dialog box, enter DELETE in the text box and click OK. Figure 2 Removing a standby instance from RegionlessDB To view the detailed progress and result of the task, go to the Task Center page. Parent Topic: RegionlessDB Clusters (OBT)
You can modify the condition on the service side and delete the function. When the returned result set is small, the service side filters the rows that meet the condition.
Attempting to delete, rename, or change passwords or permissions for these accounts will result in an error.
delete, delete_multi UPDATE update, update_multi REPLACE replace, replace_select SELECT select Table 5 DCL types and operations Type Operation CREATE_USER create_user DROP_USER drop_user RENAME_USER rename_user GRANT grant_roles, grant REVOKE revoke, revoke_all, revoke_roles ALTER_USER
- Operation You can replicate or delete a security group rule. However, if there is only one security group rule, you cannot delete it. - Parent Topic: Connection Information Management
Delete unnecessary indexes. Insert multiple data records in batches. This is because batch insertion only requires a single remote request to the database.
Execute the ANALYZE TABLE statement periodically to prevent incorrect execution plans because performing a large number of INSERT or DELETE operations for table data may result in outdated statistics. Parent Topic: Database Performance
