RT 小弟对mysql了解不太多 以前搭建一个服务器用php和mysql的 会经常在服务器上面上传一些数据而且上传数据比较多。
经常发现半夜mysql会崩溃,然后查看错误日志是这样的//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 distributionNumber 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 distributionNumber 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才会停止自动重启restartedNumber 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 distributionNumber 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呢?
经常发现半夜mysql会崩溃,然后查看错误日志是这样的//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 distributionNumber 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 distributionNumber 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才会停止自动重启restartedNumber 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 distributionNumber 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呢?
解决方案 »
- Mysql的查询结果排序问题。
- sql语句怎样删除空格数据
- 编译mysql出错:Can't create/write to file '/usr/local/mysql/var/mysql/db.MYI' (Errcod
- 存储过程嵌套调用后的回滚问题
- 请问如何选出a表中所有的但在b表中不出现的的行
- mysql支持select top 5 和子查询吗
- 网站里的mysql问题,在线等!!!!!!!!!
- 怎么打开扩展名为.frm的文件?谢谢!
- 求助——MySQL数据库导入导出时的 大小写问题
- 触发器中sql语句写法
- MYSQL多字节截取的问题
- mysql中配置文件my-innodb-heavy-4G.ini选择
比如以前的360就和MYSQL有冲突。