Package: mysql-common
Version: 5.1.49-3
Severity: minor

mysql-5.1-5.1.49/sql-common/client.c contains (amongst others):

|        case 27:
|          if (opt_arg)
|            options->max_allowed_packet= atoi(opt_arg);
|          break;

This allows max_allow_packet to be specified as found in the attached file,
but ONLY as a plain integer and NOT in the common notation eg. "100M" used
elsewhere in my.cnf (which is parsed via mysys/my_getopt.c).

This difference in parsing can create quite an amount of confusion and
should therefore clearly be stated (at least) in the configuration
template.

-- System Information:
Debian Release: 6.0.2
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'oldstable'), (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.28.7 (SMP w/2 CPU cores)
Locale: LANG=de_AT.UTF-8, LC_CTYPE=de_AT.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

-- Configuration Files:
/etc/mysql/my.cnf changed:
[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock
max_allowed_packet      = 104857600
[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0
[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
skip-external-locking
bind-address            = 0.0.0.0
key_buffer              = 16M
max_allowed_packet      = 1024M
thread_stack            = 192K
thread_cache_size       = 8
myisam-recover          = BACKUP
query_cache_limit       = 1M
query_cache_size        = 16M
general_log_file        = /var/log/mysql/mysql.log
general_log             = 0
log-error               = /var/log/mysql/mysql.err
slow_query_log  = /var/log/mysql/mysql-slow.log
long_query_time = 2
expire_logs_days        = 10
max_binlog_size         = 2G
innodb_file_per_table
ft_min_word_len=2
[myisamchk]
ft_min_word_len=2
[mysqldump]
quick
quote-names
max_allowed_packet      = 1024M
[mysql]
[isamchk]
key_buffer              = 16M
!includedir /etc/mysql/conf.d/


-- no debconf information



-- 
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]

Reply via email to