Starting from December 8, 2021, TencentDB for MySQL has optimized parameter-related features and instance delivery process, including creating and applying parameter templates, comparing parameters, modifying modifiable parameters, and purchasing instances.
Note:
Parameter capabilities are applicable only to two-node and three-node TencentDB for MySQL 5.6, 5.7, and 8.0.
Instance Purchase Process Optimization
As compared with the original instance purchase process, the initialization step is canceled, and you can select the character set, configure the table name case sensitivity, and enter the databases access port and root password on the instance purchase page.
Certain parameters can be defined in a formula to change along with the specification, ensuring that the database always runs with the optimal configuration.
Expression syntax is supported as follows:
Supported Type
Description
Sample
Variable
DBinitMemory: Memory size of instance specification, which is an integer. For example, if the memory size of the instance specification is 4,000 MB, the value of DBinitMemory will be 4000.
DBInitCpu: Number of CPU cores of instance specification, which is an integer. Note that the value of the innodb_buffer_pool_size parameter in TencentDB for MySQL must be between 50% and 90% of the memory size. If the configured value is above 90% or below 50%, it will be automatically configured to 90% or 50% respectively.
Formula syntax: It should be enclosed in braces ({}).
Division operator (/): It divides the dividend by the divisor and returns an integer quotient. If the calculation result is a decimal number, only the integer part will be retained. Decimal numbers are not supported; for example, {MIN(DBInitMemory/4+500,1000000)} instead of {MIN(DBInitMemory\\*0.25+500,1000000)} is supported.
Multiplication operator (*): It multiplies two numbers and returns an integer product. If the calculation result is a decimal number, only the integer part will be retained. Decimal number calculation is not supported.
-
Function
MAX(): It returns the greatest value in an integer or parameter formula list.
MIN(): It returns the smallest value in an integer or parameter formula list.
For parameter template creation, the original one parameter template type is changed to two types (high-performance template and high-stability template), and the referenced template type option is added.
After the new parameter system is released, the original default parameter template will be replaced by the high-performance and high-stability parameter templates. Before then, you still can retain the default parameter template settings by creating a parameter template. For more information, see Managing Parameter Template.
Parameter comparison
The parameter comparison feature allows you to compare the parameters of different templates.
Click Compare on the parameter template page and select the templates to be compared in the pop-up window. Only templates for databases on the same version can be compared.
Contact Us
Contact us if you have any questions. Thank you for your support for Tencent Cloud. We will continue to provide you with more cost-effective products.
