travstatesmen, on Aug 23 2008, 10:20 AM, said:
what exactly your "allowable CPU usage limit" is?
There is no set (i.e. numerical) limit that I am aware of. The odd spike from a backup is OK, but consistently using 10% of the CPU power obviously isn't.
travstatesmen, on Aug 23 2008, 10:20 AM, said:
how am I expected to measure this?
You are expected to use discretion. Updating every row of a 1000 row SQL table at 5 minute intervals is likely to be unacceptable, and cause problems. However, updating them once every few hours would probably be OK. If this sort of thing is concerning you, run your scripts locally first. If they cause noticable detriment to your CPU performance, or use considerable amounts of RAM, then they are going to do the same to the Trap17 server. Local testing is the key.
travstatesmen, on Aug 23 2008, 10:20 AM, said:
is this "allowable CPU usage limit" measured at a peak point, or cumulatively over a period of time?
As far as I am aware, it is over a period of time. I have taken many backups and run slightly intensive tasks with no problems. The line is drawn on whether you start affecting other people. If you are causing problems for other people, and ruining their hosting service, then whatever process you're running will be stopped.
travstatesmen, on Aug 23 2008, 10:20 AM, said:
how am I supposed to preempt this limit, pre-calculating a particular action, before I exceed the limit?
Local testing is the key. There are tutorials on setting up Apache, PHP and MySQL locally on the forums, check the Tutorials section. Test your site locally, while monitoring the CPU and RAM usage. If your script causes a large spike then you'll need to fix it so that it is not so intensive.
travstatesmen, on Aug 23 2008, 10:20 AM, said:
Can you specify what exactly your definition of a "resource-intensive program" is, and give examples, so that I can avoid them?
Cron jobs running every few minutes (probably anything more often than once per hour). Sending many hundreds or thousands of emails at once, rather than spacing them out over time. Large SQL commands on poorly designed databases.
travstatesmen, on Aug 23 2008, 10:20 AM, said:
Also, as I have
posted elsewhere on your forums, I intend to make extensive use of the mySQL databases offered by Trap17 on my web hosting account, and I would like to know in advance if such intended use is going to violate your AUP.
Downloading, renaming and organising the SQL files would not be a problem. However, 6MB of SQL commands could take a large amount of processor time, especially if they are running as separate INSERT commands, as you seem to suggest. Running lots of these SQL files (for the multiple servers) would escalate the problem. I suggest trying your scripts locally and seeing what happens. Your hosting account shouldn't really be used as a test bed for something like this.
travstatesmen, on Aug 23 2008, 10:20 AM, said:
Would one of your Admins be prepared to set up a test to see whether my intended use of your services is likely to violate the rules? Perhaps the results of such a test could be used to advise me on the best solution that I could implement, such as possibly limiting the number of Travian servers that I try to keep track of using the map.sql data.
As I've suggested, test using a local running process of Apache, MySQL and PHP. There are tutorials here on the Trap17 forums detailing how to do this. If you're using Linux you just need to open your package manager and download the Apache2, MySQL5 and PHP5 packages, and they will be set up and configured for you.
travstatesmen, on Aug 23 2008, 11:16 AM, said:
I have a second, completely unrelated question, but which I would like to get answered before I apply for a hosting account please, so I thought I would just add it on here rather than opening a whole new thread. Below is a quote from somebody else's application for a web hosting account, but this looks like a standard reply...
I have been conscientious with my forum posting, and my wife is posting as well, raising our Hosting Credits. We currently have over 100 Credits, and were expecting to keep the remainder of them after activating the web hosting account (assuming that my application is successful). But from the message quoted above it seems that activating a web hosting account on Trap17 may cost more than the advertised 30 Hosting Credits, and we may lose many more Credits down to a "default amount". Is this the Trap in the Trap17 web hosting account application process?
This is pointed out in numerous places (for example,
here, linked from the Readme page), very clearly, that you should apply as soon as you have the 10/30 credits for the package you want, and that after you activate your account, you drop down to around 2 to 4 credits.