检测到您已登录华为云国际站账号,为了您更好的体验,建议您访问国际站服务网站 https://www.huaweicloud.com/intl/zh-cn
不再显示此消息
Supported SQL statements include SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, and DROP. Reporting Slow Logs to LTS After this function is enabled, logs record all requests sent to your instance and are stored in LTS.
To add read replicas to or delete read replicas from a yearly/monthly DB instance, submit a service ticket. The read replicas that are automatically added or deleted will be billed based on a pay-per-use basis.
You cannot execute this statement to delete only some DEFAULT partitions.
Under Real-Time Monitoring, view real-time monitoring data such as CPU usage, memory usage, SELECT statements per second, DELETE statements per second, and INSERT statements per second. You can also click View details to view more metrics on the Cloud Eye console.
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
Enabling binlog does not affect SELECT operations, but affects INSERT, UPDATE, DELETE and other write operations. There are no significant differences between TaurusDB binlog and open-source MySQL binlog.
Constraints You cannot reboot or delete the HTAP instance while its storage space is being changed. You can change storage space of an HTAP instance multiple times. You can change storage space of BE and FE nodes separately or simultaneously.
Monitoring by Seconds supports the following metrics: CPU usage, memory usage, SELECT statements per second, DELETE statements per second, and INSERT statements per second. You can click View details to view more metrics. For details about the metrics, see TaurusDB Metrics.
If the retention period is longer than or equal to the validity period, you can delete the cold data remaining in OBS after migration.
* TO 'xx'@'%'; FLUSH PRIVILEGES; Impact of Enabling Binlog on TaurusDB Performance Enabling binlog does not affect SELECT operations, but affects INSERT, UPDATE, DELETE and other write operations.
If you want to delete a serverless read replica, see Deleting a Read Replica. Parent Topic: Serverless Instances
Constraints You cannot reboot or delete the HTAP instance while its specifications are being changed. You can change the specifications of your HTAP instance for an unlimited number of times. You can change the specifications of an abnormal HTAP instance.
code: 200 Success. { "keep_days" : 7, "audit_types" : [ "CREATE", "ALTER" ], "all_audit_log_action" : "{\"DCL\":\"CREATE_USER,DROP_USER,RENAME_USER,GRANT,REVOKE,ALTER_USER,ALTER_USER_DEFAULT_ROLE\",\"DDL\":\"CREATE,ALTER,DROP,RENAME,TRUNCATE,REPAIR,OPTIMIZE\",\"DML\":\"INSERT,DELETE
After memory acceleration is enabled, commands such as RESET MASTER and FLUSH LOGS used to delete binlogs on TaurusDB instances are not allowed. A Redis key prefix and a delimiter in a new rule can neither include those nor be included in those specified for an existing rule.
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. Backing Up and Restoring Data Instances with cold and hot data separation enabled only support full data restoration.
Manual backups will not be automatically deleted but you can delete them manually. NOTE: To extend the retention period to up to 3,660 days, submit a service ticket. Time Zone The backup time is in UTC format.
Statements per Second Number of DELETE statements executed per second ≥ 0 Counts/s N/A TaurusDB instance nodes 1 minute 5 seconds 1 second gaussdb_mysql029_comdml_ins_count INSERT Statements per Second Number of INSERT statements executed per second ≥ 0 Counts/s N/A TaurusDB instance
Values: ALL INSERT UPDATE SELECT DELETE CREATE DROP ALTER node_id Yes String Node ID. Request Parameters Table 3 Request header parameters Parameter Mandatory Type Description X-Auth-Token No String User token. X-Language No String Language.
Values: ALL INSERT UPDATE SELECT DELETE CREATE DROP ALTER Request None Response Normal response Table 2 Parameter description Name Type Description slow _log_list Array of objects Slow log information.
If the storage space of a DB instance is being changed, you cannot reboot or delete the DB instance.