Skip to main content

Modifying MySQL configuration

in Database
Authors list
Published: Jun 30, 2023|Last updated: Apr 16, 2024

It is possible to edit the configuration of the internal MySQL service on the OPC server so that you may optimize it to your use case.

Note

Changing your configuration will result in the MySQL service being restarted. During this time, any instance using this database service will be unavailable.

  1. Navigate to the internal database (localhost:3306) in the navigation menu:

    database menu item
  2. Click the "Edit" button a the bottom of the page:

    edit database button
  3. Enter the configuration settings you wish to apply in the text box and click "Save Changes":

    update mysqld config
Warning

If you specify an invalid configuration, this may cause MySQL and/or your helpdesk to stop responding.

If you experience any issues after applying these modifications, we recommend removing any modifications you have made and saving again to restart the MySQL service.

  1. The progress screen will confirm that changes have been applied:

    update database progress
  2. You can then view the updated settings on the database information page:

    updated settings
HelpfulUnhelpful
next pageEncrypting MySQL

Please log in or register to submit a comment.