PDA

View Full Version : Web administrator.... Web site SLOW ! Get rid of the bandwidth hogs

chief99
11-13-2005, 04:46 PM
Like pics and other bandwidth hogs that slow this website down after a big game.

Anyone else agree. Way to slow. It will go offline if we lose next week.
:banghead: :banghead: :banghead:
Mr. Laz
11-13-2005, 04:55 PM
would it help to turn off all avatars/attachments/ signatures on game day?

don't know if there's a main admin setting to turn them all off on game day... just a thought.
htismaqe
11-13-2005, 05:00 PM
I honestly don't think it would help.

I think the biggest problems is disk I/O or "hotspots" on the disks due to the database being screwed up...
BigRedChief
11-13-2005, 05:03 PM
The issue is not sigs or avatars or bandwidth. It's the database. Offers to help fix it abound but Austin Chief says he's got a handle on it.
|Zach|
11-13-2005, 05:11 PM
I think we should call Joe Valerio to help out.

Thats just me though.
chief99
11-13-2005, 05:19 PM
Vbulletin software reviews from users.

http://www.vbulletin.com/forum/archive/index.php/t-605.html

http://www.f5hosting.com/forums/archive/index.php/t-235.html
htismaqe
11-13-2005, 05:23 PM
Vbulletin software reviews from users.

http://www.vbulletin.com/forum/archive/index.php/t-605.html

http://www.f5hosting.com/forums/archive/index.php/t-235.html

What's your point?

We already know why it's slow.
|Zach|
11-13-2005, 05:24 PM
It is a database issue...
Phobia
11-13-2005, 05:24 PM
Vbulletin software reviews from users.

http://www.vbulletin.com/forum/archive/index.php/t-605.html

http://www.f5hosting.com/forums/archive/index.php/t-235.html

Thank you for the 4 year old information regarding vBull 1.1.

That was helpful. Heh heh.

Yeah the site is slow. I don't know what to tell you.
|Zach|
11-13-2005, 05:25 PM
Everytime I read an opinion of Chief99's its wrong. Even though its an opinion...

Its an amazing accomplishment.
chief99
11-13-2005, 05:26 PM
MySQL ?
Phobia
11-13-2005, 05:29 PM
MySQL ?

Yes. Is that a question? Have I answered it?
chief99
11-13-2005, 05:43 PM
Graphics = bandwidth hog.

There is nothing to figure out.

It's not your database. Think.
|Zach|
11-13-2005, 05:44 PM
Graphics = bandwidth hog.

There is nothing to figure out.

It's not your database. Think.Dude, you are wrong. There have been people desling with this issue for a long time.

We really appreciate the tech advice from some board from 1995 though.
htismaqe
11-13-2005, 05:46 PM
Graphics = bandwidth hog.

There is nothing to figure out.

It's not your database. Think.

You don't even know what you're talking about. The server isn't connected to the Internet with a 56k dialup line.

The server has more than enough bandwidth for graphics.
chief99
11-13-2005, 05:48 PM
Long time and never figured it out ?

There is nothing unique about the problem. Having alot of users at one time slows every website.

Most of the time it's just people loading up bandwidth hogging graphics/icons/avatars.
htismaqe
11-13-2005, 05:51 PM
Long time and never figured it out ?

There is nothing unique about the problem. Having alot of users at one time slows every website.

Most of the time it's just people loading up bandwidth hogging graphics/icons/avatars.

The database is poorly organized, bloated, and corrupted. The server has IDE drives.

The only waste of bandwidth here is you going on about something that you have no clue about.
siberian khatru
11-13-2005, 05:52 PM
The only waste of bandwidth here is you going on about something that you have no clue about.

There's a drive, DEEP to right field, a WAAAAY back ...
chief99
11-13-2005, 06:01 PM
The database is poorly organized, bloated, and corrupted. The server has IDE drives.

The only waste of bandwidth here is you going on about something that you have no clue about.

Prove it to me dickhead.

Turn off all the graphics.


ROFL
chiefsfan58
11-13-2005, 06:02 PM
Random q's for whoever runs the DB...

1) are you using InnoDB or MyISAM tables?

2) what are the specs on the box (ram/proc/hd setup)

3) have you guys tingered with cache settings (i.e. memory allocated to cache, maybe even custom cache algorithms!)?
Rausch
11-13-2005, 06:05 PM
Like pics and other bandwidth hogs that slow this website down after a big game.

Anyone else agree. Way to slow. It will go offline if we lose next week.
:banghead: :banghead: :banghead:

*click*

"I'm sorry, the Web administrator is not in right now, if you'd like to leave a message go dip yer' hand in jalapeno juice and fist yourself.....after the beep..."

*beeeeeeeeeeep*
chiefs4me
11-13-2005, 06:07 PM
Graphics = bandwidth hog.

There is nothing to figure out.

It's not your database. Think.








think...think....ROFL oh you have done it now, skip should be around shortly to tell you just exactly how to think...:p
htismaqe
11-13-2005, 06:08 PM
Prove it to me dickhead.

Turn off all the graphics.


ROFL

How about I just ban you instead. That should free up some bandwidth.
Valiant
11-13-2005, 06:09 PM
The database is poorly organized, bloated, and corrupted. The server has IDE drives.

The only waste of bandwidth here is you going on about something that you have no clue about.


If I did graphics with catchy phrases to certain people...

Yours would "ohhh, snap...."
chief99
11-13-2005, 06:10 PM
Random q's for whoever runs the DB...

1) are you using InnoDB or MyISAM tables?

2) what are the specs on the box (ram/proc/hd setup)

3) have you guys tingered with cache settings (i.e. memory allocated to cache, maybe even custom cache algorithms!)?


They said basically that they don't know what they're doing.

They said they had the problem a long time and had someone offer to fix it.

They are definitely clueless.
|Zach|
11-13-2005, 06:11 PM
They said basically that they don't know what they're doing.

They said they had the problem a long time and had someone offer to fix it.

They are definitely clueless.You really...do not know what you are talking about.

Who is clueless...you advice was based on posts from a message board VB 1.1
Rausch
11-13-2005, 06:15 PM
They said basically that they don't know what they're doing.

They said they had the problem a long time and had someone offer to fix it.

They are definitely clueless.

Your knowledge of the situation is-....screw it.

You're starting to piss me off and I need an outlet for my frustrations.
chiefsfan58
11-13-2005, 06:16 PM
Hahah, well, I know quite a bit about MySQL optimization/tweaking, but if they don't want/need help, whatever. =p
htismaqe
11-13-2005, 06:18 PM
They said basically that they don't know what they're doing.

They said they had the problem a long time and had someone offer to fix it.

They are definitely clueless.

OK, at first I was making fun of you. Now I'm serious.

You have absolutely no idea what you are talking about. The person that OWNS this bulletin board knows what the issue is. There have been several offers to fix it, but until this point, that person has opted to work on it in their spare time.

If you don't shut up, I'll ban you.
chief99
11-13-2005, 06:21 PM
Chiefsfan58.

Removal of graphic loading from the website would reduce the bottleneck. Just have the graphics/icons/avatars loaded from another website.

Simple solution really.
SPchief
11-13-2005, 06:24 PM
dude just stop while you're ahea..

uh just stop
Rausch
11-13-2005, 06:24 PM
OK, at first I was making fun of you. Now I'm serious.

You have absolutely no idea what you are talking about. The person that OWNS this bulletin board knows what the issue is. There have been several offers to fix it, but until this point, that person has opted to work on it in their spare time.

If you don't shut up, I'll ban you.

Did you offer to buy him an XServe?... :evil:
chief99
11-13-2005, 06:24 PM
OK, at first I was making fun of you. Now I'm serious.

You have absolutely no idea what you are talking about. The person that OWNS this bulletin board knows what the issue is. There have been several offers to fix it, but until this point, that person has opted to work on it in their spare time.

If you don't shut up, I'll ban you.


Maybe you don't know what your talking about.
Valiant
11-13-2005, 06:27 PM
I do not think anybody will actually miss him...

Let me try and explain it to you since you are a retard...

1. They know the problem, but the owner will not let them work on it..

2. The owner of said website wants to do it on his own..

3. You are a tool...
go bo
11-13-2005, 06:31 PM
i don't know about phobia, but i've been tingering every chance i get...
chief99
11-13-2005, 06:32 PM
I do not think anybody will actually miss him...

Let me try and explain it to you since you are a retard...

1. They know the problem, but the owner will not let them work on it..

2. The owner of said website wants to do it on his own..

3. You are a tool...


Reread previous messages.

The bottleneck occurs when too many are on at the same time loading up graphics -which are bandwidth hogs.

There is no problem with the database.
|Zach|
11-13-2005, 06:32 PM
i don't know about phobia, but i've been tingering every chance i get...Where have you been old man?
chiefsfan58
11-13-2005, 06:34 PM
Chiefsfan58.

Removal of graphic loading from the website would reduce the bottleneck. Just have the graphics/icons/avatars loaded from another website.

Simple solution really.

LOL... that's not the problem. It's most likely the need to preform joins across multiple tables (ie. the user table, the thread table, etc.) for hundreds of users at the same time. I'd have to see the stats on the ratio of SELECT queries to UPDATES/INSERTS to determine if the type of table is hurting perf.

Sticking some more memory in and allocating more memory to the cache never hurts (tables in RAM >>> tables on HD). If there's enough RAM, disk i/o becomes a non-issue. Even if all tables can't be held in RAM, writes to the DB can be made to a log file (so writes are sequential rather than random) and then commited off a log file at a later time.
htismaqe
11-13-2005, 06:37 PM
LOL... that's not the problem. It's most likely the need to preform joins on multiple tables (ie. the user table, the thread table, etc.) for hundred s of users at the same time. I'd have to see the stats on number of the ratio of SELECT quries to UPDATES/INSERTS to determine if the type of table is hurting perf.

Sticking some more memory in and allocating more memory to the cache never hurts. If there's enough RAM, disk i/o becomes a non-issue, especially if writes to the DB are made to a log file (so writes are sequential rather than random) and then commiting the changes off a log file at a later time can boost performance significantly if disk i/o is the bottleneck.

Oh dude, you're dumb. It's the graphics. Quite simple.
Valiant
11-13-2005, 06:39 PM
Reread previous messages.

The bottleneck occurs when too many are on at the same time loading up graphics -which are bandwidth hogs.

There is no problem with the database.


Except for the fact that the mods and other techs have said it was something else... The point of you saying it is something else, and then backing up your statement with info that does not pertain has no merit...
chiefsfan58
11-13-2005, 06:40 PM
Oh dude, you're dumb. It's the graphics. Quite simple.

Damn it, disable graphics already. :cuss:
Rausch
11-13-2005, 06:41 PM
I'll ask Taco, that guy has an up to date, kick azz site.

There seems to have been a problem with the database.
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.

We apologise for any inconvenience.

Nevermind...
StcChief
11-13-2005, 06:58 PM
It's still the database post table. So all worthless POS posts do is add rows to a MySQL database that is questionable at best.
go bo
11-13-2005, 06:59 PM
Where have you been old man?tingering, of course...
chiefs4me
11-13-2005, 07:00 PM
I'll ask Taco, that guy has an up to date, kick azz site.



Nevermind...







ROFL
teedubya
11-13-2005, 07:11 PM
wow, with Chef99 banned... it is amazingly faster.
Mr. Laz
11-13-2005, 07:14 PM
Random q's for whoever runs the DB...

1) are you using InnoDB or MyISAM tables?

2) what are the specs on the box (ram/proc/hd setup)

3) have you guys tingered with cache settings (i.e. memory allocated to cache, maybe even custom cache algorithms!)?
This guy uses big words, i vote for him to attack the database issue.
milkman
11-13-2005, 07:17 PM
Ban all the noobs, that'll fix the problem.
go bo
11-13-2005, 08:01 PM
hey, catlady...

how's it going on this lovely sunday evening?
go bo
11-13-2005, 08:03 PM
wow, with Chef99 banned... it is amazingly faster.ROFL
the Talking Can
11-13-2005, 08:06 PM
I'll ask Taco, that guy has an up to date, kick azz site.



Nevermind...
ROFL

shit, need some laughter...to keep me from killing
Saulbadguy
11-14-2005, 06:32 AM
Hah..another classic Warpaint99 thread.
Eleazar
11-14-2005, 06:46 AM
No d00d! It's teh grafix!!!!11

ROFL
htismaqe
11-14-2005, 08:36 AM
Hah..another classic Warpaint99 thread.

Holy crap, I gotta stop drinking after a Chiefs loss. I was in a really bad mood last night.

And I never made the connection between chief99 and warpaint99 until this morning...

:shake:
Saulbadguy
11-14-2005, 09:08 AM
Holy crap, I gotta stop drinking after a Chiefs loss. I was in a really bad mood last night.

And I never made the connection between chief99 and warpaint99 until this morning...

:shake:
Heh. Same posting style and everything. Did "Ninjaman" get banned? That is an ID of his as well.