【已解决】mysql启动错误：ERROR! Manager of pid-file quit without updating fi

biyexp

/etc/init.d/mysql start
Starting MySQL. ERROR! Manager of pid-file quit without updating file.

错误日志是：
121017 11:39:41 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
121017 11:39:41 [Warning] 'record_buffer' is deprecated and will be removed in a future release. Please use 'read_buffer_size' instead.
121017 11:39:41 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
121017 11:39:41 [ERROR] /usr/local/mysql/libexec/mysqld: unknown option '--skip-innodb'
121017 11:39:41 [ERROR] Aborting

121017 11:39:41 [Note] /usr/local/mysql/libexec/mysqld: Shutdown complete

121017 11:39:41 mysqld_safe mysqld from pid file /usr/local/mysql/var/xwh-4.pid ended

-----------------------------------------------------
配置文件为：
[client]
port            = 3306
socket          = /tmp/mysql.sock

[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
datadir         = /usr/local/mysql/var
skip-external-locking
skip-name-resolve
skip-innodb
skip-bdb
back_log = 300
key_buffer_size = 256M
max_allowed_packet = 16M
thread_stack = 128K
table_cache = 512
sort_buffer_size = 4M
read_buffer_size = 2M
join_buffer_size = 2M
record_buffer = 2M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache_size = 128
query_cache_size = 64M
tmp_table_size = 128M
max_connections = 4096
max_connect_errors = 100000000000
wait_timeout = 15
thread_concurrency =  48
log-bin=mysql-bin
log_slow_queries = slow.log
long_query_time = 1
expire-logs-days  = 30
max_binlog_size= 1024M
log_error = mysql-error.log

server-id=1
#binlog-do-db=discuz
[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout


求指点！！！！

biyexp

找到问题了skip-bdb，新版mysql已经没有这个参数了
现在已经启动mysql。但是错误日志还是有警告。
我估计可能也是新旧版本参数更改导致吧。请教新参数的写法，消除警告！
121017 12:11:03 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
121017 12:11:03 [Warning] 'record_buffer' is deprecated and will be removed in a future release. Please use 'read_buffer_size' instead.
121017 12:11:03 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
121017 12:11:03 [Warning] /usr/local/mysql/libexec/mysqld: unknown option '--loose-skip-innodb'
121017 12:11:03 [Warning] 'user' entry 'root@xwh-4' ignored in --skip-name-resolve mode.
121017 12:11:03 [Note] Event Scheduler: Loaded 0 events
121017 12:11:03 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.60-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

vincent119

121017 12:11:03 [Warning] 'record_buffer' is deprecated and will be removed in a future release. Please use 'read_buffer_size' instead.
121017 12:11:03 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.


change config

小版主杀手

修改my.cnf文件里的几个Warning参数

cenalulu

121017 12:11:03 [Warning] 'record_buffer' is deprecated and will be removed in a future release. Please use 'read_buffer_size' instead.
把 record_buffer 改成 read_buffer_size

121017 12:11:03 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
把log_slow_queries 改成 slow_query_log

121017 12:11:03 [Warning] /usr/local/mysql/libexec/mysqld: unknown option '--loose-skip-innodb'
这个配置项没有意义，把 loose-skip-innodb 直接去掉

121017 12:11:03 [Warning] 'user' entry 'root@xwh-4' ignored in --skip-name-resolve mode.
你配置了 skip-name-resolve 所以导致权限配置中的 root@xwh-4 是永远不会生效的。
drop user 'root'@'xwh-4' 即可

chinafenghao

问题不大，只是快要过期的参数问题。

wyfha

这不是明明白白告诉你该干嘛了，有啥好问的。

biyexp

英语不行。 已经都参照日志改变参数了。 谢谢cenalulu版主