| SQL queries left open [message #6470] |
Mon, 14 October 2002 04:38  |
roedema
Messages: 10
Registered: October 2002
Karma: 0
|
Junior Member |
|
|
I received this in an email from my web host today:
| |
Good evening, the domain [mydomain.tld] has been leaving SQL queries open for the past few days. SQL queries normally die after around 1-2 seconds however [mydomain.tld] has been leaving them open for upto 60 minutes until we kill them manually.
|
I'm not very experienced with mysql or php as far as it relates to it. the forum has only been up for a week or so, and there are only a handful of members; hence the forum is still quite small (50 or 60 posts). I searched the support forum here and couldn't find anything relevant. anyone have any ideas?
|
|
|
|
|
|
| Re: SQL queries left open [message #6483 is a reply to message #6479] |
Mon, 14 October 2002 18:31  |
roedema
Messages: 10
Registered: October 2002
Karma: 0
|
Junior Member |
|
|
|
haha. silly me. I guess I wasn't clear on what persistent connections are in mysql. perhaps the text "Highly recommended unless you have a good reason not to" in the control panel was a bit misleading. but I should have realized from the documentation that this is probably not kosher on a virtual site. thanks for your help!
|
|
|
|
| Re: SQL queries left open [message #6488 is a reply to message #6483] |
Mon, 14 October 2002 19:49 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Persistant connections are a fairly complex thing, that does offer some increased performance. However, the current implementation of them in PHP leaves much to be desired and on many servers using persistant connection could lead to problems.
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]