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.
- Before changing my.ini, back up the original my.ini first.
- 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)
- Open up process list and restart the MySQL process.
- 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.