Error: Can't connect to MySQL server on 'localhost' (10061)
Errno.: 2003 有时刷新页面的时候出现上面这个问题,再刷新一下就又好了,我检查mysql服务是启动并且正常运行的,我找了几天的问题了,也没有解决,望高手帮帮忙。
mysql版本是mysql-5.0.67-win32
Errno.: 2003 有时刷新页面的时候出现上面这个问题,再刷新一下就又好了,我检查mysql服务是启动并且正常运行的,我找了几天的问题了,也没有解决,望高手帮帮忙。
mysql版本是mysql-5.0.67-win32
是否有
LOG=
这样的语句MYSQL应该还是比较稳定的
在mysql的data目录里面有个主机名.err的文件
记事本或者你编辑器打开找到最下面
显示错误信息
mysql> show variables like "datadir"
-> ;
+---------------+---------------------------------------------------------------
--------------------+
| Variable_name | Value
|
+---------------+---------------------------------------------------------------
--------------------+
| datadir | C:\Documents and Settings\All Users\Application Data\MySQL\MyS
QL Server 5.1\Data\ |
+---------------+---------------------------------------------------------------
--------------------+
1 row in set (0.00 sec)
090911 10:28:23 InnoDB: Shutdown completed; log sequence number 0 42688884
090911 10:28:23 [Note] D:\server\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete090911 10:28:27 InnoDB: Started; log sequence number 0 42688884
090911 10:28:27 [Note] D:\server\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
090911 16:53:44 [Note] D:\server\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown090911 16:53:44 InnoDB: Starting shutdown...
090911 16:53:47 InnoDB: Shutdown completed; log sequence number 0 42757563
090911 16:53:47 [Note] D:\server\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete090911 16:57:28 InnoDB: Started; log sequence number 0 42757563
090911 16:57:28 [Note] D:\server\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.67-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
090911 16:58:26 [Note] D:\server\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown090911 16:58:26 InnoDB: Starting shutdown...
090911 16:58:27 InnoDB: Shutdown completed; log sequence number 0 42757651
090911 16:58:27 [Note] D:\server\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete
上面的就是近期的日志。
http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html#query-log
TCP sds-p6qyahfhv96:3918 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3919 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3920 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3921 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3922 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3923 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3924 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3925 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3926 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3927 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3928 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3929 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3930 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3931 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3932 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3933 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3934 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:sdp-portmapper sds-p6qyahfhv96:3306 TIME_WAI
TCP sds-p6qyahfhv96:3936 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3937 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3938 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3939 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3940 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3941 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3942 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3943 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3944 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3945 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3946 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3947 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3948 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3949 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3950 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3951 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3952 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3953 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3954 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3955 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3956 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3957 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3958 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3959 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3960 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3961 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3962 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3963 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3964 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3965 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3966 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3967 sds-p6qyahfhv96:3306 TIME_WAIT
TCP sds-p6qyahfhv96:3969 sds-p6qyahfhv96:3306 TIME_WAIT用netstat命令发现,有很多
Errno.: 2003 有时刷新页面的时候出现上面这个问题,再刷新一下就又好了,--------------------------------
估计是超出连接数引起的,mysql都不允许你连接了
这么多,估计是你的连接太多了。你的 max_connections 设置是多少?
估计是数据库的客户端没有使用连接池,每次访问数据库都新建一个TCP链接,如果访问比较频繁的话,数据库服务器会吃不消的。