求助！mysql老是重启

xxgtimk 2010-06-09 08:51:38
mysql每天都要重启几次，但找不到是何缘故，我的系统是2003sever，以下是mysql的错误日志，求高手帮助分析：
100607 4:11:04 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100607 4:11:06 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
100607 4:11:06 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123203428.
InnoDB: Doing recovery: scanned up to log sequence number 0 123264385
100607 4:11:06 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100607 4:11:06 InnoDB: Started; log sequence number 0 123264385
100607 4:11:06 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100607 4:11:08 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
100607 4:11:08 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123264402.
InnoDB: Doing recovery: scanned up to log sequence number 0 123325359
100607 4:11:08 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100607 4:11:08 InnoDB: Started; log sequence number 0 123325359
100607 4:11:09 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100607 4:11:10 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
100607 4:11:10 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123325415.
InnoDB: Doing recovery: scanned up to log sequence number 0 123386388
100607 4:11:10 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100607 4:11:11 InnoDB: Started; log sequence number 0 123386388
100607 4:11:11 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100607 4:11:12 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
100607 4:11:12 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123386405.
InnoDB: Doing recovery: scanned up to log sequence number 0 123447362
100607 4:11:12 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100607 4:11:13 InnoDB: Started; log sequence number 0 123447362
100607 4:11:13 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100607 4:11:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
100607 4:11:15 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123447379.
InnoDB: Doing recovery: scanned up to log sequence number 0 123508336
100607 4:11:15 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100607 4:11:15 InnoDB: Started; log sequence number 0 123508336
100607 4:11:15 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100608 16:46:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
100608 16:46:15 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123909962.
InnoDB: Doing recovery: scanned up to log sequence number 0 123956524
100608 16:46:15 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100608 16:46:15 InnoDB: Started; log sequence number 0 123956524
100608 16:46:15 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100608 16:46:17 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
100608 16:46:17 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 123909962.
InnoDB: Doing recovery: scanned up to log sequence number 0 123975009
100608 16:46:17 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Last MySQL binlog file position 0 0, file name
100608 16:46:18 InnoDB: Started; log sequence number 0 123975009
100608 16:46:18 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100608 17:01:13 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

100608 17:01:15 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 82 user: 'root'

100608 17:01:15 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2 user: 'root'

100608 17:01:15 InnoDB: Starting shutdown...
100608 17:01:18 InnoDB: Shutdown completed; log sequence number 0 123975053
100608 17:01:18 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

100608 17:01:24 InnoDB: Started; log sequence number 0 123975053
100608 17:01:24 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100608 17:05:08 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

100608 17:05:10 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 25 user: 'root'

100608 17:05:10 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 24 user: 'root'

100608 17:05:10 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 6 user: 'root'

...全文
179 7 打赏 收藏 转发到动态 举报
写回复
用AI写文章
7 条回复
切换为时间正序
请发表友善的回复…
发表回复
xxgtimk 2010-06-18
  • 打赏
  • 举报
 回复
我给mysql创建了多个帐户，每个项目用不同的帐户登录，就没发生重启事件了。
谢谢各位~
littleline 2010-06-10
  • 打赏
  • 举报
 回复
换个干净的环境试试！
iihero 2010-06-09
  • 打赏
  • 举报
 回复
1. 防火墙
2. mysql某些配置参数不当
3. 程序问题
都有可能
zuoxingyu 2010-06-09
  • 打赏
  • 举报
 回复
100608 17:10:28 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 6 user: 'root'

在线程6，强制关闭，ROOT用户登录的。

估计是你程序问题导致。

启动MYSQL服务后，什么都不动，看看会不会自动重启。
另外看看这个文章
http://user.qzone.qq.com/792218?ptlang=2052
或许有帮助、
ACMAIN_CHM 2010-06-09
  • 打赏
  • 举报
 回复
检查你的３６０或其它杀毒软件。
xxgtimk 2010-06-09
  • 打赏
  • 举报
 回复
100608 17:05:10 InnoDB: Starting shutdown...
100608 17:05:14 InnoDB: Shutdown completed; log sequence number 0 123975703
100608 17:05:14 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

100608 17:05:15 InnoDB: Started; log sequence number 0 123975703
100608 17:05:15 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt' socket: '' port: 3306 Official MySQL binary
100608 17:09:31 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

100608 17:09:33 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 26 user: 'root'

100608 17:09:33 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 23 user: 'root'

100608 17:09:33 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 4 user: 'root'

100608 17:09:33 InnoDB: Starting shutdown...
100608 17:09:35 InnoDB: Shutdown completed; log sequence number 0 123975713
100608 17:09:35 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

100608 17:09:36 InnoDB: Started; log sequence number 0 123975713
100608 17:09:36 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt-log' socket: '' port: 3306 Official MySQL binary
100608 17:10:26 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

100608 17:10:28 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 6 user: 'root'

100608 17:10:28 [Warning] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 4 user: 'root'

100608 17:10:28 InnoDB: Starting shutdown...
100608 17:10:30 InnoDB: Shutdown completed; log sequence number 0 123975713
100608 17:10:30 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

100608 17:10:30 InnoDB: Started; log sequence number 0 123975713
100608 17:10:30 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.15-nt-log' socket: '' port: 3306 Official MySQL binary
xxgtimk 2010-06-09
  • 打赏
  • 举报
 回复
谢谢各位，去再观察下，不同的项目用不同用户名试试，看是哪个项目出问题了
centos 6.5 mysql 重启_centos 6 下 mysql 5.6 总是自动停止，重启mysqld 后一会又会自动停止，无线循环，求助呀！...
问题描述：mysql 可以启动正常，一切看起来都很正常，网站可以访问，数据库用PHPmyadmin也能访问；但是过一小段时间(10~30分钟不等)就自己停止掉；SSH 命令行中显示如下# /usr/bin/mysqld_safe: line 183: 9...
MySQL--忘记密码，重置密码重启服务密码失效（Windows）
一、问题说明 最近在Windows下操作mysql数据库...修改后使用新密码，能正常登陆成功，但老是发生一件奇怪的事，就是只要一重启mysql服务（net start mysql 或 服务中右键启动），再访问数据库连接mysql时，就报错提...
MySql基础：在Centos7坏境下的配置安装，以及mysql启动报错问题
在安装过程中如过遇到安装密钥过期的问题：Failing package is: mysql-community-client-5.7.39-1.el7.x86_64 GPG Keys are configured as: file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql。这里可能的存在的问题有很多...
MySQL5.0卡在验证_[求助]安装好MySQL5.0后测试出现问题？
问题详情[求助]安装好MySQL5.0后测试出现问题？在windows下安装好php5.1.2，apache2.0.54和mysql5.0.18，并且都设置好后，测试MySQL失败。mysql动态连接库已经正常加载， 测试文件为：$link=mysql_connect('l...
【已解决】Xampp+MySQL+Error: MySQL shutdown unexpectedly.
XAMPP+MySQL报错
MySQL

57,062

社区成员

56,762

社区内容

发帖
与我相关
我的任务
社区描述
MySQL相关内容讨论专区
社区管理员
  • MySQL
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章