你的服务器是不是经常出现这样的错误呢?可能是过一两天出现一次,也可能是一两个小时出现一次。
错误信息如下:
Can not connect to MySQL server Error: Too many connections
Errno.: 1040
Similar error report has beed dispatched to administrator
before.
If you get a Too many connections error when you try to connect
to the mysqld server, this means that all available connections are
in use by other clients.
The number of connections allowed is controlled by the
max_connections system variable. Its default value is 100. If you
need to support more connections, you should restart mysqld with a
larger value for this variable.
mysql官方告诉我们需要修改max_connections的值,那么我们怎么去修改呢?有两种方法
1、修改配置文件文件
修改/etc/my.cnf这个文件,在[mysqld]中新增max_connections=N,如果你没有这个文件请从编译源码中的support-files文件夹中复制你所需要的*.cnf文件为到/etc/my.cnf。我使用的是my-medium.cnf,中型服务器配置。例如我的[mysqld]的内容如