mysql用一段时间会崩溃
时间:2011-10-26
来源:互联网
RT 小弟对mysql了解不太多 以前搭建一个服务器用php和mysql的 会经常在服务器上面上传一些数据而且上传数据比较多。
经常发现半夜mysql会崩溃,然后查看错误日志是这样的
HTML code
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呢?
经常发现半夜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有冲突。
比如以前的360就和MYSQL有冲突。
作者: ACMAIN_CHM 发布时间: 2011-10-26
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28