MySQL Server Configuration

Configuring the mysql server is a very important part of using mysql, but it is generally the responsibly of the data base administrator (they do the mysql server configuration). Still there are some important configuration options that we should set or not set when we install mysql. As I said earlier that the mysql server is a command line program. More specifically it is a “daemon”. That’s what the little “d” at the end of its name mysqld stands for. The word daemon is Latin for servant. This is a typical designation given to programs that are design to run in the background so that they are ready to do our bidding the instant we need them. As with other background processes the mysql server is usually invoked automatically on startup. It then runs in the background listening for requests on its specific IP port or through a specific unix socket. We can also manually start or stop it if we have a need to do so. Background processes like these are not simply launched, but usually invoked with one or more command line options each of which could either be a switch or variable that requires a value. These options are used to cause the program to work in a specific way. Switching certain of its features on or off, or allocating more or less RAM to the process. The idea usually being to make that program work more efficiently for the workload we expected to handle. The process of setting up some means of specifying these options for each launch of the ”daemon” is called configuration. So you might ask, why is this boring part is important? We won’t usually want the mysql sever to just run, we want it to run in s specific way that we have determine that best for our needs. That means that our server must be launch with certain options switched on or given specific values. So we must configure our server.