I get MySQL Error message: Too many connections

September 11, 2017     0 comments

This is almost similar to the max_user_connections error. Website.com.bn allows up to 30 simultaneous connections per MySQL user. If 30 connections are open and you try to make a 31st, you may receive a “Too many connections” error message.

30 connections are more than enough for most website! At most connections are only open a fraction of a second, so 30 simultaneous connections are usually sufficient, even for a forum with thousands of members.

If you receive the “Too many connections” error message regularly, one of two things might be happening:

  1. Your site is experiencing consistently high traffic and your database is being overloaded with connection attempts. If this is the case, your site and your business may have outgrown shared web hosting. You may need to consider moving to semi-dedicated or virtual private server (VPS) hosting.
  2. Your database connections are not closing properly and are preventing new connections from being made. If your site has not experienced recent major spikes in traffic, this may be the reason for your error message. In this case, you need to correct your code so that open connections are closed once the request has been made to the database.


How helpful was this article to you?

Leave a comment

Your name
Your email address
Comment on this article