MYSQL Server Monitor

[Jackolantern]

Yeah, my understanding is that those figures are just from MySQL. Like Halls said, I don't think you could run up 30 gigs of MySQL data in a decade, much less in one day. Once you add in the HTML pages, images, videos, etc., then yes, 30 gigs will go pretty fast. But those figures are being pulled out of MySQL concerning MySQL activity.

[jpoisson]

Halls I was referring to overall bandwidth transfer including images etc. as for queries i have no clue. of course it isnt anything near that but as for global site data transfer 30gbs is pretty reasonable for a game.

[hallsofvallhalla]

not for a web game, that is still outrageous!

All my websites put together, Indie-Resource, Forsaken Sanctum, My family's video sharing site, Forsaken Sanctum web game 1.0,Forsaken Sanctum web game 2.0, Planetary Wars, Games Guild Studios, and a few other small things all used 1 gig in the past 7 days!!! Thats with 100,000 requests

The 2 year total is 64 gigs! Thats with several million requests.

If you are using 30 gigs in 2 days you will never find a host to support that.

Now if you have some large pictures and you are just non stop battling then I would recommend finding a way to size down the pics.

[jpoisson]

lets say including images for a battle the total process is 200kb (source code, images, etc.) if each person fights over 1000 fights a day, (back when spam battling was allowed)...

that is 200mb a day a person. just from battling. The most I have had was 500 players in one month active. with roughty 700 - 1500 battles a day.

so lets average it out to 200mb a day per player for 500 players that is 8gb a day, now lets keep that for a daily average of 20days a month of full activity that is roughly 160gb of data transfer.

that is just my rough figures.

[Jackolantern]

If you are using 30 gigs in 2 days you will never find a host to support that.

Errr...that is 450gigs a month at that rate. Your host, GoDaddy.com would give you 3x that amount for $6.99 a month.

Bandwidth is not a huge issue these days. Unmetered services are abundant, and typically only require you to stay within certain terms of usage rather than within an amount of bandwidth. I actually called GoDaddy, and their $14.99 per month unlimited plan is completely unmetered (I even asked them if you went as high as 100TB of transfer, and Daniel over there said it would be no problem). They seemed a tad more concerned with the amount of storage space, as they have special terms regarding that it is subject to availability on a single server, which is of course shared with other applications. So bandwidth doesn't seem to be a huge issue as long as you are willing to pay about as much as you would for an MMO subscription per month. Now if you started to use a ton of the server's resources, you would likely need to get a virtual server or a dedicated server, but we would still be talking under $100 per month.

EDIT: Now if we are talking about free web hosting, almost anything above casual storage and transfer will be a problem, but hosting fees are so low these days almost anyone should be able to afford it. If you are wanting to start a commercial game, it is best to invest at least enough for a commercial host.

[hallsofvallhalla]

i guess i should have re-worded that. You will not find a host to be able to move that kind of data fast enough for a game. It will be slow. You would have to get a virtual server.

[Jackolantern]

i guess i should have re-worded that. You will not find a host to be able to move that kind of data fast enough for a game. It will be slow. You would have to get a virtual server.

Now that may be an issue. I guess really the only solution is to deploy to a test server and start doing test and optimization cycles until it gets to a workable level, assuming that load times could get as high as 4x what your tests show (different user download speeds, geography, network latency, etc.).

I have seen quite a few games that had very slow load times, and if the game requires lots of fast page loads, it can be quite frustrating.

[Torniquet]

another thing you really aught to look @ is the specs of the server... would 256mb ram really hold out well on a game?

[Jackolantern]

256mb is awfully low. Is that with GoDaddy, or another host? I have never really seen anything offered under 1gb.

[Torniquet]

well the average i see is 512-1024... and yes the 256 is with go daddy.

im lookin at http://www.cloudnext.com/vds/ prob go with the value server of £9.99 a month n could add an extra 2gb of ram + another proccessor for the same as their next offer lol. that is providing they can do what i want them to do, crons, able to read and write db from one server to another. but i would imagine i should be able to seein as they offer full admin/root access. HDD space im not overly concerned about as atm my folder is still under 2mb lol

i have also emailed them about the 'unmetered' bandwidth