Too Many Connections in phpMyAdmin and Sites Offline

PostAlmostAnything

• August 17, 2022 23:06

I have been having a problem the past 24 hours. My sites display errors that they cannot connect to the database and when I try to use phpMyAdmin I get mysqli_real_connect(): (08004/1040): Too many connections I tried setting the max_connections to 300 because my research indicates that exceeds the default. How do I fix this?

• 

  kodeslogic

  • August 18, 2022 07:17

  The following URL will help you to troubleshoot this issue further: [QUOTE]

  0
• 

  HostNoc

  • August 18, 2022 08:17

  Hi Can you please share the result of following Query SHOW VARIABLES LIKE 'max_connections'; Regards SAM

  0
• 

  cPRex Jurassic Moderator

  • August 18, 2022 14:38

  Whenever I run into any type of MySQL issue, the first thing I do is check and see what MySQL is actually doing in real-time with this command: mysqladmin proc status
  That will show you any active queries, and if any specific databases are having issues.

  0
• 

  PostAlmostAnything

  • August 18, 2022 19:44

  I increased the max connections and that seems to have done the trick.

  0
• 

  kodeslogic

  • August 19, 2022 09:49

  Glad you have it resolved.

  0

Please sign in to leave a comment.