Bug #14154 can't start mysqld
Submitted: 19 Oct 2005 21:52 Modified: 17 Nov 2005 21:45
Reporter: Pierre-Henry Perret Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:323 OS:FreeBSD (FreeBSD 5.2.1-RELEASE)
Assigned to: MySQL Verification Team CPU Architecture:Any

[19 Oct 2005 21:52] Pierre-Henry Perret
051019 21:33:50  mysqld started
/usr/local/libexec/mysqld: unrecognized option `--key_buffer=256M'
/usr/local/libexec/mysqld  Ver 3.23.58 for portbld-freebsd5.2.1 on i386
Copyright (C) 2000 MySQL AB, by Monty and others
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Starts the MySQL server

Usage: /usr/local/libexec/mysqld [OPTIONS]

system locking is not in use

Possible variables for option --set-variable (-O) are:
back_log              current value: 50
bdb_cache_size        current value: 8388600
bdb_log_buffer_size   current value: 0
bdb_max_lock          current value: 10000
bdb_lock_max          current value: 10000
binlog_cache_size     current value: 32768
connect_timeout       current value: 5
delayed_insert_timeout  current value: 300
delayed_insert_limit  current value: 100
delayed_queue_size    current value: 1000
flush_time            current value: 0
innodb_mirrored_log_groups  current value: 1
innodb_log_files_in_group  current value: 2
innodb_log_file_size  current value: 5242880
innodb_log_buffer_size  current value: 1048576
innodb_buffer_pool_size  current value: 8388608
innodb_additional_mem_pool_size  current value: 1048576
innodb_file_io_threads  current value: 4
innodb_lock_wait_timeout  current value: 50
innodb_thread_concurrency  current value: 8
innodb_force_recovery  current value: 0
interactive_timeout   current value: 28800
join_buffer_size      current value: 131072
key_buffer_size       current value: 8388600
long_query_time       current value: 10
lower_case_table_names  current value: 0
max_allowed_packet    current value: 1048576
max_binlog_cache_size  current value: 4294967295
max_binlog_size       current value: 1073741824
max_connections       current value: 100
max_connect_errors    current value: 10
max_delayed_threads   current value: 20
max_heap_table_size   current value: 16777216
max_join_size         current value: 4294967295
max_sort_length       current value: 1024
max_tmp_tables        current value: 32
max_user_connections  current value: 0
max_write_lock_count  current value: 4294967295
myisam_max_extra_sort_file_size  current value: 256
myisam_max_sort_file_size  current value: 2047
myisam_sort_buffer_size  current value: 8388608
net_buffer_length     current value: 16384
net_retry_count       current value: 1000000
net_read_timeout      current value: 30
net_write_timeout     current value: 60
open_files_limit      current value: 0
query_buffer_size     current value: 0
record_buffer         current value: 131072
record_rnd_buffer     current value: 0
slave_net_timeout     current value: 3600
slow_launch_time      current value: 2
sort_buffer           current value: 2097144
table_cache           current value: 64
thread_concurrency    current value: 10
thread_cache_size     current value: 0
tmp_table_size        current value: 33554432
thread_stack          current value: 65536
wait_timeout          current value: 28800
051019 21:33:50  mysqld ended

How to repeat:

Suggested fix:
[19 Oct 2005 23:05] MySQL Verification Team
Looks to me you have on your my.cnf a wrong key for:

set-variable   = key_buffer=16M

see below how I repeated the behavior reported:

miguel@hegel:~/dbs/3.0> libexec/mysqld --defaults-file=/home/miguel/dbs/3.0/var/my.cnf 
libexec/mysqld: unrecognized option `--key_buffer=16M'
libexec/mysqld  Ver 3.23.59-debug for suse-linux on i686
Copyright (C) 2000 MySQL AB, by Monty and others

# The MySQL server
port            = 3306
socket          = /tmp/mysql.sock
#set-variable   = key_buffer=16M

Changing key_buffer=16M by set-variable   = key_buffer=16M
the start issue is fixed:

miguel@hegel:~/dbs/3.0> libexec/mysqld --defaults-file=/home/miguel/dbs/3.0/var/my.cnf 
051019 21:00:54  InnoDB: Started
libexec/mysqld: ready for connections
[19 Oct 2005 23:46] Pierre-Henry Perret
Yes it works, but I must comment out the followings in my.cnf file
this is the installation my.cnf file !
set-variable = key_buffer = 256M
set-variable = max_allowed_packet = 1M
set-variable = table_cache = 256
#set-variable = sort_buffer_size = 1M
#set-variable = read_buffer_size = 1M
set-variable = myisam_sort_buffer_size = 64M
#thread_cache = 8
#query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
#thread_concurrency = 8

so why ?
[20 Oct 2005 18:13] MySQL Verification Team
Which package did you installed. I just downloaded the Linux one
and the my.cnf samples not contains those variables.
[20 Oct 2005 19:06] Pierre-Henry Perret
The freebsd package mysql323-server
[16 Nov 2005 17:41] MySQL Verification Team
Could you please point me the link where you got that package
and the location of the my.cnf file you used into that package.
I was unable to find!

[16 Nov 2005 21:47] Pierre-Henry Perret
In fact, I just try to install the following port on freeBSD:

The port configuration points to the files on the FreeBSD server so you can find the ports there.
[16 Nov 2005 22:07] MySQL Verification Team
If I understood well you that my.cnf file isn't from our package and
belongs to server 4.0.XX.
[17 Nov 2005 21:45] Pierre-Henry Perret
Yes, you're right!