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

cashjay

重启lnmp时出现如下：

1. Reload LNMP...
   
2. Reload Nginx configure...
   
3. the configuration file /usr/local/nginx/conf/nginx.conf syntax is ok
   
4. configuration file /usr/local/nginx/conf/nginx.conf test is successful
   
5. Nginx program is reloding!
   
6. ERROR! MySQL PID file could not be found!
   
7. Reload service php-fpm  done

复制代码

求大侠指点吧

licess

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

datianjing

Status information:

Current dir: /usr/local/mysql/var/
Running threads: 6  Stack 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 At  LUA = Last Unlocked At
WOC = Waiting On Condition  DL = Data Locked
The Event Scheduler is disabled

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

111205 17:21:25 [Note] /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 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.1.54-log'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

licess

在[mysqld]那部分添加上下面这两行，再重启试试
long_query_time = 5
log-slow-queries