Recently, my VPS which hosted a bunch of WordPress sites gave an error message: Too many connections. I mean all available connections have been used by the various clients and my MySQL server can not serve any new connections until any of the existing connections is closed.

How Many Connections Can MySQL handle?

The default, MariaDB 10.3.34 can handle up to 151 connections. The number is stored in a server variable called max_connections.

How to Increase Max Connection in MySQL?

Check the default max connections

The main command  is:

show variables like "max_connections";

The output is 151.

Increase Max Connections in settings

The file keeps the setting of max_connections is located /etc/mysql/mariadb.conf.d/  the file name is 50-server.cnf

cd /etc/mysql/mariadb.conf.d

sudo nano 50-server.cnf

Find the line of max_connections , remove the comment characters or just just add the following in to the end of the file, save it.

max_connections = 200

Restart MySQL server

sudo service mariadb restart

Then, try to check the max connections variable by the previous way mentioned above, the result is 200.

David Yin

David is a blogger, geek, web developer. Founder of FreeInOutBoard.com. He check David Yin's Blog everyday. If you like his post, you can say thank you here

Leave a Reply

Your email address will not be published. Required fields are marked *