No way. Going through this recently on the HG forums, I know on a good day 100 users could easily share 25 mysql connections. Conversely, if something isn't working right, a single user could fill all 25. Really, on oversold shared servers the problem is usually cpu load anyway ("4.0 per cpu is acceptable" AAAGH).
I use that chatbox (as a shoutbox) and don't get the bots. Odd that some people do.
I see, so I could potentially have hundreds of people on the site, but if more than 26 people tried to load a page at exactly the same time, one would receive an error. This could be a problem if I ever want to properly expand.
What would you recommend usually for a larger board?
EDIT: That's interesting Videx, I guess it all depends on how often your site is being indexed already.
No way. Going through this recently on the HG forums, I know on a good day 100 users could easily share 25 mysql connections. Conversely, if something isn't working right, a single user could fill all 25. Really, on oversold shared servers the problem is usually cpu load anyway ("4.0 per cpu is acceptable" AAAGH).
I use that chatbox (as a shoutbox) and don't get the bots. Odd that some people do.
No way what? It is possible for 25 users alone to kill those 25 connections, just not likely.
It really depends on how much and what if anything they're doing.
I seem to be getting some of these errors now as well (not as many though):
PHP Code:
Database error in vBulletin 4.0.3:
Invalid SQL:
SELECT * FROM vb_style WHERE (styleid = 11 AND userselect = 1) OR styleid = 11 ORDER BY styleid ASC LIMIT 1;
MySQL Error : MySQL server has gone away Error Number : 2006 Request Date : Tuesday, June 15th 2010 @ 02:10:56 AM Error Date : Tuesday, June 15th 2010 @ 02:12:35 AM Script : http://www.atkcommunity.com/threads/2508-EA-Week-on-Steam Referrer : IP Address : xx.xxx.xx.xxx Username : Unregistered Classname : vB_Database MySQL Version :
It comes down to mean you can have 25 active mysql connections total. If you had 26+ users online at the same time, or possibly higehr, your users will get those errors.
That number is kind of mis-leading though, as most connections will run in a faction of a second and close. If you have some poorly structured queries, that can cause problems with connections not closing fast enough. But, 25 is kind of low, I agree. Hostgator is set up that way unless you go the VPS setup or higher.
That number is kind of mis-leading though, as most connections will run in a faction of a second and close. If you have some poorly structured queries, that can cause problems with connections not closing fast enough. But, 25 is kind of low, I agree. Hostgator is set up that way unless you go the VPS setup or higher.
It really depends on a large number of things, if those 25 users are poking, clicking around, possibly using one of those fancy ajax chat boxes, 25 connections can get gobbled up a whole ton faster. Downloading large attachments from the database can also cause issues.
I'd really get a better host. 25 is a bad limit lol.
It seems to be going around nowadays though. The ads trumpet unlimited storage and bandwidth, which is true. But not too many new website owners have any idea what a MySQL connection is, nor any idea the software they'll use may need it. But from personal experience even worse is the "acceptable" CPU load on those oversold shared servers. You'll start getting mysql errors long before you get anywhere near the 25 connection limit.
06-08-2010, 05:19 PM
Linear Mode
