---
title: 'Tutorial: Adjusting Authentication and Database Connection Settings'
canonical: https://openvpn.net/as-docs/tutorials/tutorial--authentication-and-db-connection-settings/
product: Access Server Docs
description: This tutorial will adjust the authentication and database threads for handling active Access Server connections.
---

# Tutorial: Adjusting Authentication and Database Connection Settings

## 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 and the ability to get root access.

## Step 1: Set the maximum database connection QueuePool size

1. Connect to the console and get root privileges.
2. Switch to the scripts directory:

   ```
   cd /usr/local/openvpn_as/scripts/
   ```
3. Increase the maximum number of database connections with this command:

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

   - 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

1. 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.

---

Prev: [Tutorial: Changing the XML-RPC Function Support](https://openvpn.net/as-docs/tutorials/tutorial--xml-rpc-interface.md)
Next: [Tutorial: Adjusting the Maximum Number of VPN Tunnels](https://openvpn.net/as-docs/tutorials/tutorial--change-maximum-vpn-tunnels.md)
Index: https://openvpn.net/as-docs/llms.txt