Teh Lack of Speed

From: Wattsy (SLAYERPUNX) 3 Jul 2006 12:12
To: ALL1 of 72

I am finding teh forum pretty unusable of late. Is this a problem that I am having or are other forumites also having issues?

 

Its taken nearly 8 mins to open a single thread!

 

Bah I say BAH!

From: mr_swayzee 3 Jul 2006 12:17
To: Wattsy (SLAYERPUNX) 2 of 72

I have found it a bit slow of late, although not as slow as you say. It maybe took 30s or so to open this reply window with my 2mbps cable.

I had put it down to the fact that I am so rampantly downloading oodles of porn with soulseek all the time. could there be more to it?

From: Peter (BOUGHTONP) 3 Jul 2006 12:18
To: Wattsy (SLAYERPUNX) 3 of 72
Been relatively okay recently, not perfect but certainly not eight-minute-waiting.

Presumably you're not having problems with other pages though?

Tried using a different browser to access Teh?
From: steve 3 Jul 2006 12:24
To: Wattsy (SLAYERPUNX) 4 of 72
It is very very very slow, it'd be interesting to know if the wait is the server's harddrive racing away accessing the db, or just the connection.etc. It does seem like it'd be the former!
From: Peter (BOUGHTONP) 3 Jul 2006 12:27
To: steve 5 of 72
Light mode is okay. I jumped into full mode and it is slower.

Therefor I'd guess some sort of interface thing is causing the problems...
From: Wattsy (SLAYERPUNX) 3 Jul 2006 12:37
To: Peter (BOUGHTONP) 6 of 72

It seems from all the computer I use teh is very slow. I only use IE6 and IE7. I am strapped into a phat pipe here at work and have no problems what so ever with any other pages.

 

Its been like this for a while now but this is the first time I have moaned.

 

I blame the labour party and ebay.

From: mr_swayzee 3 Jul 2006 12:39
To: Wattsy (SLAYERPUNX) 7 of 72
I blame it on the boogie, and Canada.
From: Wattsy (SLAYERPUNX) 3 Jul 2006 12:45
To: mr_swayzee 8 of 72

It's not a real country anyway!

 


(and its speeded up a bit, has someone threatened the server?)

From: Stoo 3 Jul 2006 14:12
To: Wattsy (SLAYERPUNX) 9 of 72
I'm getting similarly horrible loading times - i'm averaging about 2 minutes per thread on the standard forum.

HOWEVER! I find that using the 'Light' version is relatively nippy - still slower than most other places, but it's definitely usable.

No problems with any other websites whatsoever, so i'm pretty sure it's not a problem my end.
From: Wattsy (SLAYERPUNX) 3 Jul 2006 14:15
To: Stoo 10 of 72

Its gone slow again now :(

 

Also

 

Where has LOST gone?

From: Stoo 3 Jul 2006 14:33
To: Wattsy (SLAYERPUNX) 11 of 72
Lost is where it's always been, as far as i'm aware:
http://www.yourlost.com/forum/
From: Wattsy (SLAYERPUNX) 3 Jul 2006 14:40
To: Stoo 12 of 72
How strange, my link doesn't work but yours did :|
From: Woggy 3 Jul 2006 14:59
To: ALL13 of 72

It's bloody terrible for me, from home and from work, so it isn't my connection (which is fast on other websites).

 

That's why I haven't posted much, I could make a cup of coffee waiting for threads to load.

 

EDIT: This just opened in another tab while I waited for this to post, 'Dictionary, Initialising'. So far it's been ages. Looks like it could be a spell checking problem?

 

http://www.tehforum.co.uk/forum/dictionary.php?webtag=DEFAULT&obj_id=t_content

EDITED: 3 Jul 2006 15:06 by WOGGY
From: Matt 3 Jul 2006 18:02
To: Woggy 14 of 72
It's not as simple as saying it's the dictionary causing the slowness.

But it is as simple as saying that this server can't cope.

Problem is when a query is performed the tables required are locked so no data can be inserted or modified at the same time. If the server is under load the query is going to take longer to perform due to lack of resources and because of the nature of PHP and MySQL if you get annoyed by the slowness and keep clicking links or refreshing pages trying to force it to load the page all you're doing is queuing up more queries for MySQL to execute and increasing the load on the server.

The thread list uses one of the most complex queries in Beehive so you can imagine what happens if you keep trying to refresh the thread list all the time.

It's not easy balancing the server performance between Apache and MySQL mostly because I haven't a clue how to set up MySQL to best suit our needs and searching for the right information reveals fuck all because all it's all along the lines of "try this" and "do that" without actually telling you what it does or why you should change it.

So yeah. Like it or lump it or we a) prune the database drastically or b) get together some money again to upgrade the hosting. We should probably do that again soon anyway as we'll need to be paying soon I would have thought.
From: Dave!! 3 Jul 2006 18:15
To: Matt 15 of 72

Could you give me details about how much load Beehive normally places on the server, how much bandwidth it uses etc?

 

Only our old server at work is being largely replaced within the next few weeks and the old one will be still hooked up and in use, but doing very little. There's a possibility of being able to use it to host Teh as well. I'd have to look into it though. Incidentally, the machine is a 1.13GHz PIII with 512MB RAM and is currently running Server 2000.

 

Like I say, no promises or anything, but it's a possibility! :)

From: Matt 3 Jul 2006 19:01
To: Dave!! 16 of 72

Bandwidth is about 4GB a month with compression on.
Load averages about 1.2 from what I can tell from 'top'.

 

Thanks for the offer but I don't think that machine would cope very well. Maybe if you quadruppled the RAM and upped the processor speed to about 3Ghz we'd stand a chance :)

From: Kriv 3 Jul 2006 19:11
To: Matt 17 of 72
Could there not be a teharchive database / forum set up. Dunno if it's easy or doable.
From: paul 3 Jul 2006 19:19
To: Kriv 18 of 72

I think I see what you're saying there, i.e. dump most of whats already 'archived' here to another place and reference it from here?

 

On the other hand, I would question whether we /really/ need to keep all the old posts?

 

Does anyone ever read them?

 

Are we just keeping them for the sake of keeping them?

 

Personally, I think pruning is the order of the day.

 

If someone cares enough to do a Kenny and dump everything into an 'attic' somewhere, all well and good, otherwise let it go...

 

:O)

From: Matt 3 Jul 2006 19:19
To: Kriv 19 of 72

It's a possibility.

 

To keep it as a database yet seperate from the live forum is going to mean it could potentially have the same impact on performance as we have with it remaining as it is now because we'd still have only the one MySQL server with the database it can't cope with. Unless the archive was moved to a different machine, which means paying for it and setting it all up seperatly, but making it read-only.

 

We could dump it to static HTML files and that has been talked about before but I would need help implementing that feature in Beehive and we'd have to have substantial downtime while the archive is created.

From: Matt 3 Jul 2006 19:28
To: paul 20 of 72

I'd have a problem with dumping it.

 

There is a massive amount of knowledge and wealth here. There are countless solutions to problems that people have had and some very interesting discussions that everyone should read at least once. There is no doubt also a lot of crap, but it would be a shame to loose all the good stuff just for the sake of keeping everything ship shape.

 

Recently we've been getting quite a few hits from search engines for people looking for solutions to their problems which is nice to see. Although I'm not sure how the managed to find us, because I've tried searching for things I know are here and we never show up, but they'er definitely finding us. I'd like to think the posts they find are useful as well.