42 results found for " delete ".
-
SQL Usage Details - GaussDB(for MySQL)
From: Help > GaussDB(for MySQL) > User Guide > Usage Specifications and Suggestions > Database Usage Detailsresources than DELETE. If the table to be deleted does not have a trigger and the entire table needs to be deleted, TRUNCATE TABLE is recommended. TRUNCATE TABLE does not write deleted data to log files. A TRUNCATE TABLE statement has the same function as a DELETE statement without
-
Rebuilding a Deleted Instance from Recycle Bin - GaussDB(for MySQL)
submit a service ticket by choosing Service Tickets > Create Service Ticket in the upper right corner of the management console. You can only delete available or abnormal instances, and if the recycle bin is enabled, the deleted instances will be retained for 1 day before being permanently
-
Security White Paper - GaussDB(for MySQL)
backups are user-initiated full backups of DB instances. They are stored in OBS buckets. When you delete a DB instance, the manual backups will be retained unless you manually delete them. You can restore data to new instances from existing backups. Data Replication You can deploy
-
Introducing Read Replicas - GaussDB(for MySQL)
to 15 read replicas. Read replicas do not support restoration from backups. Data cannot be migrated to read replicas. You cannot create or delete databases on read replicas. You can only create accounts on the primary node. Parent topic: Read Replicas
-
Test Method - GaussDB(for MySQL)
--mysql-db=sbtest --table_size=25000 --tables=250 --events=0 --time=600 --threads=<thread_num> --percentile=95 --report-interval=1 oltp_write_only run Delete data. sysbench --db-driver=mysql --mysql-host=<host> --mysql-port=<port> --mysql-user=<user> --mysql-password=<password> --mysql-db=sbtest
-
How Do I Enable and View Binlog of My GaussDB(for MySQL) Instance? - GaussDB(for MySQL)
Impact of Enabling Binlog on GaussDB(for MySQL) Performance Enabling binlog does not affect SELECT operations, but affects INSERT, UPDATE, DELETE and other write operations. There are no significant differences between GaussDB(for MySQL) binlog and open-source MySQL binlog. The binlog
-
Configuring Security Group Rules - GaussDB(for MySQL)
From: Help > GaussDB(for MySQL) > Getting Started > Connecting to an Instance > Connecting to an Instance over a Public Networkto 255 characters and cannot contain angle brackets (<>). - 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: Connecting to an Instance over a Public Network
-
Configuring Security Group Rules - GaussDB(for MySQL)
From: Help > GaussDB(for MySQL) > Getting Started > Connecting to an Instance > Connecting to an Instance over a Private Networkto 255 characters and cannot contain angle brackets (<>). - 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: Connecting to an Instance over a Private Network
-
Working with Backups - GaussDB(for MySQL)
Setting a Cross-Region Backup Policy. Manual Backups Manual backups are user-initiated full backups of instances. They are retained until you delete them manually. Full Backups Full backups are used to back up all data even if no data is updated since the last backup. Incremental Backups
-
Creating a GaussDB(for MySQL) Custom Policy - GaussDB(for MySQL)
policy: { "Version": "1.1", "Statement": [ { "Effect": "Deny" "Action": [ "gaussdb:instance:delete" ], } ] } Example 3: Defining permissions for multiple services in a policy A custom policy can contain the actions
-
Scaling up Storage for a Yearly/Monthly Instance - GaussDB(for MySQL)
Constraints Only the storage space of yearly/monthly instances can be scaled up. Instances can be scaled up numerous times. You cannot reboot or delete an instance that is being scaled up. Storage space can only be scaled up, not down. Procedure Log in to the management console. Click in
-
Viewing Slow Query Logs - GaussDB(for MySQL)
statements that are executing slowly and optimize the statements. GaussDB(for MySQL) supports the following statement types: SELECT INSERT UPDATE DELETE CREATE ALTER DROP Parameter Description Table 1 Parameters related to MySQL slow queries Parameter Description long_query_time Specifies
-
Viewing Instance Monitoring Metrics - GaussDB(for MySQL)
choose Advanced O&M. 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. Parent
-
Managing Tags - GaussDB(for MySQL)
left, click GaussDB(for MySQL). On the Instances page, click the instance name. On the Tags page, locate the tag to be deleted and click Delete in the Operation column. In the displayed dialog box, click Yes. View that the tag is no longer displayed on the Tags page.
-
Configuring Monitoring by Seconds - GaussDB(for MySQL)
seconds View monitoring metrics. 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 More to view more metrics. For details about the metrics, see
-
GaussDB(for MySQL) Monitoring Metrics - GaussDB(for MySQL)
≥0 Tables Monitored object: ECS Monitored instance type: GaussDB(for MySQL) instance gaussdb_mysql028_comdml_del_count DELETE Statements per Second Number of DELETE statements executed per second ≥0 Statements/s Monitored object: ECS Monitored instance type: GaussDB(for MySQL) instance
-
Querying Database Slow Logs - GaussDB(for MySQL)
Statement type. The default value All. If this parameter is left empty, all statement types are queried. Valid value: 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
-
Introducing to GaussDB(for MySQL) Metrics - GaussDB(for MySQL)
GaussDB(for MySQL) statements are executed ≥0 counts GaussDB(for MySQL) instances 1 minute gaussdb_mysql028_comdml_del_count DELETE Statements per Second Number of DELETE statements executed per second ≥0 counts/s GaussDB(for MySQL) instances 1 minute 5 seconds 1 second gaussdb_mysql029_comdml_ins_count
-
Querying Database Slow Logs - GaussDB(for MySQL)
Statement type. The default value All. If this parameter is left empty, all statement types are queried. Valid value: 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
-
Making an API Request - GaussDB(for MySQL)
coded in UTF-8. The request body varies between APIs. Some APIs do not require the request body, such as the APIs requested using the GET and DELETE methods. In the case of the API used to obtain a user token, the request parameters and parameter description can be obtained from the API