주 콘텐츠로 건너뛰기

Modifying MySQL configuration

Database에서
저자 리스트
발표됨: 2023년 6월 30일|최종 업데이트됨: 2024년 4월 16일

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
도움이 되었습니다도움이 되지 않음
다음 페이지Encrypting MySQL

댓글을 작성하려면 로그인하거나 등록하셔야 합니다.