Tip of the Day — max_connections
This is a little simpler, but iti s good to cover this system variable for the administrators who are just starting out. In your my.cnf (or my.ini on Windows) file you need to specify the maximum number of connections (clients) that are allowed to connect to your MySQL server at one time. You will want to set it at a reasonable level for your system load. Don’t over-inflate as it does use an (admittedly fairly small) amount of memory.
As an example, if you want to allow a maximum of 400 connections to your server the following would be in your [mysqld] section:
max_connections = 400
1 Comment so far
Leave a reply
Don’t forget as I did yesterday, that in practice the maximum number of connections is actually max_connections +1. As the server reserves one to allow users with the super privilege to log in. So for the example its 400 regular user login + 1 super. Yet, another reason why its bad practice to have an app connect with full privileges.