When my MySQL server is under high load from the local machine it doesn't accept any remote connections. When load is normal it connects without any issues, but under high load neither a MySQL nor telnet connection works, while local connections are fine. How can I fix this?

  • Could you add the error or refuse message you get? Or does the connection just time out? Are you connecting as root from localhost during the event? MySQL has limit for number of concurrent connections, but keeps one slot reserved for the root account to fix things when needed. – jkavalik May 5 '16 at 19:05
  • What are the values of max_connections and Max_used_connections? – Rick James May 5 '16 at 20:52
  • @jkavalik It just hangs indefinitely, there is no error. I am aware of that, but my max_connections is 10000 and it's nowhere near that. I am able to connect with both root and a regular user on the localhost. – nebkat May 5 '16 at 21:42
  • @RickJames 10000 max_connections, 631 max_used_connections – nebkat May 5 '16 at 21:44
  • Are you running a hosted service? I heard of one that drops max_connections when the load gets too high. (I have 4-letter words for describing them.) – Rick James May 6 '16 at 3:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.