server response

arnisador

Sr. Grandmaster
MTS Alumni
Joined
Aug 28, 2001
Messages
44,573
Reaction score
456
Location
Terre Haute, IN
Thanks for trying Kaith! I am still seeing some timeouts on MT but not having trouble elsewhere on the web.
 

Bob Hubbard

Retired
MT Mentor
Founding Member
Lifetime Supporting Member
MTS Alumni
Joined
Aug 4, 2001
Messages
47,245
Reaction score
772
Location
Land of the Free
Well, some is better than alot.
I'm seeing a few 25 second page loads, most seem within 3-6 seconds.
I've split log processing into 2 batches as the log files get rather large transfering 3+ gigs a day.
 

Bob Hubbard

Retired
MT Mentor
Founding Member
Lifetime Supporting Member
MTS Alumni
Joined
Aug 4, 2001
Messages
47,245
Reaction score
772
Location
Land of the Free
I'm going to do everything I can with this server. I can't afford to move to the next level up. This ones costing $255/month. Next server level is about $400/month.
 

arnisador

Sr. Grandmaster
MTS Alumni
Joined
Aug 28, 2001
Messages
44,573
Reaction score
456
Location
Terre Haute, IN
That's a lot of cash. Did you tell them that MartialTalk performs a great public service? Maybe they'll cut you a break. :D

By the way, you should be in bed by now.
 

Bob Hubbard

Retired
MT Mentor
Founding Member
Lifetime Supporting Member
MTS Alumni
Joined
Aug 4, 2001
Messages
47,245
Reaction score
772
Location
Land of the Free
Hmm...I remember that 'sleep' concept. Been a while.

A site at our size/traffic should be on a different configuration (bit technical, involves 3 servers) thats, well, outside our budget at the moment. I keep playing the lottery though. :D
 

Bob Hubbard

Retired
MT Mentor
Founding Member
Lifetime Supporting Member
MTS Alumni
Joined
Aug 4, 2001
Messages
47,245
Reaction score
772
Location
Land of the Free
ok, 4 outta 5 major optimizations are in place. Please let me know if things are better.
 

Andrew Green

Grandmaster
MTS Alumni
Joined
Aug 1, 2004
Messages
8,627
Reaction score
452
Location
Winnipeg MB
Where is the speed lose?

I'm guessing database look ups?

or is it transfer.... Over half a mb on the main page gets displayed...
 

Bob Hubbard

Retired
MT Mentor
Founding Member
Lifetime Supporting Member
MTS Alumni
Joined
Aug 4, 2001
Messages
47,245
Reaction score
772
Location
Land of the Free
Pretty much. We're doing about 80,000 pages and 3GB a day in traffic.
What we did so far is upgrade PHP, and put in a number of MySQL config changes, and a few other tweaks.
 

Andrew Green

Grandmaster
MTS Alumni
Joined
Aug 1, 2004
Messages
8,627
Reaction score
452
Location
Winnipeg MB
pretty much which... database or transfer?

Huge database getting queried that much is gonna slow things, as is transferring that much data. Maybe reducing the amout of data that actually gets sent as well?

Or cutting back how many queries need to be run to display the slower pages? (Show less stuff) even the html file that gets created on the main forum page is 165kb, and that has to get rebuilt and resent everytime.... Sure raises pity for anyone still on dial up...
 

Bob Hubbard

Retired
MT Mentor
Founding Member
Lifetime Supporting Member
MTS Alumni
Joined
Aug 4, 2001
Messages
47,245
Reaction score
772
Location
Land of the Free
Database look ups.
Apache is hardly ticking at the moment.
Main forum page is a little graphically heavy, as well as text heavy. About the only 'bloat' graohically are sponsor banners. Lose those, lose the site. The text I might be able to save a few kb on, but the cost would be indexability on search engines. I'll be doing a detailed analysis of the logs in a few days, and trying to do some load-balancing on the more intensive sections.
 

bignick

Senior Master
MTS Alumni
Joined
Jul 30, 2004
Messages
2,892
Reaction score
38
Location
Twin Cities
I just always go straight to the forum page

http://martialtalk.com/forum/index.php

Instead of navigating fromt he main page...probably saves some bandwidth...although that script i've got running that opens a new browser to the martial talk site every 30 seconds probably doesn't help.......
 

arnisador

Sr. Grandmaster
MTS Alumni
Joined
Aug 28, 2001
Messages
44,573
Reaction score
456
Location
Terre Haute, IN
I usually go through the main page first, but if I have trouble loading it I go to the forum page. I should probbaly do as you're doing.
 

Andrew Green

Grandmaster
MTS Alumni
Joined
Aug 1, 2004
Messages
8,627
Reaction score
452
Location
Winnipeg MB
bignick said:
I just always go straight to the forum page

http://martialtalk.com/forum/index.php

That's the big one ;)

Other pages don't seem terribly slow, but loading up the main forum page always has some lag to it.

As for the MySQL, I'm assuming you've optimized all the tables? The server is stripped of all unneeded processes? (ex it isn't running "X" or anything else that shouldn't be there)

Maybe removing some of the unneeded queries, things like getting rid of the "Who's Online" on all pages except the "who's online" page.

If the banner ads are being pulled out of a database, or more likely the locations and links maybe get them out of there into a php file...

Damn... this thread probably has a high geekiness rating...
 

Bob Hubbard

Retired
MT Mentor
Founding Member
Lifetime Supporting Member
MTS Alumni
Joined
Aug 4, 2001
Messages
47,245
Reaction score
772
Location
Land of the Free
Servers optimized for MT. Anything MT doesn't need, is being removed. :)

I streamlined a few of the queries as well. We lose alphabetical 'who's been here' listings, but I think we can live. :)

Banners are straight html links. I'm going to see if I can shrink a few kb out of the load size as well.

I'm still seeing an occational hiccup, but in the last 14 hours, there have only been 20 sql errors recorded, so, we're making progress.

:)
 

bignick

Senior Master
MTS Alumni
Joined
Jul 30, 2004
Messages
2,892
Reaction score
38
Location
Twin Cities
Andrew Green said:
Damn... this thread probably has a high geekiness rating...

Maybe that should be a new board feature...check the geekiness rating of each thread before you click...
 

Latest Discussions

Top