Mastering MariaDB

System logs

If mysqld_safe is invoked with the --syslog option, the errors are also logged in the system log (syslog). This feature works only if the system has the logger program, which is usually present on Linux systems, and in such cases, the daemon facility is used. By default, each syslog entry has a mysqld or mysqld_safe tag, depending on the program that generated its entry. If multiple instances of MariaDB (or MySQL) are running on the same system, it is advisable to add a different suffix for each instance to find out which particular instance logged a particular error. To do this, you can start mysqld_safe with the --syslog-tag option, as shown in the following example:

mysqld_safe --syslog --syslog-tag=serv1

In this case, the errors ...