Hi
Issuing the following command appears to be starting the MySQL server
with its default settings, instead of those under [mysqld6] in the
my.cnf file (there are no other my.cnf files):
./mysqld_multi --config-file=/work/mysql/my.cnf start 6
Can anyone give me any tips on how to debug/resolve this?
/work/mysql/my.cnf is defined as follows:
[mysqld_multi]
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
user = mysql
password = "******"
[mysqld6]
basedir=/usr/local/mysql
character-set-server=utf8
collation-server=utf8_general_ci
core-file
datadir=/work/mysql/jboss/data
skip-character-set-client-handshake
default-character-set=utf8
default-storage-engine=InnoDB
innodb
innodb_status_file
innodb_additional_mem_pool_size=1048576
innodb_autoextend_increment=8
innodb_buffer_pool_size=10485760
innodb_checksums
innodb_data_file_path=ibdata1:10M:autoextend
innodb_data_home_dir=/work/mysql/jboss/data
innodb_doublewrite
innodb_fast_shutdown=2
innodb_file_per_table
innodb_lock_wait_timeout=15
innodb_locks_unsafe_for_binlog=0
innodb_log_archive=0
innodb_log_buffer_size=1048576
innodb_log_file_size=4194304
innodb_log_files_in_group=3
innodb_log_group_home_dir=/work/mysql/jboss/logs
innodb_max_dirty_pages_pct=90
innodb_max_purge_lag=0
innodb_mirrored_log_groups=1
innodb_table_locks=1
innodb_thread_concurrency=8
innodb_thread_sleep_delay=10000
language=english
ledir=/usr/local/mysql/bin/mysqld
log-bin=/work/mysql/jboss/dump/audit.log
log-bin-index
log-error=/work/mysql/jboss/dump/diag.log
log-short-format
log-slow-queries=/work/mysql/jboss/dump/slow_sql.log
long-query-time=10
log-warnings
max-allowed-packet=8M
mysqld=/usr/local/mysql/bin/mysqld_safe
password="******"
pid-file=/work/mysql/jboss.pid
port=3400
safe-user-create
skip-bdb
sql-mode="PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,NO_ KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS"
temp-pool
transaction-isolation=REPEATABLE-READ
tmpdir=/work/mysql/jboss/temp
user=mysql
