+ -
当前位置:首页 → 问答吧 → mysql用一段时间会崩溃

mysql用一段时间会崩溃

时间:2011-10-26

来源:互联网

RT 小弟对mysql了解不太多 以前搭建一个服务器用php和mysql的 会经常在服务器上面上传一些数据而且上传数据比较多。
经常发现半夜mysql会崩溃,然后查看错误日志是这样的
HTML code

//mysql开始重启,按照道理这个时间点用户机器都关机了
Number of processes running now: 0
111025 23:19:10  mysqld restarted
111025 23:19:11 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
111025 23:19:11 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
111025 23:19:11  InnoDB: Started; log sequence number 0 43655
111025 23:19:11 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/conf/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

Number of processes running now: 0
111025 23:20:25  mysqld restarted
111025 23:20:26 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
111025 23:20:26 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
111025 23:20:26  InnoDB: Started; log sequence number 0 43655
111025 23:20:26 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/conf/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

Number of processes running now: 0
111025 23:21:29  mysqld restarted
111025 23:21:29 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
111025 23:21:29 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
111025 23:21:29  InnoDB: Started; log sequence number 0 43655
111025 23:21:29 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/conf/var/lib/mysql/mysql.sock'  port: 3306  Source distribution
·····//一直到这里mysql才会停止自动重启restarted

Number of processes running now: 0
111025 23:39:54  mysqld restarted
111025 23:39:54 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
111025 23:39:54 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
111025 23:39:57  InnoDB: Started; log sequence number 0 43655
111025 23:39:58 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77'  socket: '/conf/var/lib/mysql/mysql.sock'  port: 3306  Source distribution

Number of processes running now: 0
111025 23:40:16  mysqld restarted
111025 23:40:21 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
111025 23:40:21 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
111025 23:40:23  mysqld ended





my.cnf也没做什么设置如下

[mysqld]
datadir=/conf/var/lib/mysql
socket=/conf/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
port=3306

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


求大牛帮忙分析一下 这几天一直研究这个问题 找不到原因啊 而且半夜的时候 也没有用户使用服务器啊怎么就突然自动崩溃然后再restart呢?

作者: zsbingliang   发布时间: 2011-10-26

因为是B/S架构的 客户端每上传一块数据时会访问mysql

作者: zsbingliang   发布时间: 2011-10-26

服务器是不是有什么 cron程序在干扰mysqld?

作者: trainee   发布时间: 2011-10-26

没有啊 是不是 我my.cnf没配置的问题啊

作者: zsbingliang   发布时间: 2011-10-26

检查防火墙,杀毒软件。
比如以前的360就和MYSQL有冲突。

作者: ACMAIN_CHM   发布时间: 2011-10-26

相关阅读 更多

热门下载

更多