Addressing high resource usage in servers with multiple machines

In servers with long uptime and multiple paired machines, we've found that certain tables in their database can grow quite large, requiring higher resource usage which may result in periodic instability at machines.

This behaviour is being optimised in an upcoming software release, v7.3, and in the meantime can be addressed below.

Since the tables machine_pings, machine_events, and server_events log only historical uptime records, we can truncate them to reduce the resources required by the database.

To do so, within your server copy and paste the following command which will make a database backup and delete entries from the aforementioned tables:

curl -sS https://raw.githubusercontent.com/naconner/lamascripts/master/patch/table-truncate.sh | bash

Afterwards, it will indicate that your server is started again.

Please note the number of records it states were deleted, and watch for changes to your machines' behaviour. Consider running this script again if a recurrence is seen.

We'll be announcing on our @LamassuSupport feed once the version is released which incorporates this patch.