Wordpress Connections not closing

[mallyo]

Hello

I've received the following from my hosting company.

I need to find a fix before they close my account, can anyone advise?

What this means is that wordpress is opening up a connection and then not closing it before the page request is complete. This leaves the connection open which in turn causes load issues. You will need to resolve this issue immediately or the account will need to be suspended again to prevent further server issues.

Can anyone help.

I have the latest version of wordpress installed 263

I've have the following mods enabled

All in One SEO Pack 1.4.6.15

Google XML Sitemaps 3.1.0.1
Permalink Redirect 2.0
SimpleTags 2.0
Simple Tags 1.57

[jacobsantos]

What PHP version? PHP should close the mysql connection when the page is done. However, to say it should means that it doesn't always correctly do so. It would be an easy plugin to make to close the connection manually.

[DD32]

The question is, What connections, No mention of MySQL there, so it nearly seemed like it could be related to HTTP connections, Else 2.7 wouldnt be specifically causing it.

[jacobsantos]

DD32, it is doubtful that it is HTTP connections. I'm a good citizen, so I close the connections when I'm using fsockopen and fopen and even cURL. HTTP should close the connection when it is finished. It doesn't give any handle, so it is not possible to do it manually.

[DD32]

I was thinking of the Cron connections, AFAIK, they're not closed?

MySQL though, is a possibility, And allthough PHP should be closing them, Ensuring they're closed would be best i guess.

[ryan]

In < 2.7, cron requests do not do an explicit fclose(), IIRC.

[mallyo]

thanks for your assistance.

php5
MySQL client version: 4.1.22

[mallyo]

here is the first email complaint I received.

this account has recently been showing signs of causing stability problems on the server which appear to be due to mysql usage on the wordpress installation, it does not appear to be closing it's connections which are then hanging and causing problems for the rest of the server.

[mrmist]

Not seeing this during normal usage of my 2.6 test or 2.7 test sites. mysql processlist is not full of stale connections, which I'd expect if this was a core problem. Maybe plugin related?

[mallyo]

Hello

Any advice or suggestions how to fix this?

[ryan]

WP uses one non-persistent mysql connection that is shut down when PHP script execution ends. Maybe a plugin is doing extra calls to mysql_connect() or you have a custom wp-db.php that does connection retries.

[mallyo]

sorry, I've not modified wp-db.php and only have the mods installed above.

[mallyo]

Hello

Any further advise or questions?

[mallyo]

I'm sorry but I'm still having this problem.

Can anyone suggest a fix please?

[vladimir_kolesnikov]

Forcefully close mysql connection on shutdown

[Denis-de-Bernardy]

Based on the plugins that are active on his install, I sincerely doubt the patch will do any good.

I've had a couple of customers with similar issues, which I traced down to extraordinarily long ping lists. Having them shorten it to only a few ping servers fixed the issue.

Just FYI...

[Denis-de-Bernardy]

@mallyo: if this is your case, rename the ticket accordingly, do not close it.

[Denis-de-Bernardy]

It could also be due to the sitemap generation scripts.

[ryan]

Reopen with requested feedback.