100908 14:46:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100908 14:46:00 [Warning] The syntax '--log_slow_queries' is deprecated and will be removed in a future release. Please use '--slow_query_log'/'--slow_query_log_file' instead.
100908 14:46:00 [Warning] The syntax '--log-long-format' is deprecated and will be removed in a future release. Please use --log-short-format instead.
100908 14:46:00 [Warning] --myisam_max_extra_sort_file_size is deprecated and does nothing in this version. It will be removed in a future release.
100908 14:46:00 [Note] Plugin 'FEDERATED' is disabled.
100908 14:46:02 InnoDB: Started; log sequence number 0 44233
100908 14:46:02 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
100908 14:46:02 [ERROR] Do you already have another mysqld server running on port: 3306 ?
除了3306改成其他端口 都可以正常启动，有点灵异。
1. 基本上可以确定是没有释放老进程，于是:
[root@test test]# netstat -an | grep 3306
tcp 0 0 ::ffff:172.16.113.194:3306 ::ffff:172.16.113.194:3306 ESTABLISHED
查看果然如此.
2. 如何干掉当前访问者
[root@test test]# netstat -anp | grep 3306
tcp 0 0 172.16.113.194:3306 172.16.113.194:10764 ESTABLISHED 30869/mysqld
事情紧急，强杀
[root@test test]# kill -9 30869
最新评论