Opened 17 years ago
Closed 16 years ago
#8258 closed defect (bug) (worksforme)
Wordpress Connections not closing
Reported by: |
|
Owned by: | |
---|---|---|---|
Milestone: | Priority: | normal | |
Severity: | normal | Version: | |
Component: | General | Keywords: | open connections has-patch reporter-feedback |
Focuses: | Cc: |
Description
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
Attachments (1)
Change History (19)
#2
@
17 years ago
- Priority changed from highest omg bbq to normal
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.
#3
@
17 years ago
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.
#4
@
17 years ago
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.
#7
@
17 years ago
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.
#8
@
17 years ago
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?
#10
@
17 years ago
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.
#15
@
16 years ago
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...
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.