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:
# 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;