superman 发表于 2013-12-3 21:26:40

mysql无故挂

最近mysql老是无故挂掉，贴一段mysql日志 希望军哥帮忙看看 谢谢了

131203 19:31:19 mysqld_safe Number of processes running now: 0
131203 19:31:19 mysqld_safe mysqld restarted
131203 19:31:20 You need to use --log-bin to make --binlog-format work.
131203 19:31:20 InnoDB: The InnoDB memory heap is disabled
131203 19:31:20 InnoDB: Mutexes and rw_locks use GCC atomic builtins
131203 19:31:20 InnoDB: Compressed tables use zlib 1.2.3
131203 19:31:20 InnoDB: Initializing buffer pool, size = 16.0M
131203 19:31:20 InnoDB: Completed initialization of buffer pool

[ 本帖最后由 superman 于 2013-12-4 09:05 编辑 ]

superman 发表于 2013-12-3 21:59:08

nginx日志

2013/12/03 21:42:18 22914#0: *1 connect() to unix:/tmp/php-cgi.sock failed (2: No such file or directory) while connecting to upstream, client: 60.168.115.105, server: www.****.com, request: "GET /forum.php?mod=post&action=reply2592000 HTTP/1.1", upstream: "fastcgi://unix:/tmp/php-cgi.sock:", host: "www.****.com", referrer: "http://www.****.com/forum.php?mod=post&action=reply2592000"
2013/12/03 21:42:18 22914#0: *1 connect() to unix:/tmp/php-cgi.sock failed (2: No such file or directory) while connecting to upstream, client: 60.168.115.105, server: www.****.com, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/tmp/php-cgi.sock:", host: "www.****.com", referrer: "http://www.****.com/"
2013/12/03 21:42:18 22914#0: *1 connect() to unix:/tmp/php-cgi.sock failed (2: No such file or directory) while connecting to upstream, client: 60.168.115.105, server: www.****.com, request: "GET / HTTP/1.1", upstream: "fastcgi://unix:/tmp/php-cgi.sock:", host: "

licess 发表于 2013-12-3 22:11:54

131203 19:59:02 'user' entry 'root@AY1308162201443403e0Z' ignored in --skip-name-resolve mode.
131203 19:59:02 'proxies_priv' entry '@ root@AY1308162201443403e0Z' ignored in --skip-name-resolve mode.
启用--skip-name-resolve参数的话，就不能用主机名直接连接了，把用户里的带AY1308162201443403e0Z的删除，删除前要确保有127.0.0.1的

但是这个问题不会导致mysql挂掉

nginx日志里只是显示php-fpm挂了，具体原因要看php-fpm日志或开启slowlog看

superman 发表于 2013-12-3 22:18:59

回复 3# 的帖子

昨天晚上从凌晨两点开始又挂了，cpu一直都是100%
查看php-fpm.logcpu100%的时间段没有任何记录
nginx_error.log里面的日志也是这个时间段没有任何记录
求助下军哥我该怎么找到问题的所在？现在站一开，一会就cpu100%了，而且找不到记录，谢谢军哥了

[ 本帖最后由 superman 于 2013-12-4 09:02 编辑 ]

licess 发表于 2013-12-4 10:04:47

开slowlog看看
页: [1]
查看完整版本: mysql无故挂