Max Connection

Hi,

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.

Hi Jason,

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?

Hi,

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_connections

If 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.