MariaDB: Set Maximum Server Connections via Query

If you’re a MariaDB user and need to set the max_connections variable a little higher while the server is running, you can use the following SQL query:

~

If you’re a MariaDB user and need to set the max_connections variable a little higher while the server is running, you can use the following SQL query:

# This will give you the current mac_connections setting
select @@max_connections;

# Set the maximum connections allow for MariaDB
set global max_connections = 200;

# To see that the variable has been changed, run the following query again:  
select @@max_connections;

~

Comments