Increase MySQL Max Connections

To increase the maximum connections that mysql allows, you must edit the file /etc/my.cnf. Log into the server as root, and type this:

vi /etc/my.cnf 

There will be a section that looks like this: (may be slightly different)


Add the following line under [mysqld]


The resulting config file should resemble this:


You then save the changes, and type the following to restart mysqld:

/etc/init.d/mysqld restart 

You will see:

Stopping mysql: [ OK ]
Starting mysql: [ OK ] 

If Stopping FAILS, then you did something wrong. Try to backtrack and make sure you entered the new setting correctly.



'If you'd like to check to see if this setting was successfully applied, you may check using one of the following methods:

  1. login to mysql
    mysql -uadmin -p`cat /etc/psa/.psa.shadow` 
    and you will be at the "mysql>" prompt.
  2. Then give the command
    show variables like 'max_connections'; 
    make sure you put the semi-colon on the end. To exit mysql, use the "quit" command

Was this answer helpful?

 Print this Article

Also Read

Apache - Address already in use: make_sock: could not bind to address

Apache - Address already in use: make_sock: could not bind to address This error message can be...

Slow ssh authentication

Problem: ssh login takes up to 30 seconds. Solution: It is likely to be a Reverse DNS issue....

Improve ProFTPD performance

A quick fix to fix connectivity or slow connection issues when using ProFTPD is to edit some of...

FTP uploads have wrong permissions

When files are created in a folder via FTP, the permisions are not set to those of the folder....

Run .cgi outside cgi-bin directory

By default runs CGI scripts in /cgi-bin/ folder only. To allow CGI scripts be processed from...