mysql server connections are being left open causing low system resources and inability to view site

[oncidium]

My website has been having connection problems on and off. According to my web provider the problem is wordpress...these were his comments.

"It’s the fact that it opens up connections to the database and then doesn’t close them,Its consuming system resources that are required to run other things,

We are running 2 GB of ram and mysql right now is hording over 65% and this is due to open connections." persistent connections...any way to fix this?

[westi]

WordPress doesn't open persistent connections it uses ​mysql_connect not ​mysql_pconnect.

It doesn't explicitly call ​mysql_close but the connection should be closed implictly by PHP when script execution ends.

[masquerade]

Westi is right, see:
​http://php.net/mysql_close

Closing as invalid.

[oncidium]

I have still been having this problem and it is the wordpress database leaving the connections open. Any ideas on how I can fix it. I've been looking in the forums/online for a month now and still haven't found an answer. If this helps, this info was provided by the host (cherylke_ is the wordpress database):

235 | cherylke_cheryl | localhost | cherylke_ | Sleep | 8147 | | |

| 2439 | cherylke_cheryl | localhost | cherylke_ | Sleep | 4493 | | |
| 2459 | cherylke_cheryl | localhost | cherylke_ | Sleep | 4463 | | |
| 3324 | cherylke_cheryl | localhost | cherylke_ | Sleep | 3202 | | |
| 3754 | cherylke_cheryl | localhost | cherylke_ | Sleep | 2722 | | |

[darkfate]

You can always modify your wp install to accomodate for this. It might be your sql version or a problem with the sql installation on the server. Anyways, it's a problem on your end and you have to connect your web host. Also, upgrade to 2.0.3 if you haven't already.