Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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

  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 need
  3. 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.

  • No labels