Setting Instance Parameters

Last updated: 2020-11-13 16:42:41

    You can view and modify certain parameters and query parameter modification logs in TencentDB for MySQL Console.

    Notes

    • To ensure instance stability, only some parameters can be modified in the console. These parameters are displayed in 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.

    Modifying Parameters in the Parameter List

    Modifying parameters in batches

    1. Log in to the MySQL Console. In the instance list, click the instance ID/name or Manage in the "Operation" column to access the instance management page.
    2. Select Database Management > Parameter Settings and click Batch modify parameters.
    3. Locate the desired parameters, and modify their values in the "Current Value" column. After confirming that everything is correct, click Confirm Modification.
    4. In the pop-up dialog box, select the "Execution Mode" and click OK.

      Note:

      • If you select Immediate execution, the parameter modification task will be executed and take effect immediately.
      • If you select During maintenance window, the parameter modification task will be executed and take effect during the instance maintenance period.

    Modifying a single parameter

    1. Log in to the MySQL Console. In the instance list, click the instance ID/name or Manage in the "Operation" column to access the instance management page.
    2. Select Database Management > Parameter Settings. In the parameter list, locate the desired parameter 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 dialog box, select the "Execution Mode" and click OK.

      Note:

      • If you select Immediate execution, the parameter modification task will be executed and take effect immediately.
      • If you select During maintenance window, the parameter modification task will be executed and take effect during the instance maintenance period.

    Modifying Parameters by Importing a Parameter Template

    Method 1. Importing a parameter template on the "Parameter Settings" page

    1. Log in to the MySQL Console. In the instance list, click the instance ID/name or Manage in the "Operation" column to access the instance management page.
    2. Select Database Management > Parameter Settings and click Import from Templates.
    3. In the pop-up dialog box, select a parameter template and click Import and Overwrite Original Parameters.
    4. After confirming that everything is correct, click Confirm Modification.
    5. In the pop-up dialog box, select the "Execution Mode" and click OK.

      Note:

      • If you select Immediate execution, the parameter modification task will be executed and take effect immediately.
      • If you select During maintenance window, the parameter modification task will be executed and take effect during the instance maintenance period.

    Method 2. Importing a parameter template on the "Parameter Templates" page

    For more information, please see Managing Parameter Template > Applying a Parameter Template to a Database.

    Modifying Parameters by Importing a Parameter Configuration File

    1. Log in to the MySQL Console. In the instance list, click the instance ID/name or Manage in the "Operation" column to access the instance management page.
    2. Select Database Management > Parameter Settings and click Import Parameters.
    3. In the pop-up dialog box, select a file to upload and click Import and Overwrite Original Parameters.
    4. After confirming that everything is correct, click Confirm Modification.
    5. In the pop-up dialog box, select the "Execution Mode" and click OK.

      Note:

      • If you select Immediate execution, the parameter modification task will be executed and take effect immediately.
      • If you select During maintenance window, the parameter modification task will be executed and take effect during the instance maintenance period.

    Exporting Parameter Configuration as a File

    1. Log in to the MySQL Console. In the instance list, click the instance ID/name or Manage in the "Operation" column to access the instance management page.
    2. Select Database Management > Parameter Settings and click Export Parameters.

    Exporting Parameter Configuration as a Template

    1. Log in to the MySQL Console. In the instance list, click the instance ID/name or Manage in the "Operation" column to access the instance management page.
    2. Select Database Management > Parameter Settings and click Save as Template.

    Modifying Parameters during a Custom Time Window

    Before you confirm the parameter modification, the "Modify Parameters" dialog box will pop up for you to select a custom time window for the modification to take effect.

    Note:

    If you select During maintenance window as the effective time, the parameter modification task will be executed and take effect during the instance maintenance period.

    Canceling a Parameter Modification Task

    If a parameter modification or batch modification task has been submitted but you want to cancel it, you can select Task List in the left sidebar in the console, locate the task, and click Cancel in the "Operation" column. You can cancel a task only before it is executed. The task state should be "Waiting for execution".

    Viewing Parameter Modification Logs

    1. Log in to the MySQL Console. In the instance list, click the instance ID/name or Manage in the "Operation" column to access the instance management page.
    2. Select Database Management > Parameter Settings and click Recent modifications.
    3. You can view the recent parameter modification records here.

    Subsequent Operations

    Was this page helpful?

    Was this page helpful?

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