miniBB Support Forums | 15 years on The Web
miniBB ®


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

Database/SQL A Lot of Connections

Author Prince
#1 | Posted: 1 Aug 2011 12:37 

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
#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 
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
 Share Topic's Link

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

You are welcome to post anonymously, by entering a nickname with no password (if the similar Username has not been taken yet), or by leaving both fields empty. If you have a forums account, you can also sign in from this page without posting a message, or sign in and post at once.

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  Contact Us
Get the Captcha add-on: protect your miniBB-forums from the automated spam and flood.