(dv) Increasing Max MySQL Connections
NOTE:
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 [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.
NOTE:
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
and you will be at the "mysql>" prompt.mysql -uadmin -p`cat /etc/psa/.psa.shadow`
- 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.
Fields marked with an asterisk(*) are required. Comment on this article