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

Windows

1. Open Tomcat properties;
2. Update Initial Memory Pool and Maximum Memory Pool to the new settings.
3. Restart Tomcat

Linux

1. Update the settings in /etc/systemd/system/tomcat.service.
2. Change CATALINA_OPTS to the memory settings you needRestart .
3. Run systemctl daemon-reload and 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 When you make changes to the available memory, update the affected MariaDB settings, especially  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

1. Edit the file /etc/mysql/my.cnf and update the setting:
      innodb_buffer_pool_size

1. =

1. 2G
See MariaDB Planning for a rule-of-thumb rule for determining a new buffer pool size.


2. Restart the MySQL service:
     sudo

1. systemctl

1. stop

1. mysql

1. 
     sudo

1. systemctl

1. start

1. mysql

SQL Server

It is not necessary to update Microsoft recommend that no fixed maximum memory is set on the database; see MS SQL Server Planning. In this case you do not need to update the memory settings in for the SQL Server when 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 adaptchanging the available memory. The SQL server should automatically adapt.

CPU

If you increase or decrease change the available CPU, remember to udpate update the thread pool size in PhixFlow. Unless advised otherwise by PhixFlow Support or your PhixFlow implementation team, set this to 2x 2 times the logical (virtual) CPUs. You update this setting in PhixFlow’s https://phixflow.atlassian.net/wiki/spaces/HELPTRUNKR/pages/97734594 System Configuration.