My server is telling my that binary logging is disabled. When I do a mysqladmin variables
, I see this: log_bin | OFF
. This is my configuration file:
[mysqld]
# These are some standard (Plesk) options needed:
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
user = mysql
old_passwords = 1
# Some general options:
default_storage_engine = MyISAM
# We want to make sure eventual data loss is handled correctly:
myisam_recover = FORCE,BACKUP
# Some security things, to avoid overloading:
max_allowed_packet = 16M
max_connect_errors = 1000000
# The important stuff, caching and performance tweaks:
max_connections = 100
key_buffer_size = 50M
read_buffer_size = 2M
sort_buffer_size = 5M
myisam_use_mmap = 1
tmp_table_size = 16M
max_heap_table_size = 16M
query_cache_type = 1
query_cache_size = 64M
thread_cache_size = 25
open_files_limit = 65535
table_definition_cache = 1024
table_open_cache = 1024
# Although InnoDB is not used, some default optimization options:
innodb_buffer_pool_size = 32M
innodb_data_file_path = ibdata1:10M:autoextend
innodb_flush_log_at_trx_commit = 2
# And finally some logging:
log_error = /var/lib/mysql/mysql-error.log
log_queries_not_using_indexes = 0
slow_query_log = 1
slow_query_log_file = /var/lib/mysql/mysql-slow.log
# Master
log-bin=/var/lib/mysql/mysql-bin
server-id = 1
innodb_flush_log_at_trx_commit=1
sync_binlog=1
So, I did mysqladmin shutdown
and then a service mysqld start
and after that mysqladmin variables
. But it says log-bin | OFF
? What am I doing wrong?
We are using MySQL 5.5.18-ccl by the way.
Make sure mysql is the owner of /var/lib/mysql as follows:
Another thing to check for is the presence of another my.cnf
Try the following
If a my.cnf file is there, you have found your culprit. Just rename the file
and then
service mysql restart
Specify:
Cheers