Skip to main content

Tutorial: Adjusting Authentication and Database Connection Settings

Abstract

This tutorial will adjust the authentication and database threads for handling active Access Server connections.

Overview

This tutorial will guide you through increasing the maximum number of authentication and database threads in Access Server to handle high-load scenarios more efficiently.

Prerequisites

  • An installed Access Server.

  • Console access with root privileges.

Step 1: Set the maximum database connection QueuePool size

  1. Connect to the console with root privileges.

  3. Increase the maximum number of database connections with this command:

    ./sacli --key "mysql.max_overflow" --value "25" configput
service openvpnas restart

    • This command sets the QueuePool size to 25. Adjust the number as needed. The default is 10.

    • Ensure to restart the service to apply this change.

Step 2: Set the maximum parallel authentication threads

  • Increase the number of authentication threads with this command:

    ./sacli --key "auth.module.max_parallel" --value "25" configput
./sacli start

    • This command sets the number of parallel authentication threads to 25. Adjust the number as needed. The default is 8.

    • Restart the server to apply the changes.

By following these steps, you can effectively manage and optimize the performance of your Access Server under high-load scenarios or with slower authentication systems.

In this section: