Deny Posted March 20, 2007 Posted March 20, 2007 Hello, I've just talk with technical support and would like to open threads regarding max_user_connections limit. It comes to my attention that setting for max_user_connections into MySql is too limited. Right now is set to 20 and if more people are online they must wait until it comes below 20. It is for myself not logical that someone with Basic Plan and someone with Gold Plan have same setting into MySql while is logical to expect that Gold Plan and higher expect more visitors and chance for mysql error because of limit is high. If your site use a lot databases with visits from 50.000 or 60.000 unique visitors monthly then is most likely that sometime will occur delay and slow down for visitors because of that email. Anyway my question of is it possible to increase max_user_connections from 20 to 25 or 30? thanks
TCH-Bruce Posted March 20, 2007 Posted March 20, 2007 Welcome to the forums Deny There are many sites hosted on TCH that receive those kinds of numbers of visitors not having a problem with the current settings of the servers. Most of the time when you receive a max connections message is because you are using persistent connections. If your scripts can be modified to use mysql_connect instead of mysql_pconnect you should have no issues. If you want to know if the setting can be increased only those on the help desk would be able to assist.
Deny Posted March 20, 2007 Author Posted March 20, 2007 (edited) Welcome to the forums Deny There are many sites hosted on TCH that receive those kinds of numbers of visitors not having a problem with the current settings of the servers. Most of the time when you receive a max connections message is because you are using persistent connections. If your scripts can be modified to use mysql_connect instead of mysql_pconnect you should have no issues. If you want to know if the setting can be increased only those on the help desk would be able to assist. In theory if you have busy sites (let's say you have 80.000 - 100.000 unique visitors monthly) sometime can happen that you have 70-80 online or even more. If 20 of them did request on the same time error will appear. I do not use mysql_pconnect nowhere but limiting to 20 for shared hosting seems to me as dangerous limit for busy sites. Other hosts have for example 25 for share hosting. Thats way i do not understand that Totalchoice with such a powerful servers (more powerful that company above use) has been set limit to 20!? And furthermore it does not matter of you have Platinum account (where you pay $26.95) or Basic account (where you pay $4.00). It is for me absolutely illogical that member for $4.00 have same limit as member for example $26.95 Edited March 20, 2007 by TCH-Thomas See separate post
TCH-Thomas Posted March 20, 2007 Posted March 20, 2007 I have edited your post to exclude names of other hosts. As for if TCH can increase the setting, only the helpdesk can answer that part. If they can´t answer the question, please ask them to have a manager look at the ticket.
Deny Posted March 20, 2007 Author Posted March 20, 2007 I have talk with Tom Duncan (chat) and he told me: I am sorry no we cannot increase it on our shared servers as it will affect the server performance.I am sorry no we cannot allow that as it is a shared server and an increase in number of connection will cause high load on server. Please note that the restriction is set for each DB username. I am sorry , but we do not set seperate restrictions on our shared servers.The only difference is the limits of bandwidth and disk space Thats way i asked all things above.How is possible that such a powerful servers as totalchoice has limit to 20 (very very low for share hosting comparing with other hosting company) and how is possible that Platinum account (where you pay $26.95) and Basic account (where you pay $4.00) have same restriction. It is for me absolutely illogical that member who pay $4.00 have same restriction as member who pay $26.95!
TCH-Bruce Posted March 20, 2007 Posted March 20, 2007 It is a server wide setting. There are basic, silver and platinum accounts on the same server.
Deny Posted March 20, 2007 Author Posted March 20, 2007 (edited) It is a server wide setting. There are basic, silver and platinum accounts on the same server. I know but the price is difference for basic, silver and platinum. Restriction should be different too and 20 is tooo low limit. Edited March 20, 2007 by Deny
TCH-Dick Posted March 20, 2007 Posted March 20, 2007 Our plans our priced according to the amount of bandwidth and disk space allocated to you. Our shared servers are designed to provide an common pool of shared system resources for all accounts and is not based on your plan.
Deny Posted March 20, 2007 Author Posted March 20, 2007 Our plans our priced according to the amount of bandwidth and disk space allocated to you. Our shared servers are designed to provide an common pool of shared system resources for all accounts and is not based on your plan. Thanks for explanation. It is clear. My conclusion is that shared hosting on totalchoice are only for the sites with limited traffic (under 60.000 unique visitor monthly or about 2000 unique visitors daily). If your site start to grow up and you receive more visitors you need to look for another hosting because is not possible to change setting on member basis as other company do.
TCH-Dick Posted March 20, 2007 Posted March 20, 2007 Thanks for explanation. It is clear.My conclusion is that shared hosting on totalchoice are only for the sites with limited traffic (under 60.000 unique visitor monthly or about 2000 unique visitors daily). If your site start to grow up and you receive more visitors you need to look for another hosting because is not possible to change setting on member basis as other company do. We have sites that receive well over those numbers and running MySQL driven sites that are not having these problems. Using pconnect is not the only way to cause this, you should take a look at your code and make sure you are properly closing your connections and that your queries are optimized.
Deverill Posted March 20, 2007 Posted March 20, 2007 Thanks for explanation. It is clear.My conclusion is that shared hosting on totalchoice are only for the sites with limited traffic (under 60.000 unique visitor monthly or about 2000 unique visitors daily). If your site start to grow up and you receive more visitors you need to look for another hosting because is not possible to change setting on member basis as other company do. Hi Deny, I have a reseller account on a shared server and am glad TCH puts limits on poorly behaving programs or overly trafficked accounts so that my accounts are kept safe from being bogged down. Might I suggest that a site that has over 2k uniques per day all doing the level of MySQL traffic you suggest may be better served on a dedicated server? You don't need to "look for another hosting" company as TCH has several dedicated and semi-dedicated options available. If, however, you wanted to be on a host that has 1000 accounts on the same server with 50 simultaneous connections I'm sure you could find it -- but I wouldn't count on good performance. I can understand how a site that is a hobby could become very successful, but one must expect to pay for that success and find ways to finance it either via paid ads or memberships, etc. If it's a business then that much traffic is a good problem and the dedicated server would be "the cost of doing business". I hope you can work it all out!
Head Guru Posted March 21, 2007 Posted March 21, 2007 It can be a very hard task of ballancing server loads, fast loading sites, quick email response times, fast upload speeds, fast download speeds, good ping times and have unlimited resources set on a per user basis. We can keep our server loads very low and offer a great hosting package for $4.00 a month. Less than a Big Mac value meal at McDonalds we provide some very powerful resources to our customers. I personally know clients that have DOUBLE the amount of traffic than your seeing and have no issues with the resource limits in place. Like I said, it is a act of walking a tight rope in order to deliver fast responding servers. Bill
Deny Posted March 21, 2007 Author Posted March 21, 2007 (edited) I do not agree with you Deverill. I have a couple site on different shared hosting by different company where one of the sites according to Awstats have about 100k monthly (between 3000-4000 daily).If you would like to change something then you gonna to ask. Max_user_connection on another sites is, depend on hosting, set to 30, 40 and on one hosting to 50 max_user_connection. The reason that i do not host all sites by the same company is same ip address (or same classes for ip) Anyway my point is that in my opinion is ridiculous to charge $26.95 from the member monthly and not be able to change something for him into his account and then monitor of that changes should give trouble or not. Members are gold. That's something that know every company. Other company are more flexible in communication with members and will do more than totalchoice. I do not have problems right now with max_user_connection because the site is relative new but who knows what can happen over couple months.Then will be probably time to search for another hosting. Thanks for your time guys. btw Nobody talk about "unlimited resources set" and do not need it but about too limited (20 connection per member!?) Edited March 21, 2007 by Deny
Head Guru Posted March 21, 2007 Posted March 21, 2007 I think maybe you have outgrown totalchoice and its time to move on. Good luck with your new provider if you choose to move.
Recommended Posts