![]() Ubuntu packages for example has the log going to syslog. ![]() With Linux distributions you may not find log files where you expect. I discount this because you have to connect to the server to retrieve logs, create a sub directory of that hostname for consolidated logs. The argument is what about when consolidating logs from multiple servers. I would rather the filename to be consistent across multiple servers. There does not seem to be a consensus over whether to include the hostname or not in the error log filename. An example I implement for single installation environments using Linux mysql packages is: mkdir /var/log/mysql I would recommend you create a separate directory for MySQL logs such as the error, slow and general logs. I am referring here to more then just the error log. Second, the datadir is for data, not logs, especially logs that can potentially fill file systems. Other users/groups should have limited access to the mysql error log. This is not an ideal location for 2 reasons.įirst, a correctly configured MySQL datadir will have permissions only for the mysql user, and this is generally restrictive access to the user only and no group or world permissions. There are a few different options available for defining the details of the log. It is important that you monitor the MySQL error log.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |