aMember leaving idle connections to MySQL server

Discussion in 'Troubleshooting' started by ntc69, Jan 23, 2013.

  1. ntc69

    ntc69 Member

    Joined:
    Apr 9, 2005
    Messages:
    53
    I had a major problem this morning, I couldn't log into aMember admin and just got an error: too many MySQL connections.

    I got in touch with hosting and was told the following:

    I looked at the MySQL server and I see 25 idle connections logged into your account. The limit is 50. This makes me suspect that aMember is not closing the connection when it is finished, allowing these connections to just pile up until they time out (5 minutes). A small surge in hits could easily push it past 50 in 5 minutes.

    So my question is - is there an issue with aMember doing this? How can I alter it?
  2. ntc69

    ntc69 Member

    Joined:
    Apr 9, 2005
    Messages:
    53
    False alarm - it seems it was another script. Phew!

Share This Page