> ## Documentation Index
> Fetch the complete documentation index at: https://docs.oriv.cloud/llms.txt
> Use this file to discover all available pages before exploring further.

# How to Change MySQL Max Connection via ORIV?

> Change MySQL max connection limit to optimize your ORIV server’s performance. Follow our step-by-step guide to increase connections & handle heavy 

[**ORIV**](https://oriv.cloud/) lets you optimize your server’s performance and handle increased traffic by adjusting the max connection parameter in the **[MySQL](https://dev.mysql.com/doc/refman/8.4/en/option-files.html)** configuration file.

## **Steps to Change MySQL Max Connection via ORIV**

We will be using the command line to change MySQL Max Connection. Follow the steps below to increase the maximum connections MySQL allows on your ORIV server using the terminal.

### **Step 1: Access MySQL Configuration File**

Open the command terminal and run this command to edit MySQL config file:\
**sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf**

> \[!NOTE]
> Precisa de ajuda visual para esta etapa? Entre em contato com o nosso suporte em **[support@oriv.cloud](mailto:support@oriv.cloud)**.

### **Step 2: Modify Max Connection Parameter**

In the MySQL configuration file in the nano text editor add these two lines at the end of the file as shown below if not exist (Values are based on preference):

**max\_allowed\_packet = 64M**

**max\_connections = 200**

> \[!NOTE]
> Precisa de ajuda visual para esta etapa? Entre em contato com o nosso suporte em **[support@oriv.cloud](mailto:support@oriv.cloud)**.

### **Step 3: Restart MySQL**

Restart MySQL by running this: **sudo systemctl restart mysql** to ensure that the MySQL server is operating correctly with the new max\_connection value.

> \[!NOTE]
> Precisa de ajuda visual para esta etapa? Entre em contato com o nosso suporte em **[support@oriv.cloud](mailto:support@oriv.cloud)**.

Following the steps you will have successfully increased the maximum connections allowed by MySQL on your ORIV server. This adjustment can significantly enhance your server’s performance and capacity to handle demanding workloads.

> \[!NOTE]
> Precisa de ajuda visual para esta etapa? Entre em contato com o nosso suporte em **[support@oriv.cloud](mailto:support@oriv.cloud)**.

This is how you can easily change MySQL max connection via ORIV.

Still stuck! Contact our [**support team**](https://support.oriv.cloud/) for assistance in detail with your queries.