How do I increase the MySQL connections for my server?
The MySQL SmartPool v.2 for the Grid comes with 30 MySQL connections.
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 permitted is controlled by the
max_connections system variable. Its default value is 100. If you need to support more connections, you should set a larger value for this variable.
Before you start, this article has the following dependencies:
- You must have SSH access set up for root or a sudo user.
READ ME FIRST
This article is provided as a courtesy. Installing, configuring, and troubleshooting third-party applications is unsupported by (mt) Media Temple. Please take a moment to review the Statement of Support.
Otto Can Help!
If you're having trouble with the steps described in this article, additional assistance is available through our OttoTune service. Our expert engineers can tweak and tune your server for optimum performance. For more information on what Otto can do for you, please visit this article.
It is possible to upgrade your concurrent MySQL connections by adding a MySQL GridContainer to your Grid hosting package. The three different sizes offered are 60, 100, and 150 concurrent connections respectively.
For more information on the MySQL GridContainer, please see our Grid product page.
There will be a section that looks like this: (may be slightly different)
[mysqld] local-infile=0 datadir=/var/lib/mysql user=mysql symbolic-links=0 max_connections = 100
Under [mysqld], you can increase your maximum MySQL connections by changing the max_connections attribute to something like this.
[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]
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
Save the changes and type the following to restart mysqld:
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:
- Log into MySQL and you will be at the
mysql -uadmin -p`cat /etc/psa/.psa.shadow`
- Then run the command
Make sure you enter the semi-colon on the end. To exit mysql, use the
show variables like 'max_connections';
The authoritative source for this information may be found at the following URL: