网站总是提示“Notice:数据库链接错误 in”,结合mysql日志查询了网上的一些资料,尝试了几种方法,都没有效果,以下贴出方法以及mysql日志,希望牛人能帮忙分析一下,给出一些调整思路1、在my.ini里面加上了“skip-external-locking、skip-name-resolve”,测试结果不行;
2、忘记在哪里看到的,在my.ini加入“bind-address= 127.0.0.1”测试也是不行;
3、尝试增加了“max_connections=2000”数值调整为4000,结果还是出错;
4、在服务——mysql——属性——第一次失败,改成"重新启动服务",在下方的“重新启动服务:()分钟后”添上“0”,结果仍然不行,还是会出现错误
5、技术通过php代码编写了一个清理链接的文件,清除不使用的连接,仍然会报哪个错误;mysql一直是正常运行的,就是在本周突然出现的这个错误,跟之前相比,本周的访问量增大了,是否跟这里也有关系,下边是mysql的日志,刚刚报错以后截取的,希望大牛能帮忙分析一下,给出一些思路,感激不尽
130614 14:10:56 InnoDB: Started; log sequence number 0 2375635739
130614 14:10:56 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
130614 15:01:06 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8558 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8469 user: 'zhai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8450 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8428 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8320 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8207 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8177 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8154 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8026 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 6963 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 3421 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 3380 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 3346 user: 'kai'130614 15:01:09 InnoDB: Starting shutdown...
130614 15:01:11 InnoDB: Shutdown completed; log sequence number 0 2375666530
130614 15:01:11 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete130614 15:01:12 InnoDB: Started; log sequence number 0 2375666530
130614 15:01:12 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
数据库MySQL
2、忘记在哪里看到的,在my.ini加入“bind-address= 127.0.0.1”测试也是不行;
3、尝试增加了“max_connections=2000”数值调整为4000,结果还是出错;
4、在服务——mysql——属性——第一次失败,改成"重新启动服务",在下方的“重新启动服务:()分钟后”添上“0”,结果仍然不行,还是会出现错误
5、技术通过php代码编写了一个清理链接的文件,清除不使用的连接,仍然会报哪个错误;mysql一直是正常运行的,就是在本周突然出现的这个错误,跟之前相比,本周的访问量增大了,是否跟这里也有关系,下边是mysql的日志,刚刚报错以后截取的,希望大牛能帮忙分析一下,给出一些思路,感激不尽
130614 14:10:56 InnoDB: Started; log sequence number 0 2375635739
130614 14:10:56 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
130614 15:01:06 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8558 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8469 user: 'zhai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8450 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8428 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8320 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8207 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8177 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8154 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8026 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 6963 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 3421 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 3380 user: 'kai'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 3346 user: 'kai'130614 15:01:09 InnoDB: Starting shutdown...
130614 15:01:11 InnoDB: Shutdown completed; log sequence number 0 2375666530
130614 15:01:11 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete130614 15:01:12 InnoDB: Started; log sequence number 0 2375666530
130614 15:01:12 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
数据库MySQL
解决方案 »
- 菜鸟问题:如何远程连接到mysql服务器
- 关联查询的问题
- MYSQL出现的奇怪错误
- 这个mysql触发器怎么写呀??一个到特定时间全部清空一个表的触发器。
- 关于order by 两个字段排序的问题?
- DBF 文件转换成MYSQL数据库文件
- mysql导入excel中的数据乱码
- 请问图片格式的数据类型在mysql里类型应该是什么?image是不是不可用啊?
- 好像一些配置信息都在名为mysql的库里,例如用户名基访问权限之类的,有这方面的参考资料么,请给个连接?
- mysql Cluster 各个部分的作用是什么 在等大侠
- mysql与oracle数据同步
- 【求教】mysql left join 优化问题
130614 14:09:34 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 4410 user: 'zhai'
出现这个一般来说,应该是操作系统主动来关闭MYSQL,比如管理员手工关闭MYSQL,或者防病毒软件关闭了MYSQL。
这一周或者杀毒软件更新的病毒库。