Web Wiz Forums - Unstable connection

Unstable connection

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=28659
Printed Date: 01 April 2026 at 7:17pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Unstable connection

Posted By: TBVillage
Subject: Unstable connection
Date Posted: 21 June 2010 at 1:25am

Hi, I appear to have an unstable connection to our MySQL database. Sometimes it works and others it fails and need resetting (causing us significant downtime). My technical support person has thought it is because we are exceeding the maximum number of connections to the MySQL database but I'm not so sure. He increased it to 2000 connections but it's gone down again.

A little history. We have recently changed to a new hosting company (see other thread on this board). We took a little while to get set up but then it was working fine and members were happy with the faster forums. However, now it keeps failing because of "too many connections" (the error message is on other thread). Now, before I change the DNS of our domain, all I have done is modified the forum/default.asp file on my old host so that it does a "meta redirect" to the forum folder on the new hosting company. This seems to work fine and takes users to the new forum. So, currently the DNS still points to the old site (not sure if this is an issue?). The new forum has worked fine until these recent connection issues.

I also notice that we are using "localhost" as the server name. Is this a potential problem? I think the database may be on a different server. Should I put the IP address instead?

strSQLServerName = "localhost" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
strSQLDBUserName = "####" 'Holds the user name (for SQL Server Authentication)
strSQLDBPassword = "####" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "####"

Thanks

Replies:

Posted By: TBVillage
Date Posted: 21 June 2010 at 1:30am

I have now received this request from the host, after I asked them to reset it. I thought there was already a "close connection" routine in the database_connection script, but perhaps this doesn't get a chance to run?

Response from Support:

Done. I have reset it again.
Could you please kindly use the close connection function on your script so it will close the connectivity to the database when it is not used.
It will never been enough even we set the max connection to 100,000 because when a user on your site making connection to the database, it will count as 1 connection, and if he/she lgo out from your site and then connect to your site again, it will count as a new connection again and the previous connectivity to the DB is still open since you don't close the connection. Thanks.

Posted By: WebWiz-Bruce
Date Posted: 21 June 2010 at 9:53am

All database connections in Web Wiz Forums are closed as soon as the database connection is no-longer required.

Usually even with over 200 people on a Web Wiz Forums you don't see more than 5 or 6 user connections to the mySQL database.

The only times have seen user connections go much higher than this is if the database has become corrupted and needs to have the tables and indexes repaired using mySQL Admin.

If the database server is installed on the same server as the website then 'localhost' will work fine.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting