How long does it take to create a TencentDB for MySQL instance?
Typically, creating a TencentDB for MySQL instance takes less than 10 minutes. The creation time for a read-only instance depends on the data volume of the primary instance; the larger the data volume, the longer the creation time. If it takes longer than expected, there may be an issue with the creation process. Please contact us promptly.
How do I return a database?
You can log in to the TencentDB for MySQL console and select More > Terminate/Return or Terminate/Return & Refund in the Operation column in the instance list to return an instance. For more information, see Terminating Instance.
What happens if a TencentDB for MySQL instance is terminated?
After an instance is returned, it will be retained in the recycle bin for seven days (in monthly subscription billing mode) or one day (in pay-as-you-go billing mode). During the retention period, it can be restored from the recycle bin.
What should I do if I accidentally deleted an account or forgot the password?
If you accidentally deleted an account, you can log in to the TencentDB for MySQL console, click an instance ID to enter the instance management page, and select Database Management > Account Management > Create Account or use SQL statements to create a new account. For more information, see Create Account.
If you forget the root password, you can go to Database Management > Account Management page to find the corresponding account and perform the Reset Password operation. For more information, see Resetting Password.
The above operations can also be performed using the Cloud API.
What is the maximum number of connections to TencentDB for MySQL? How do I modify it?
You can view the maximum number of connections to TencentDB for MySQL in the console. If the number of connections gets too high, we recommend that you locate the cause and solve the problem first instead of directly increasing the maximum value.
You can log in to the TencentDB for MySQL console, click an instance ID to enter the instance management page, select Database Management > Parameter Settings, and modify the
max_connections parameter.Why is the value of max_connections always displayed as 1,000 rather than the actual number of current maximum connections in MySQL instance monitoring?
max_connections represents the allowed maximum number of connections (1–100,000) in instance monitoring. Open Connections indicates the number of connections at the current moment, a value that changes in real time.How can I get to know that the disk capacity is insufficient?
The monitoring center oversees the disk capacity of a TencentDB instance. When the disk utilization is over 90%, SMS and email alarms will be triggered. You can configure alarm recipients in Tencent Cloud Observability Platform (TCOP) to receive such alarms. For directions, see Alarm Policies (TCOP).
How do I modify the case sensitivity of table name after a TencentDB for MySQL instance is initialized?
You need to adjust the
lower_case_table_names parameter of the database.
Log in to the TencentDB for MySQL console, click the instance ID to enter the instance management page, select Database Management > Parameter Settings, and modify the lower_case_table_names parameter (0: Case-sensitive; 1: Case-insensitive).