tencent cloud

Feedback

Setting Instance Parameters

Last updated: 2022-06-07 15:08:00

    You can view and modify certain parameters and query parameter modification logs in the TDSQL-C for MySQL console.

    Notes

    • To ensure instance stability, only some parameters can be modified in the console. These parameters are displayed on the Parameter Settings page.
    • If the modified parameter requires instance restart to take effect, the system will ask you if you wish to restart. We recommend that you do so during off-peak hours and ensure that your application has a reconnection mechanism.
    • Currently, you cannot enter a custom formula to set a parameter.
    • If you want to return to the default formula, clear the entered parameters and apply.

    Modifying Parameters in Parameter List

    Modifying parameters in batches

    1. Log in to the TDSQL-C for MySQL console and click a cluster ID in the cluster list to enter the cluster management page.
    2. On the cluster management page, select the Parameter Settings tab and click Modify Parameters.
    3. Locate the target parameters and modify their values in the Current Value column. After confirming that everything is correct, click OK.
    4. In the pop-up window, confirm that everything is correct and click OK.

    Modifying one parameter

    1. Log in to the TDSQL-C for MySQL console and click a cluster ID in the cluster list to enter the cluster management page.
    2. On the Parameter Settings tab, locate the target parameter in the parameter list and click in the Current Value column.
    3. Modify the value within the restrictions stated in the Acceptable Values column and click to save the modification. You can click to cancel the operation.
    4. In the pop-up window, confirm that everything is correct and click OK.

    Modifying Parameters by Importing Parameter Template

    1. Log in to the TDSQL-C for MySQL console and click a cluster ID in the cluster list to enter the cluster management page.
    2. On the cluster management page, select the Parameter Settings tab and click Import from Template.
    3. In the pop-up window, select a parameter template and click OK.
    4. After confirming that everything is correct, click OK in the top-left corner.
    5. In the pop-up window, confirm that everything is correct and click OK.

    Modifying Parameters by Importing Parameter Configuration File

    1. Log in to the TDSQL-C for MySQL console and click a cluster ID in the cluster list to enter the cluster management page.
    2. On the cluster management page, select the Parameter Settings tab and click Import Parameters.
    3. In the pop-up window, select a file to upload and click Import and Overwrite Original Parameters.
    4. After confirming that everything is correct, click OK in the top-left corner.
    5. In the pop-up window, confirm that everything is correct and click OK.

    Exporting Parameter Configuration as File

    1. Log in to the TDSQL-C for MySQL console and click a cluster ID in the cluster list to enter the cluster management page.
    2. On the cluster management page, select the Parameter Settings tab and click Export Parameters to export the parameter configuration file.

    Exporting Parameter Configuration as Template

    1. Log in to the TDSQL-C for MySQL console and click a cluster ID in the cluster list to enter the cluster management page.
    2. On the cluster management page, select the Parameter Settings tab and click Save as Template to save the existing parameter configuration as a parameter template.

    Subsequent Operations

    Contact Us

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

    Technical Support

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

    7x24 Phone Support