[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