Not closing active MYSQL connections

  • Resolved durkindm

    (@durkindm)


    15 years, 8 months ago

    My host provider told me that my database (show process list) was reporting active mysql connections that were not closing and causing high CPU loads. When the maximum number of connections was reached my site would stop and they would have to reset these connections (kill them i believe is the terminology used).

    They told me to contact my web developer and get them to make changes to scripts to ensure MYSQL connections are closed properly.

    I’m pretty confident this is not a WordPress 2.7.1 problem otherwise I’m sure many thousands of sites would have had the same problem by now. I therefore think it is related to a plugin.

    This problem started four days ago and in that time I have only updated the Simple Tags plugin and Google Analyticator plugin. I suspect the problem lies with Simple Tags as this one does make calls on the database.

    Has anyone else come across this problem also and how can Simple Tags be checked to see if there is a a missing MYSQL connection close statement.

    If it is not that, then I have no idea where else to turn.

    Out of my depth here and any help gratefully received.

    Mike

Viewing 2 replies - 1 through 2 (of 2 total)

  • I have the exact same problem. The only way I’ve found to fix it is by grabbing the cloud and rendering it in a Text Widget (non-dynamically).

    I would love to find an answer as to how to fix it though.

    I see this topic is marked as resolved. Have you guys found a solution to this problem?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Not closing active MYSQL connections’ is closed to new replies.