Setting Instance Parameters

Last updated: 2020-05-15 16:37:21

    You can view and modify certain parameters in the TencentDB for MySQL Console or through API and query parameter modification logs in the console.

    Modifying Parameter Value

    • If the modified parameter requires instance restart for it to take effect, the system will ask you whether to restart. You are recommended to do so during off-peak hours and ensure that your application has a reconnection mechanism.
    • Before the parameter modification is submitted, you can click next to the parameter or Cancel on the modification page to cancel the modification.

    Modifying parameters in batches

    1. Log in to the TencentDB for MySQL Console. In the instance list, click an instance name or Manage in the "Operation" column to enter the instance management page.
    2. Select Database Management > Parameter Settings and click Batch modify parameters.
    3. In the "Current Value" column, select the parameters to be modified. After confirming that everything is correct, click Confirm Modification.
    4. In the pop-up dialog box, indicate your consent and click OK.

    Modifying a single parameter

    1. Log in to the TencentDB for MySQL Console. In the instance list, click an instance name or Manage in the "Operation" column to enter the instance management page.
    2. Select Database Management > Parameter Settings, select the row of the target parameter, and click in the "Current Value" column to modify the parameter value.
    3. Enter the target parameter value as prompted in the "Acceptable Values" column and click to save the change. You can click to cancel the operation.
    4. In the pop-up dialog box, click OK.

    Importing from parameter template

    1. Log in to the TencentDB for MySQL Console. In the instance list, click an instance name or Manage in the "Operation" column to enter the instance management page.
    2. Select Database Management > Parameter Settings and click Import from Templates.
    3. In the pop-up dialog box, select the parameter template and click Import and Overwrite Original Parameters.

    Importing parameters

    1. Log in to the TencentDB for MySQL Console. In the instance list, click an instance name or Manage in the "Operation" column to enter the instance management page.
    2. Select Database Management > Parameter Settings and click Import Parameters.
    3. In the pop-up dialog box, select the file for upload, and click Import and Overwrite Original Parameters.

    Viewing Parameter Modification Record

    1. Log in to the TencentDB for MySQL Console. In the instance list, click an instance name or Manage in the "Operation" column to enter the instance management page.
    2. Select Database Management > Parameter Settings and click Recent modifications.
    3. On the record of recent modifications page, you can view the recent parameter modification records.

    Was this page helpful?

    Was this page helpful?

    • Not at all
    • Not very helpful
    • Somewhat helpful
    • Very helpful
    • Extremely helpful
    Send Feedback
    Help