网站总是提示“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
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。
这一周或者杀毒软件更新的病毒库。