错误日志最后还有这样的信息:
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)
解决方案 »
- 求助ASP+MSSQL代码转换成ASP+MYSQL代码...
- 存储过程 循环问题
- Mysql 问题
- 为什么这个存储过程报错
- 存储过程结果集个数的限制,咋整
- 首次提问,关于和sql查询的区别(第一次用MYSQL)!
- mysql性能的优化?!
- 3.23.53-max-nt 不是最稳定的版本吗?怎么回事呢? 2626.65变成2626.6499了
- phpmyadmin2.26 连接win2000下的MySQL 3.23.52-nt 出错帮忙看一下
- mysql 定时任务,每周日18点执行一次,这样写对吗?高手有空的话看看好吗
- 关于FTP命令行下传完文件后打开有问题的问题..
- 【新手求教】一段简单的mysql语句
应该还是那几个参数的问题。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';
看看是否都是正确的