So we have these google ads to pay for the expensive server... Am I the only one that had the central crap out VERY often? I get the database errors, and unresponding atleast 3 times a week. So with all the money comming in you would think a server with 99.9% up time would be in order...

my server for Skitstv.com transfers close to 10gb of video, 5gb of pics, and 3gb of misc stuff EVERY month and doesnt go down. And yet we dont CHARGE anything to ANYONE...


I understand the business aspect behind the centrals, but when more and more money is flowing in it seems like the stability of the server should go UP not down...

or is it just me?

i've never had a problem.
it could be a problem on YOUR side. you using IE, firefow? I use the older version of IE and never have a problem.

i meant firefox

Id rather wax my ballz than use ie Im using firefox Ill have to get some screen shots of the problems I get...

Must be something on your end, I havent had any problems in a long time.

As for your site comparison. You are comparing a static site with X number of visitors a month, to a highly dynamic site. Imagine 1000 users trying to drink out of the same cup of water at the same time. Thats effectively what happens when 1000 users access the forum at once. They all feed off of 1 database, and it takes a relatively powerful server to serve all those requests simultaneously. Bandwidth is cheap these days, unfortunately highend dedicated servers are not.

Yeah I got the red scrren that says the Board Administrator has issued flood control atleast 5 times when I get on here. Doesn't seem like it matters what time of the day it is either I always seem to get the error messages. Wonder if YFZ central and the other sites get this message?

I get what you are saying.. but the majority of the usage of the centrals is forum. and since you are not allowed to attach images the bandwidth is minimal. And if ALL the centrals are on ONE database, there are the problems... when we upload a new skit/episode we ALWAYS have atleast 3000 downloads in the first week. The smallest skit is 35mb and the smallest episode is 95mb. So I would say your straw theory doesnt really apply, I really think someone needs to shop around for the central networks...

I dont have this problem with ANY other site. But I am on this one the most so maybe thats why I see it so much...

I get that error too jet, but not nearly as often as the imb(?) database error

I dont think you fully understand what I was saying. Bandwidth is cheap. This site probably doesnt use a whole lot of bandwidth anyways, like your site does. A powerful server is need to run the database. There would be only 1 Database server running ALL of the central sites, each with their own set of tables. Concurrent databases connections take up a lot of RAM and CPU, which is expensive for dedicated servers. Your site does not have a large set of databases like the centrals do. It looks like you have a forum, but only 500 members, and probably nowhere near as active as this site, and a million miles away from the activity of ALL the central sites running off the SAME CPU and the SAME RAM. Understand what I mean now?



That error that JetTech is talking about is from trying to search more than once within like 20 or 30 seconds. This helps keep the load down on the server, minimizing RAM and CPU utilization. The error you're talking about Skits happens when too many people are browsing the forums. invision really sucks, it does about 5-8 queries every time you load up a topic. If 100 people all clicked at the same time, thats 500-800 queries all at once. You would need a very powerful server to be able to handle that many concurrent connections.

but the MAIN use of the database is when you search. Just reading and posting doesnt use squat for the resources. I do have a forum, not really though, and I did ALOT of research when getting our site up.

The fact remains that even with the traffic, four sites on one database(which is retarded, but saves money) the site should not have any problems. And if the server that the centrals are on isnt up to the task, then once again steve should be shopping for something else...

I think you are thinking about it too much with the way databases work, with the forums it is minimal without searching or images on the central sites...


and the error jet and I are talking about isnt the same as the multiple search error. it a "the database has been shut down for a bit" not "you can only search once every 30sec"

Yes, But it still queries the database. for instance, when you click a link to a topic here, it has a topic number. All the entries for that topic are stored in a table in the database. When you click that link, the PHP intepreter takes the various variables in the URI (the topic ID for instance) and performs a "search" of sorts. the table should be indexed on topic, so it should be relatively low overhead. The query string would be something like

SELECT * FROM tablename WHERE topicid = '%t'

A search would be very similar to this, the only difference is it what its searching on is not indexed. Something like this

SELECT topicid FROM tablename WHERE title LIKE 'yourquerystring'



All the sites run on the same dedicated server, there would be only one instance of the SQL server, with multiple child threads to handle concurrent connections. Its most likely a simple matter of tuning the server a bit to allow for more efficient usage. I do not actually know the specs of the server, so I couldnt really say its underpowered.



I know exactly how they work, LOL. I currently work as a Database Engineer and System Administrator.

JetTech was talking about the flood control thing I believe.

I never said you didnt know what you were talking about, I said you were over thinking it. Fact remains the money coming in vs the server cost should not equal a site that goes down as often as it does.

I guess I wouldnt have a problem with it so much if that stupid google avatar didnt say "these ads pay for our EXPENSIVE server". It should say, "Im human and enjoy more money over less money" then atleast its honest

I get the errors also at least one a day with ie
and only here
and i visit pirate4x4 with is by far bigger"at least i think" and get less errors there......

I spend a lot of time on this site, and haven't seen any DB errors in months.. Weird.

I haven't had issues since the recent polish job and upgrade. I use firefox on windblows and Linux. Both good.

z

The most users ever online was 412 over 2 years ago...

No where near 1000.

As for whatever this is about...I haven't had a problem in a LONG time, I'm using IE7.

well not to start any more crap but i had this happen

I guess FireFux..I MEAN, FireFox, isn't all it's cracked up to be

IE7 for about 7 months now, not a single problem

It was good until IE7 came out and dominated hahahaha

I haven't seen any problems in a long time either. I use IE6 and am on from 7 till 3:30 monday thru friday.

i get that too
sometimes every day for a week or not once during the week.
it comes and goes

I get that error alot aswell. But the error I was talking about getting alot is

thats the one i get. and only on this central forum.
everytime i see it i think the forum is being updated or something.
Is it because too many people go to look at it at the same time or what?

Guys, even if you hate IE, try it with the centrals if that happens.

I'm on here a lot and I haven't got one since Christmas...

Haven't read each and everyone's reply but I'm usually parked over on yfzcentral and between 11pm and midnight central time, I tend to call it the "witching hour'. Page loading is slow and I constantly get "the page cannot be displayed" message.

i have ie7 as well as firefox.
they both say the same thing

Let's see, you do 20 gigs of bandwidth a month. We do that in about 8 hours... We're just a tad more popular.

Invision board is NOT friendly to mysql. It has known problems, sadly. It gets better with each release though.

We're running on a dedicated server with these specs:

4 gigs of ram
Dual Core Dual Xenon 5110 Woodcrest
2x320 gb HDD's
1x320 gb HDD backup


And sometimes invision board takes a crap. The database then restarts itself and everything is fine in a few minutes. It happens.


It's a lot better than it was a few months ago. Things were REALLY bad then!

Backup time

I wanna see the stats for 20gb in 8hrs for the central sites... especially when you cant attach pics, unless your trying to throw in the videos to help your numbers... This isnt a popularity contest, read my post...

All of the sites are on the same server. But if you want just Z400Central figures, here they are. So instead of 8 hours (total server), Z400Central does what you do in a month in a little over 2 days.Click to view attachment

Your site also serves static content, which can be cached by browsers. dynamic content, like what is on this site, cannot be cached by the browser. So it has to be downloaded each and everytime someone visits the site. Or even a page on the site.

cool

LOL! I'm guessing 'cool' wasn't exactly the first thing you said...

why wouldnt you think it would take 20+ min for me to correct the spelling of cool?