Wednesday, November 23, 2016

MySQL : mysql_connect(): Too many connections

Issue:

mysql_connect(): Too many connections

Solutions:
  1. directly connect to the mySQL server (via localhost), and perform the query: SET GLOBAL max_connections = 1024; to change the connection limit at runtime (no downtime).
  2. make your change permanent, and edit the /etc/mysql/my.cnf (or similar) and add the line max_connections = 1024; line within the [mysqld] section; then restart if you couldn't do the live change.

Source: http://stackoverflow.com/questions/730953/how-to-fix-mysql-connect-too-many-connections

Related Posts:

0 comments:

Post a Comment