miniBB ® miniBB®
miniBB Support Forums
 | Forums | Register | Reply | Search | Statistics | Manual |
The Other miniBB Support Forums / The Other /   

Database/SQL A Lot of Connections

Author Prince
Registered
#1 | Posted: 1 Aug 2011 12:37 
Hello,

There are a large amount of connections, mostly duplicates, being generated by the server which is drastically increasing the load on the server. Most of these connections do not appear to close properly, hence causing the load issues I have been experiencing.

SQL or Forum is opening connections and never or not closing them properly causing this issue.

When it happens, server goes down and we should restart it.. It happens more than 3 times a day.

I was wondering if anyone can help on that? :)

Best regards

Author Guest
#2 | Posted: 2 Aug 2011 10:27 
Reading manual for PHP's mysql_connect(), you may discover that The link to the server will be closed as soon as the execution of the script ends, unless it's closed earlier by explicitly calling mysql_close().

miniBB can't be guilty because of that.

The opened connection may hang up because it takes too many time to get the result, in case of a very complicated query. None of such queries is present in miniBB.

Author Prince
Registered
#3 | Posted: 7 Aug 2011 00:34 
Thanks about that.. it was Hoster (Server's Hardware) problem.. and fixed it. :)

Author Paul
Lead Developer
#4 | Posted: 8 Aug 2011 10:50 
Prince:
it was Hoster (Server's Hardware) problem..

In 90% of cases people claiming miniBB, come to that.
No wonder hosting providers claim software developers, because they can't handle their business which equals 1000 customers on one server.

But miniBB is not guilty on that!

The Other miniBB Support Forums / The Other / Database/SQL A Lot of Connections Top

Your Reply Click this icon to move up to the quoted message

 Short link for this topic:

 ?
Only registered users are allowed to post here. Please, enter your username/password details upon posting a message, or register first.


Before posting, make sure your message is compliant with our forum posting rules. If not, it may be locked or deleted with no explanation.
 
miniBB Support Forums Powered by Forum Software miniBB ® Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contacts
Proceed with the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
Captcha Addon for miniBB