错误日志最后还有这样的信息:
121116 19:18:00 InnoDB: Starting shutdown...
121116 19:18:01 InnoDB: Shutdown completed; log sequence number 0 368547
121116 19:18:01 [Warning] Forcing shutdown of 1 plugins
121116 19:18:01 [Note] D:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete121116 19:18:07 InnoDB: Started; log sequence number 0 368547
121116 19:18:07 [Note] Event Scheduler: Loaded 0 events
121116 19:18:07 [Note] D:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.35-community-log' socket: '' port: 6003 MySQL Community Server (GPL)
121116 19:18:00 InnoDB: Starting shutdown...
121116 19:18:01 InnoDB: Shutdown completed; log sequence number 0 368547
121116 19:18:01 [Warning] Forcing shutdown of 1 plugins
121116 19:18:01 [Note] D:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete121116 19:18:07 InnoDB: Started; log sequence number 0 368547
121116 19:18:07 [Note] Event Scheduler: Loaded 0 events
121116 19:18:07 [Note] D:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.35-community-log' socket: '' port: 6003 MySQL Community Server (GPL)
应该还是那几个参数的问题。show variables like ' 检查一下,参数是否正确。
121116 19:18:00 InnoDB: Starting shutdown...
121116 19:18:01 InnoDB: Shutdown completed; log sequence number 0 368547
121116 19:18:01 [Warning] Forcing shutdown of 1 plugins
121116 19:18:01 [Note] D:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: Shutdown complete121116 19:18:07 InnoDB: Started; log sequence number 0 368547
121116 19:18:07 [Note] Event Scheduler: Loaded 0 events
121116 19:18:07 [Note] D:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld: ready for connections.
Version: '5.1.35-community-log' socket: '' port: 6003 MySQL Community Server (GPL)从这个日志来看,19:18:01数据库有关闭操作,而且应该是正常关闭。19:18:07又启动了MySQL。
前面的日志121116 19:18:00,应该跟版主说的:
wait_timeout=2880000
interactive_timeout = 2880000
max_allowed_packet = 100M
这三个参数有关,是不是你的参数文件没有应用上去,你登录Mysql以后
show variables like 'wait_timeout';
show variables like 'interactive_timeout';
show variables like 'max_allowed_packet';
看看是否都是正确的