Enable Write-Ahead Logging

Required User Role: Root user

Note: This topic assumes a basic understanding of Linux.

You can use the convertDatabaseMode.php script to enable write-ahead logging (WAL) journaling mode for Tenable Security Center databases. Enabling WAL may resolve issues with excessive database locks. If your Tenable Security Center does not experience database locking issues, Tenable recommends leaving your Tenable Security Center databases in the default DELETE journaling mode.

For more information, see Tenable Security Center Database Journaling Modes.

Before you begin:

  • Confirm your Tenable Security Center installation meets the requirements to enable WAL. For more information, see WAL Requirements.

  • Perform a backup of Tenable Security Center, as described in Perform a Backup.

To enable WAL:

  1. Log in to Tenable Security Center via the command line interface (CLI).

  2. Stop Tenable Security Center, as described in Start, Stop, or Restart Tenable Security Center.

  3. In the CLI in Tenable Security Center, run the following command to start the converDatabaseMode.php script:

    /opt/sc/support/bin/php /opt/sc/src/tools/convertDatabaseMode.php -m WAL

    The script runs.

  4. If the script detects any running tns user processes, repeat the following steps for each tns user process detected:

    1. Follow the prompts in the error output to halt the tns user process.

      Example error output:

      Error! The Tenable Security Center process with PID '10135' is still running and needs to be halted before this script can be executed successfully.

         Command: /opt/sc/support/bin/php -f /opt/sc/daemons/Jobd.php

      Bailing with 146.

    2. Run the following command to restart the converDatabaseMode.php script:

      /opt/sc/support/bin/php /opt/sc/src/tools/convertDatabaseMode.php -m WAL

      The script restarts.

    Tenable Security Center converts supported databases to WAL journaling mode. For more information, see Databases Affected.

  5. Start Tenable Security Center, as described in Start, Stop, or Restart Tenable Security Center.

What to do next:

  • Perform regular backups of Tenable Security Center, as described in Perform a Backup.