mysql退出没有更新pid,mysql错误!服务器退出而不更新PID文件吗?

My Vps mysql wont boot , when i attempt to command service mysql start i got this error

root@## [/var/lib/mysql]# service mysql start

Starting MySQL... ERROR! The server quit without updating PID file (/var/lib/mysql/***.***.com.pid).

this is my.cnf

[mysqld]

local-infile=0

set-variable = 100

max_connections=100

safe-show-database

#userstat_running=on

query_cache_limit=4M

query_cache_size=64M

query_cache_type=1

max_user_connections=100

interactive_timeout=30

wait_timeout=100

connect_timeout = 20

thread_cache_size = 256

key_buffer_size=16M

join_buffer_size=2M

max_heap_table_size=16M

low_priority_updates=1

max_allowed_packet=128M

max_seeks_for_key=100

record_buffer=2M

sort_buffer_size=16M

read_buffer_size=16M

max_connect_errors=10

# Try number of CPU's*2 for thread_concurrency

thread_concurrency=4

myisam_sort_buffer_size=64M

tmp_table_size= 64M

set-variable=table_cache=100

read_rnd_buffer_size=1M

skip-name-resolve

open_files_limit=6050

[mysqld_safe]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

and this is the error log

140227 21:23:41 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

140227 21:23:41 [Note] Plugin 'FEDERATED' is disabled.

140227 21:23:41 InnoDB: The InnoDB memory heap is disabled

140227 21:23:41 InnoDB: Mutexes and rw_locks use InnoDB's own implementation

140227 21:23:41 InnoDB: Compressed tables use zlib 1.2.3

140227 21:23:41 InnoDB: Using Linux native AIO

140227 21:23:41 InnoDB: Initializing buffer pool, size = 128.0M

140227 21:23:41 InnoDB: Completed initialization of buffer pool

140227 21:23:41 InnoDB: highest supported file format is Barracuda.

140227 21:23:41 InnoDB: Waiting for the background threads to start

140227 21:23:42 InnoDB: 5.5.35 started; log sequence number 2155325

140227 21:23:42 [ERROR] /usr/sbin/mysqld: unknown variable 'set-variable=100'

140227 21:23:42 [ERROR] Aborting

140227 21:23:42 InnoDB: Starting shutdown...

140227 21:23:43 InnoDB: Shutdown completed; log sequence number 2155325

140227 21:23:43 [Note] /usr/sbin/mysqld: Shutdown complete

140227 21:23:43 mysqld_safe mysqld from pid file /var/lib/mysql/***/***.com.pid ended

how to fix this ? any idea

解决方案

140227 21:23:42 [ERROR] /usr/sbin/mysqld: unknown variable 'set-variable=100'

remove the line from configuration file

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值