Search the KnowledgeBase Search Enter the keywords to search the KnowledgeBase:

All Services (gs) Grid-Service (dv) Dedicated-Virtual (ss) Shared-Server (dpv) Nitro

(dv) Increasing Max MySQL Connections

The authoritative source for this information may be found at the following URL:
http://dev.MySQL.com/doc/refman/4.1/en/too-many-connections.html

Details:

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)

[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

Add the following line under [mysqld]

max_connections=250

The resulting config file should resemble this:

[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
max_connections=250

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:

login to mysql
```
mysql -uadmin -p`cat /etc/psa/.psa.shadow` 
```
and you will be at the "mysql>" prompt.
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

Revisions:

05-20-2008: Fixed some typos.

No visitor comments posted. Post a comment