MySQL Forums
Forum List  »  Quality Assurance

mysql restart problem when use mysql-5.1.56
Posted by: Qi Minghui
Date: September 12, 2012 12:46AM

hello everyone, i occur a prolem when i use mysql-5.1.56 ,my config file (my.cnf) is :
[client]
port = 3306
socket = /data/mysql/3306/mysql.sock
default-character-set=utf8
[mysql]
prompt="\\u@\\h:\\d \\r:\\m:\\s >"
[mysqld]
user = mysql
port = 3306
socket = /data/mysql/3306/mysql.sock
basedir = /usr/local/mysql-5.1.56
datadir = /data/mysql/3306/data
#global settings
character-set-server=utf8
#ignore_builtin_innodb
#plugin_load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so
#skip-name-resolve
skip-external-locking
back_log = 600
max_connections = 500
max_connect_errors = 10000
table_open_cache = 1024
table_definition_cache = 1024
max_allowed_packet = 32M
sort_buffer_size = 2M
join_buffer_size = 2M
thread_cache_size = 300
thread_concurrency = 8
thread_stack = 192K
concurrent_insert = 2
default-storage-engine = INNODB
transaction_isolation = REPEATABLE-READ
tmp_table_size = 16M
max_heap_table_size = 16M
read_buffer_size = 1M
read_rnd_buffer_size = 2M
interactive_timeout = 86400
wait_timeout = 86400
lower_case_table_names=1
# ****** MyISAM Engine options******
key_buffer_size = 1G
open_files_limit = 10240
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
myisam_recover
# ****** InnoDB Engine options******
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 3G
innodb_data_home_dir = /data/mysql/3306/data
innodb_log_group_home_dir = /data/mysql/3306/data
innodb_data_file_path = ibdata1:1024M:autoextend
innodb_flush_method = O_DIRECT
innodb_thread_concurrency = 0
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 16M
innodb_log_file_size = 256M
innodb_log_files_in_group = 2
innodb_max_dirty_pages_pct = 75
innodb_lock_wait_timeout = 60
innodb_file_per_table=1
# ****** master mysql db ******
server-id = 1
log-bin = /data/mysql/3306/logs/binlog/mysql-bin
log-error = /data/mysql/3306/logs/error.log
max-binlog-size = 512M
binlog_format = MIXED
expire_logs_days = 14
binlog_cache_size = 2M
log_bin_trust_function_creators =1
#replicate_wild_do_table= 3663.%
replicate_wild_ignore_table= mysql.%
replicate_wild_ignore_table= test.%
slave-skip-errors = all
#replay log information##
relay-log=/data/mysql/3306/logs/relaylog/relay-bin
relay-log-index=/data/mysql/3306/logs/relaylog/relay-log.index
relay-log-info-file=/data/mysql/3306/logs/relaylog/relay-log.info
#slowquery/binlog
slow_query_log = 1
long_query_time = 0.5
log-queries-not-using-indexes= true
slow_query_log_file = /data/mysql/3306/logs/slow.log

[mysqldump]
quick
max_allowed_packet = 32M
when i start mysql use mysqld_safe , the error log display normally except some warning :
[root@renyanfei logs]# tail error.log -n 50
120912 11:53:14 [Warning] 'db' entry 'cldk01\_mg\_gaogenxie\_dk cldk01@louboutinskostovlerdanmark.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'cldk01\_blog cldk01_blog@%.louboutinskostovlerdanmark.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'cldk01\_blog cldk01@%.louboutinskostovlerdanmark.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'cldk01\_mg\_gaogenxie\_dk cldk01_dk01@%.louboutinskostovlerdanmark.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'cldk01\_mg\_gaogenxie\_dk cldk01@%.louboutinskostovlerdanmark.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'cldk01\_% cldk01@%.louboutinskostovlerdanmark.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'cldk01\_% cldk01@louboutinskostovlerdanmark.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clde01\_% clde01@%.chrlouboutinschuhe.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clde01\_mg\_gaogenxie\_de clde01_de01@%.christianlouboutinschuhesale.net' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clde01\_mg\_gaogenxie\_de clde01@%.christianlouboutinschuhesale.net' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clde01\_blog clde01_blog@%.christianlouboutinschuhesale.net' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clde01\_blog clde01@%.christianlouboutinschuhesale.net' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clde01\_% clde01@%.christianlouboutinschuhesale.net' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clnl01\_% clnl01@%.toplouboutinschoenen.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clnl01\_mg\_gaogenxie\_nl clnl01@%.toplouboutinschoenen.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clnl01\_mg\_gaogenxie\_nl clnl01_nl01@%.toplouboutinschoenen.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clnl01\_blog clnl01_blog@%.toplouboutinschoenen.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clnl01\_blog clnl01@%.toplouboutinschoenen.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clnl01\_mg\_gaogenxie\_nl clnl01_nl01@%.christianlouboutinoutletnederland.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clnl01\_mg\_gaogenxie\_nl clnl01@%.christianlouboutinoutletnederland.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clnl01\_blog clnl01_blog@%.christianlouboutinoutletnederland.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clnl01\_blog clnl01@%.christianlouboutinoutletnederland.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clde01\_mg\_gaogenxie\_de clde01_de01@%.chrlouboutinschuhe.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clde01\_mg\_gaogenxie\_de clde01@%.chrlouboutinschuhe.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clde01\_blog clde01_blog@%.chrlouboutinschuhe.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clde01\_blog clde01@%.chrlouboutinschuhe.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clnl01\_% clnl01@%.christianlouboutinoutletnederland.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'cldk01\_hsblog cldk01@%.louboutinskostovlerdanmark.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'cldk01\_hsblog cldk01@louboutinskostovlerdanmark.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'cldk01\_hsblog cldk01_hsblog@%.louboutinskostovlerdanmark.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'cldk01\_hsblog cldk01_hsblog@louboutinskostovlerdanmark.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clnl02\_blog clnl02_blog@%.toplouboutinschoenen.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clnl02\_blog clnl02@%.toplouboutinschoenen.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clnl02\_mg\_gaogenxie\_nl02 clnl02_nl02@%.toplouboutinschoenen.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clnl02\_mg\_gaogenxie\_nl02 clnl02@%.toplouboutinschoenen.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clnl02\_mg\_gaogenxie\_nl clnl02@%.toplouboutinschoenen.com' ignored in --skip-name-resolve mode.
120912 11:53:14 [Warning] 'db' entry 'clnl02\_% clnl02@%.toplouboutinschoenen.com' ignored in --skip-name-resolve mode
and my terminal print this:
120912 11:53:03 mysqld_safe Starting mysqld daemon with databases from /data/mysql/3306/data
120912 11:53:04 mysqld_safe Number of processes running now: 0
120912 11:53:04 mysqld_safe mysqld restarted
120912 11:53:05 mysqld_safe Number of processes running now: 0
120912 11:53:05 mysqld_safe mysqld restarted
120912 11:53:07 mysqld_safe Number of processes running now: 0
120912 11:53:07 mysqld_safe mysqld restarted
120912 11:53:08 mysqld_safe Number of processes running now: 0
120912 11:53:08 mysqld_safe mysqld restarted
120912 11:53:09 mysqld_safe Number of processes running now: 0
120912 11:53:09 mysqld_safe mysqld restarted
120912 11:53:10 mysqld_safe Number of processes running now: 0
120912 11:53:10 mysqld_safe mysqld restarted
120912 11:53:11 mysqld_safe Number of processes running now: 0
120912 11:53:11 mysqld_safe mysqld restarted
120912 11:53:13 mysqld_safe Number of processes running now: 0

This indicate my database have some problem. Because this mysql is slave database, So i want to see relay log by this:
[root@renyanfei relaylog]# mysqlbinlog relay-bin.000001
mysqlbinlog: unknown variable 'default-character-set=utf8'
master and slave are all mysql-5.1.56 version . and master config file is :
root@server [~]# cat /etc/my.cnf
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
default-character-set=utf8
[mysql]
prompt="\\u@\\h:\\d \\r:\\m:\\s >"
[mysqld]
user = mysql
port = 3306
socket = /var/lib/mysql/mysql.sock
basedir = /usr/local/mysql-5.1.56
datadir = /home/mysql/3306/data
#global settings
character-set-server=utf8
#ignore_builtin_innodb
#plugin_load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so
skip-name-resolve
skip-external-locking
back_log = 600
max_connections = 500
max_connect_errors = 10000
table_open_cache = 1024
table_definition_cache = 1024
max_allowed_packet = 32M
sort_buffer_size = 2M
join_buffer_size = 2M
thread_cache_size = 300
thread_concurrency = 8
thread_stack = 192K
concurrent_insert = 2
default-storage-engine = INNODB
transaction_isolation = REPEATABLE-READ
tmp_table_size = 16M
max_heap_table_size = 16M
read_buffer_size = 1M
read_rnd_buffer_size = 2M
interactive_timeout = 86400
wait_timeout = 86400
lower_case_table_names=1
# ****** MyISAM Engine options******
key_buffer_size = 1G
open_files_limit = 10240
bulk_insert_buffer_size = 64M
myisam_sort_buffer_size = 128M
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1
myisam_recover
# ****** InnoDB Engine options******
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 3G
innodb_data_home_dir = /home/mysql/3306/data
innodb_log_group_home_dir = /home/mysql/3306/data
innodb_data_file_path = ibdata1:1024M:autoextend
innodb_flush_method = O_DIRECT
innodb_thread_concurrency = 0
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 16M
innodb_log_file_size = 256M
innodb_log_files_in_group = 2
innodb_max_dirty_pages_pct = 75
innodb_lock_wait_timeout = 60
innodb_file_per_table=1
# ****** master mysql db ******
server-id = 1
log-bin = /home/mysql/3306/logs/binlog/mysql-bin
log-error = /home/mysql/3306/logs/error.log
max-binlog-size = 512M
binlog_format = MIXED
expire_logs_days = 14
binlog_cache_size = 2M
log_bin_trust_function_creators =1
#replicate_wild_do_table= 3663.%
replicate_wild_ignore_table= mysql.%
replicate_wild_ignore_table= test.%
slave-skip-errors = all
#replay log information##
relay-log=/home/mysql/3306/logs/relaylog/relay-bin
relay-log-index=/home/mysql/3306/logs/relaylog/relay-log.index
relay-log-info-file=/home/mysql/3306/logs/relaylog/relay-log.info
#slowquery/binlog
slow_query_log = 1
long_query_time = 0.5
log-queries-not-using-indexes= true
slow_query_log_file = /home/mysql/3306/logs/slow.log
[mysqldump]
quick
max_allowed_packet = 32M
what shall i do ? please help me . thank you .

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql restart problem when use mysql-5.1.56
3356
September 12, 2012 12:46AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.