Overview
When you resize a server to increase or decrease the amount of memory or CPU that is available to PhixFlow, you must update some configuration settings to efficiently use the available resources.
Memory Changes
Consider how Tomcat and the PhixFlow database make use of memory.
Tomcat
After making changes to memory settings, remember to run systemctl daemon-reload
; see Managing Tomcat.
Windows
- Open Tomcat properties;
- Update Initial Memory Pool and Maximum Memory Pool to the new settings.
- Restart Tomcat
Linux
- Update the settings in /etc/systemd/system/tomcat.service.
- Change CATALINA_OPTS to the memory settings you need
- Restart Tomcat.
Tor details about stopping and starting Tomcat, see Managing Tomcat.
Database
MariaDB
Remember to udpate any settings in MariaDB that are depedent on the avaiable memory. There are many settings that can be tuned, but in particular a key setting is innodb_buffer_pool_size. This page https://phixflow.atlassian.net/wiki/spaces/HELPTRUNKR/pages/8632172571 gives further details, and in particular, a rule-of-thumb rule for determining a new innodb_buffer_pool_size.
To update innodb_buffer_pool_size, edit the file /etc/mysql/my.cnf and update the setting:
innodb_buffer_pool_size = 2G
Restart the MySQL service:
sudo systemctl stop mysql
sudo systemctl start mysql
SQL Server
It is not necessary to update the memory settings in SQL Server after resizing the server unless you have set a fixed maximum memory in the database; this is not recommended by Microsoft. See https://phixflow.atlassian.net/wiki/spaces/HELPTRUNKR/pages/8640856105 for further details.
This does not elimiate the need to perform more in depth monitoring and tuning over time, but if are following Microsoft’s recommended approach, when you change the memory on the server, SQL Server will automatically adapt.
CPU
If you increase or decrease the available CPU, remember to udpate the thread pool size in PhixFlow. Unless advised otherwise by PhixFlow Support or your PhixFlow implementation team, set this to 2x logical (virtual) CPUs. You update this setting in PhixFlow’s https://phixflow.atlassian.net/wiki/spaces/HELPTRUNKR/pages/97734594.