go77306
10-22-2006, 11:17 PM
according to their policy:
Advanced resellers may not use more than 2% CPU daily, 3% memory daily, run more than 16 simultaneous processes per user or allow any process to run for longer than 30 CPU seconds. Databases are limited to 16 max user connections with a max query time of 8 seconds.
I have a forum and CMS, just wondering is the advanced plan is ok? I am worried about the above policy.
Thanks
Jedito
10-22-2006, 11:22 PM
How popular your site is it takes relevance here, because a regular popular forum can reach the 16 max Mysql connections easily.
alex-developer
10-24-2006, 12:27 PM
16 max Mysql connections easily.
no way, it is use only one user... what they mean 16 different users connections to mysql server. not 16 queries as you thought!
krazykermit
10-24-2006, 12:37 PM
you know, i asked site5 about their database resource policy.. which is similar.. 15 connections, 2000 (!) queries per hour-- seeing how most cms and forums packages can average 10-25 queries for EACH page view (my light-weight php/mysql cms averages a mere 12, but that'd still be well under 200 page views per hour), i thought that the 2000 query limit was a little off-base.... they said that cms's and forums are no big deal and are not a problem (even a "heavy duty" one like typo3).. but i suspect a heavily trafficed forum might raise an eyebrow or two, though.
simultaneous connections are probably a lesser concern, because queries are generally pretty fast on a cms for regular browsing.. on a low-to-moderate site the chance of enough people hitting a page view at *exactly* the same time to generate "excessive" simultaneous mysql connections is probably minimal at best.
Jedito
10-24-2006, 12:43 PM
no way, it is use only one user... what they mean 16 different users connections to mysql server. not 16 queries as you thought!
Are you sure about that?
I tend to think that it means 16 max connections at the same time per user (not per mysql users)
alex-developer
10-24-2006, 12:51 PM
Are you sure about that?
I tend to think that it means 16 max connections at the same time per user (not per mysql users)
apologies, any way I don't like sort of limitation of services, like ftp protocol restriction, number of queries. What will be next?
As for me soon I will look for different hosting company.