tencent cloud

All product documents
TencentDB for MariaDB
DocumentationTencentDB for MariaDBFAQsFeatures
Features
Download PDF
Last updated: 2024-01-11 15:21:58
Features
Last updated: 2024-01-11 15:21:58
Download PDF

How do I restart a TencentDB for MariaDB instance?

You can restart a TencentDB for MariaDB instance in the console, which, however, is not recommended.

Do I need to configure read/write separation on the program?

Read/write separation of database is not configured automatically. You need to first create a read-only account in the console, and modify the program configuration.

How do I effectively delete large amounts of data from a TencentDB for MariaDB instance?

The deletion method is similar to batch insertion. You are recommended to delete small amounts of data (e.g., 10,000 entries) at a time and repeat the operation multiple times.

What if the database parameter to be modified cannot be found in parameter configuration options or some parameters cannot be modified?

The TencentDB for MariaDB console supports most common database parameters and sets security thresholds for them. If a parameter to be modified does not exist or cannot be modified to a specific value, please submit a ticket for assistance and we will process it as soon as possible.

How do I use mysqldump to import data to a TencentDB for MariaDB instance?

mysqldump is easy to use but requires long downtime, so it is only suitable for small amounts of data or situations that allows relatively long downtime. For more information, please see Importing Data with mysqldump.

What are the functional limitations of TencentDB for MariaDB?

You cannot change any data in the mysql, information_schema, performance_schema, or sysdb database.
You cannot use SQL statements to set accounts or grant permissions, which can only be done in the console. The following 19 common permissions are supported, and only few rarely used permissions are not supported:
SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER
CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW
CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER, SHOW DATABASES
The super admin account is not supported.
The InnoDB storage engine is used, while other engines are unavailable currently.

How do I roll back a TencentDB for MariaDB instance?

TencentDB for MariaDB can roll back data to any time point in the last 30 days based on the retention of backups and logs. With the database rollback feature, system loss can be minimized. For more information, please see Rolling back Databases.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 available.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon