Wednesday, January 10, 2018

MySQL: Too many connection errors.

When user trying to connect MySQL Database, he got below error

ERROR 1040 (hy000): Too many connections
By looking the error we can see that the max_connections got exhausted. You can check the connection info by running below commands.

-- To find max_connections value run below command
SHOW VARIABLES LIKE '%max_connections%';

-- To see the all processes and connections run below command
SHOW FULL PROCESSLIST;

Note that when you get this error you will be able to login using root. Becoz My SQL by default will consider maximum allowed connections as MAX_CONNECTIONS +1 for super user.

But if you have used root to connect to any other app you will not able to connect to run the above commands. That means you should use root for only Administration purpose only.

You can run below command to change the MAX_CONNECTIONS

SET GLOBAL max_connections = 200;
But note that you need to find out is there any application issue which is creating more connections and causing this issue and fix that later.

Regards
Satishbabu Gunukula, Oracle ACE
http://oracleracexpert.com

3 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. Maharashtra Board class 12th exam Question Paper 2023 The Maharashtra State Board of Secondary and Higher Secondary Education will post the Maha HSC class 12th Model Paper 2023 on its official website shortly after the examination is completed. Maha Board +2 Exam Pattern 2023 The Maharashtra HSC examination 2023 will begin in February 2023, and the Maharashtra 12th Model Paper will be released almost one month later. Aspirants may get their Maharashtra 12th Model Paper/ Sample Paper for Higher Secondary Exam 2023 by downloading it. Maharashtra HSC class 12th Model Paper 2023 may be used by upper secondary students from Science, Commerce, and Arts who are interested in knowing their performance in the 12th annual exam.

    ReplyDelete
  3. If you are receiving too many connection errors, it is likely that your internet connection is not stable. Try restarting your router or modem, and if that does not work, you may need to contact your internet service provider and also will order my daughter dress from this website Kid couture dresses

    ReplyDelete