On premise schools
      Back to home
      1. Help Articles
      2. Technicians
      3. On premise schools

      MySQL performance and optimisation Settings

      Your MySQL server may require some custom configuration settings to optimise its performance if you running an on-premise instance of XUNO. Follow the instructions below to customise your MySQL my.ini configuration file.

      Your my.ini should be located under C:\ProgramData\MySQL\MySQL Server 5.7\my.ini. If you can't find it, you can find the path under services.msc -> right click on the mysql process -> properties.

      The following configuration is based on client's feedback over the years and is just a suggestion. We recommend users modify these settings at their own discretion.

      1. Before changing my.ini, back up the original my.ini first.
      2. Open up my.ini as an administrator and update these settings:
        • key_buffer_size=16M (or up to 25% of RAM)
        • max_allowed_packet=512M
        • query_cache_type=1
        • query_cache_size=32M
        • query_cache_limit=1M
        • innodb_buffer_pool_size=128M (or up to 60% of RAM)
      3. Open up process list and restart the MySQL process.
      4. If MySQL fails to restart, revert my.ini, tweak the settings and try again.

      If you are still experiencing delays in XUNO's performance, give us a call on 1300 067 478 and we will investigate further on a Fee For Service basis.