[debian-mysql] Bug#540527: [mysql-common] default my.cnf contains invalid log options (thankfully commented) log_type and general_log
Filipus Klutiero
chealer at gmail.com
Sat Aug 8 16:13:06 UTC 2009
Package: mysql-common
Version: 5.1.37-1
Severity: normal
The new my.cnf for 5.1 contains the following:
# * 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!
#log_type = FILE
#general_log = /var/log/mysql/mysql.log
#
# Error logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
#
# 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
If one uncomments the log_type or general_log lines, mysql will fail to start, as these are invalid config file options:
Aug 8 17:49:41 vinci mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Aug 8 17:49:41 vinci mysqld: 090808 17:49:41 [Warning] option 'thread_stack': unsigned value 128 adjusted to 131072
Aug 8 17:49:41 vinci mysqld: 090808 17:49:41 [Note] Plugin 'FEDERATED' is disabled.
Aug 8 17:49:42 vinci mysqld: 090808 17:49:42 InnoDB: Started; log sequence number 0 269050
Aug 8 17:49:42 vinci mysqld: 090808 17:49:42 [ERROR] /usr/sbin/mysqld: unknown variable 'log_type=FILE'
Aug 8 17:49:42 vinci mysqld: 090808 17:49:42 [ERROR] Aborting
Aug 8 17:49:42 vinci mysqld:
Aug 8 17:49:42 vinci mysqld: 090808 17:49:42 InnoDB: Starting shutdown...
Aug 8 17:49:43 vinci mysqld: 090808 17:49:43 InnoDB: Shutdown completed; log sequence number 0 269050
Aug 8 17:49:43 vinci mysqld: 090808 17:49:43 [Warning] Forcing shutdown of 1 plugins
Aug 8 17:49:43 vinci mysqld: 090808 17:49:43 [Note] /usr/sbin/mysqld: Shutdown complete
I don't know what log_type should be. What you may want is this:
general_log_file = /var/log/mysql/mysql.log
general-log=1
--- System information. ---
Architecture: i386
Kernel: Linux 2.6.30-1-amd64
Debian Release: squeeze/sid
990 testing security.debian.org
990 testing ftp.ca.debian.org
500 unstable ftp.ca.debian.org
1 experimental debian.savoirfairelinux.net
--- Package information. ---
Package's Depends field is empty.
Package's Recommends field is empty.
Package's Suggests field is empty.
More information about the pkg-mysql-maint
mailing list