Logbestanden (MySQL)
Naar navigatie springen
Naar zoeken springen
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
MySQL kent verscheidene logbestanden. Bijbehorende zijn geconfigureerd in /etc/mysql/my.cnf:
# * Logging and Replication # # Both location gets rotated by the cronjob. # Be aware that this log type is a performance killer. # As of 5.1 you can enable the log at runtime! #general_log_file = /var/log/mysql/mysql.log #general_log = 1 # # Error log - should be very few entries. # log_error = /var/log/mysql/error.log # # Here you can see queries with especially long duration #log_slow_queries = /var/log/mysql/mysql-slow.log #long_query_time = 2 #log-queries-not-using-indexes # # The following can be used as easy to replay backup logs or for replication. # note: if you are setting up a replication slave, see README.Debian about # other settings you may need to change. #server-id = 1 #log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M #binlog_do_db = include_database_name #binlog_ignore_db = include_database_name
Nadere specificaties omtrent error_log, staan in /etc/mysql/conf.d/mysqld_safe_syslog.cnf. De inhoud van dat bestand:
[mysqld_safe] syslog
En dit geeft aan dat logregels naar het systeemlog worden geschreven.
In ieder geval één keer heb ik meegemaakt dat error log-entries wel degelijk naar het bestand werden geschreven dat gespecificeerd stond in my.cnf: /var/log/mysql/error.log.