cashjay 发表于 2011-4-4 22:40:38

ERROR! MySQL PID file could not be found!求解决！

重启lnmp时出现如下：
Reload LNMP...
Reload Nginx configure...
the configuration file /usr/local/nginx/conf/nginx.conf syntax is ok
configuration file /usr/local/nginx/conf/nginx.conf test is successful
Nginx program is reloding!
ERROR! MySQL PID file could not be found!
Reload service php-fpmdone




求大侠指点吧

licess 发表于 2011-4-5 11:58:04

回复 1# 的帖子

发/usr/local/mysql/var/主机名.err 的日志

datianjing 发表于 2011-12-5 17:45:14

帮我看下我的日志文件

Status information:

Current dir: /usr/local/mysql/var/
Running threads: 6Stack size: 196608
Current locks:
lock: 0x9fa2910:

lock: 0x9fa4d20:

lock: 0x9f9fd20:

lock: 0x9f8c648:

lock: 0x9f89d40:

lock: 0x9f664b8:

lock: 0x9f62240:

lock: 0x9f58258:

lock: 0x9f51a58:

lock: 0x9e75b30:

lock: 0x9f275c8:

lock: 0x9f25320:

lock: 0x9f227b0:

lock: 0x9f1e7e8:

lock: 0x9f1ad28:

lock: 0x9f17118:

lock: 0x9f14508:

lock: 0x9f10420:

lock: 0x9f0c570:

lock: 0x9f0a0f8:

lock: 0x9f07530:

lock: 0x9f051d8:

lock: 0x9f02d40:

lock: 0x9f00670:

lock: 0x9efdcb0:

lock: 0x9efa7d8:

lock: 0x9ef20b0:

lock: 0x9eee6a0:

lock: 0x9eeafe8:

lock: 0x9ee2b10:

lock: 0x9edb8f0:

lock: 0x9ed5d10:

lock: 0x9ed2e70:

lock: 0x9ed0750:

lock: 0x9ecaa08:

lock: 0x9ec7648:

lock: 0x9ec3c50:

lock: 0x9ec0e00:

lock: 0x9ebc380:

lock: 0x9eb9968:

lock: 0x9eb61d8:

lock: 0x9eb23d0:

lock: 0x9eadf00:

lock: 0x9eaabe0:

lock: 0x9ea8668:

lock: 0x9ea5478:

lock: 0x9e9cd38:

lock: 0x9e94c90:

lock: 0x9e8fea8:

lock: 0x9e8a1f0:

lock: 0x9e85b10:

lock: 0x9e7f8e0:

lock: 0x9e583d0:


Key caches:
default
Buffer_size:      16777216
Block_size:         1024
Division_limit:      100
Age_limit:             300
blocks used:         160
not flushed:             0
w_requests:         5279
writes:               5206
r_requests:          24558
reads:                   3


handler status:
read_key:      10384
read_next:      6429
read_rnd          2034
read_first:      14169
write:            4636
delete               9
update:         1014

Table status:
Opened tables:      157
Open tables:         53
Open files:         108
Open streams:         0

Alarm status:
Active alarms:   6
Max used alarms: 7
Next alarm time: 21356

Begin safemalloc memory dump:

End safemalloc memory dump.

Memory status:
Non-mmapped space allocated from system: 1695744
Number of free chunks:                       6
Number of fastbin blocks:               0
Number of mmapped regions:               2
Space in mmapped regions:               16781312
Maximum total allocated space:               0
Space available in freed fastbin blocks: 0
Total allocated space:                       1554240
Total free space:                       141504
Top-most, releasable space:               132784
Estimated memory (with thread stack):    19656704



Events status:
LLA = Last Locked AtLUA = Last Unlocked At
WOC = Waiting On ConditionDL = Data Locked
The Event Scheduler is disabled

111205 17:21:24 /usr/local/mysql/libexec/mysqld: Normal shutdown

111205 17:21:25 /usr/local/mysql/libexec/mysqld: Shutdown complete

111205 17:21:25 mysqld_safe mysqld from pid file /usr/local/mysql/var/localhost.localdomain.pid ended
111205 17:23:58 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
111205 17:23:58 /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'socket: '/tmp/mysql.sock'port: 3306Source distribution

licess 发表于 2011-12-6 08:45:53

回复 3# 的帖子

在那部分添加上下面这两行，再重启试试
long_query_time = 5
log-slow-queries
页: [1]
查看完整版本: ERROR! MySQL PID file could not be found!求解决！