120518 17:30:30 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown
120518 17:30:30 [Note] Event Scheduler: Purging the queue. 0 events
120518 17:30:30 InnoDB: Starting shutdown...
120518 17:30:30 InnoDB: Shutdown completed; log sequence number 0 136557477
120518 17:30:30 [Warning] Forcing shutdown of 1 plugins
120518 17:30:30 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete
120518 17:30:32 InnoDB: Started; log sequence number 0 136557477
120518 17:30:33 [Note] Event Scheduler: Loaded 0 events
120518 17:30:33 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.32-community' socket: '' port: 3306 MySQL Community Server (GPL)
120518 17:31:43 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown
120518 17:31:43 [Note] Event Scheduler: Purging the queue. 0 events
120518 17:31:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 40 user: 'root'
120518 17:31:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 39 user: 'root'
120518 17:31:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 38 user: 'root'
120518 17:31:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 37 user: 'root'
120518 17:31:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 36 user: 'root'
120518 17:31:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 35 user: 'root'
120518 17:31:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 34 user: 'root'
120518 17:31:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 33 user: 'root'
120518 17:31:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 31 user: 'root'
120518 17:31:45 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 30 user: 'root'
120518 17:31:45 InnoDB: Starting shutdown...
120518 17:31:47 InnoDB: Shutdown completed; log sequence number 0 136557487
120518 17:31:47 [Warning] Forcing shutdown of 1 plugins
120518 17:31:47 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete
120518 17:33:05 InnoDB: Started; log sequence number 0 136557487
120518 17:33:05 [Note] Event Scheduler: Loaded 0 events
120518 17:33:05 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.32-community' socket: '' port: 3306 MySQL Community Server (GPL)
120518 18:06:30 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Normal shutdown
120518 18:06:30 [Note] Event Scheduler: Purging the queue. 0 events
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 556 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 555 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 554 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 553 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 552 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 551 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 550 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 549 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 548 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 547 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 546 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 545 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 544 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 543 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 542 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 541 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 540 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 539 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 538 user: 'root'
120518 18:06:32 [Warning] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Forcing close of thread 537 user: 'root'
120518 18:06:32 InnoDB: Starting shutdown...
120518 18:06:34 InnoDB: Shutdown completed; log sequence number 0 138068863
120518 18:06:34 [Warning] Forcing shutdown of 1 plugins
120518 18:06:34 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete
120518 18:06:55 InnoDB: Started; log sequence number 0 138068863
120518 18:06:55 [Note] Event Scheduler: Loaded 0 events
120518 18:06:55 [Note] C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.32-community' socket: '' port: 3306 MySQL Community Server (GPL)
另外,windows自带的日志提示 Forcing shutdown of 1 plugins
6 个解决方案
#1
用户没有授权原因。
#2
启动半小时后自动关闭?
像是人为关闭的服务
像是人为关闭的服务
#3
关闭你的杀毒软件和防火墙然后再观察一下。
#4
授权了
#5
有时候一天自动关闭几次,有时候好几天才发生一次。
#6
没有装杀毒软件和防火墙。
网上搜了搜,说有可能是MYSQL 5.1自带的bug,5.4及以上版本可以解决,正在准备替换mysql5.5试下
#1
用户没有授权原因。
#2
启动半小时后自动关闭?
像是人为关闭的服务
像是人为关闭的服务
#3
关闭你的杀毒软件和防火墙然后再观察一下。
#4
授权了
#5
有时候一天自动关闭几次,有时候好几天才发生一次。
#6
没有装杀毒软件和防火墙。
网上搜了搜,说有可能是MYSQL 5.1自带的bug,5.4及以上版本可以解决,正在准备替换mysql5.5试下