InMotion Hosting Support Center

There are times when you may need to allow more simultaneous connections to your database. Our default setting is to allow 30 connections. If you need to change the setting, however, you will need to do so within your my.cnf file. The instructions below tell you how to make the changes on your VPS or Dedicated server.

Note: Root access is required to be able to make this change.

Modifying your max_user_connections setting

  1. Log into your server via SSH.
  2. Move to the /etc folder.
  3. Open the my.cnf file for editing usng nano, vim, or your favorite editor.
  4. Locate the setting similar to below:
    max_user_connections=30
  5. Change the setting to your required level. Example:
    max_user_connections=50
    Note that 30 is the recommended max for VPS while dedicated servers can go 60 or higher depending on RAM.
  6. Close out your editor, saving the changes.

Now that you have increased the max_user_connection settings your MySQL will be able to hole more simultaneous connections. Note that making this number too high can have adverse effects on the performance of the site, so tweaking to find the optimal number may be necessary.

Continued Education in Course Web Host Manager
You are viewing Section 14: How to change max_user_connections in VPS/Dedicated
Section 13: How to Reset a cPanel password in WHM
Section 15: Disabling SpamCop RBL in WHM

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Social Media Login

   
Social Login Joomla

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

0 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!