Increase MySQL max connections for Centos Plesk Servers

Posted on April 03, 2012
MySQL

A brief Overview on MySQL

While connecting to MySQL server you may get many errors this means that your other available connections are being used by other clients.

With the help of max_connections system variable you can control number of permitted connections. But 100 is its default value. And if you want to increase number of connections, you can set high value for this system variable.

Requirements

To start this procedure you must have below mentioned decencies:

For root or a sudo user you must have SSH access
• Connecting via SSH to user server
• How do I enable root access?
• How do I disable SSH login for root user?

Instructions:

To increase the number of maximum connections of MySQL, edit the file /etc/my.cnf. And connect to server as root or sudo user via SSH, and type

Then you will see a section like this or may be somewhat different:

Under [mysqld] add following line:

Resulting configure file must resemble this:

To restart mysqld save the changes and type:

Result will appear as-

If stopping FAILS, there will be some mistake, recheck all settings and make sure you have correctly entered new settings.

Important:

If you want to check settings whether it was applied successfully or not, use any of the below mentioned methods:

1. See mysql> prompt by Log into MySQL

2. Run Command

Remember to add semi column to the end.To exit Mysql, apply the quit command.

Related Posts

Contact Us

Have a question? Send us a message. We'll get back to you soon.

captcha

0 Shares
Share
Share
Tweet
+1
Pin
Stumble