What's the difference between error 1152 and other MySQL connection errors?

Question

Grade: Education Subject: Support
What's the difference between error 1152 and other MySQL connection errors?
Asked by:
75 Viewed 75 Answers

Answer (75)

Best Answer
(409)
Error 1152 specifically indicates a problem creating *new* threads/connections. Other connection errors like 'too many connections' simply mean the server has exhausted all available connections (regardless of its ability to create a new thread). Error 1152 focuses on the ability to establish new connections rather than the mere number of active connections. Connection timeout errors are distinct as well.