Max Connection
5 posts by 2 authors in: Forums > CMS Builder
Last Post: August 11, 2010 (RSS)
By yusuke - August 5, 2010
I recently created a Web site for PC/iPhone/Mobile users using Website Membership Plugin, primary used for home appliance maintenance teams to check their clients' data and visiting schedules. There are appx. 300 users accessing to the data (sometime all at the same time.)
There is a problem logging-in. Most of the users get connection error when busy. It happens everyday right before when they go home to do the daily report.
CMSB's "Max connection" indicates 30. However someone told me that even though the 30 is low number, it shouldn't be a problem because 30 people are not logging-in at "exactly" the same time.
I have no idea where to start on solving this problem.
Please Help!
Re: [yusuke] Max Connection
By Jason - August 6, 2010
The "Max connections" information that CMS Builder provides is for the maximum number of MySQL database connections that can be open at any one time. A database connection occurs every time a page pulls content out of CMS Builder, not just when a user is logged in.
The number 30 does seem pretty low. This is a limitation set by the hosting provider, not CMS Builder. The best thing to do would be to contact your hosting provider and ask if this number can be increased.
Hope this helps.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Max Connection
By yusuke - August 8, 2010
Thank you for the reply!
My client did his own research(?) and told me that CMS Builder was limiting the max connection by not "closing" the connection once it's open(?) He also told me that Max connection of 30 should not be a cause for the problem because no 30 users were logging in at "exactly" the same moment even though there were 200 users logging-in at the same time(?)
I have difficulty understanding what my client is saying but I'd like to convince the client to transfer the site to the server which has max connection of 1,000 which I usually use.
Is there any test to show my client the problem resides on the server instead of CMSB?
Re: [yusuke] Max Connection
By Jason - August 9, 2010
When you go to the General Settings section of CMS Builder, the maximum database connections that are displayed are the result of this SQL statement:
SELECT @@max_connectionsIf you have access to the mysql_console on your server or have the Mysql Console plugin, you can run this query and it will display the max_connections. (In your case, this number should be 30).
max_connections is not a variable that is set by CMS Builder, but is a server system variable. If you go to this page:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
You'll get a list of all the server system variables in MySQL. You can do a search and you'll find max_connections on the page. The maximum number of connections can be increased, but this needs to be done on the server.
Hope this helps.
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Max Connection
By yusuke - August 11, 2010
"Max Connection" was never an issue. Now that we started to use a Web Site Membership plug-in, it's safe to notify clients about the number. We hope we can sell more Membership plug-in very soon!
The plug-in is amazing!!
Thank you!