Welcome Guest
Catamaran Sailing at TheBeachcats.com Logo
Notifications
Clear all

Forum slower for anyone else?

85 Posts
26 Users
0 Reactions
27.4 K Views
(@jalani)
Posts: 1370
Member
 

Rolf,

I'll see your 4.455 secs and raise you:

Quote
Generated in 12.144 seconds in which 12.027 seconds were spent on a total of 11 queries. Zlib compression disabled.


 
Posted : December 11, 2005 4:37 pm
(@Anonymous 13024)
Posts: 4319
 

Dang, you win John!

Generated in 4.437 seconds in which 0.759 seconds were spent on a total of 14 queries. Zlib compression disabled.

Pretty responsive just now in fact..


 
Posted : December 11, 2005 4:45 pm
Rob Vaden
(@redtwin)
Posts: 510
Chief Registered
 

Generated in 1.32 seconds in which 0.754 seconds were spent on a total of 13 queries. Zlib compression disabled.

That is pretty much normal for me. I don't know what Knology is doing with their servers, but it's working for me.

-Rob V.
Nacra 5.2
Panama City


 
Posted : December 11, 2005 5:15 pm
(@dermot)
Posts: 807
Chief Registered
 

Generated in 0.748 seconds in which 0.605 seconds were spent on a total of 14 queries. Zlib compression disabled

So It's speeding up then


 
Posted : December 11, 2005 5:20 pm
scooby_simon
(@simonJlongstaff)
Posts: 3496
Captain Registered
 

Generated in 2.144 seconds in which 0.663 seconds were spent on a total of 14 queries. Zlib compression disabled.

So it's UBB/server (i.e. not the database engine) taking the time as I assume the 0.663 seoconds on 14 queries is getting returned from MySQL.


 
Posted : December 11, 2005 7:17 pm
Rob Vaden
(@redtwin)
Posts: 510
Chief Registered
 

Wow, check this one out!

Generated in -0.006 seconds in which 0.000 seconds were spent on a total of 13 queries. Zlib compression disabled.

I feel younger.

-Rob V.
Nacra 5.2
Panama City


 
Posted : December 11, 2005 8:44 pm
dartfast
(@dartfast)
Posts: 131
Mate Registered
 

5:46 am 2 registered 5 online. Found the rates at bottom of forum:
Generated in 20.439 seconds in which 19.467 seconds were spent on a total of 14 queries. Zlib compression disabled.

Then for message: much faster?
Generated in 0.523 seconds in which 0.069 seconds were spent on a total of 6 queries. Zlib compression disabled.
Whatever this means. Hope it helps.


 
Posted : December 12, 2005 6:12 am
scooby_simon
(@simonJlongstaff)
Posts: 3496
Captain Registered
 

Generated in 8.502 seconds in which 6.774 seconds were spent on a total of 14 queries. Zlib compression

T think we can all agree things are slooooooooooooow.


 
Posted : December 12, 2005 6:25 am
(@jalani)
Posts: 1370
Member
 

Yep, agreed:

Quote
Generated in 20.985 seconds in which 20.451 seconds were spent on a total of 35 queries. Zlib compression disabled.

PS. 2 registered and 18 guests online


 
Posted : December 12, 2005 6:49 am
(@Anonymous 38725)
Posts: 5859
 

I don't know what you guys are talking about but I do know this forum seems to lock up from time to time, won't open or opens very slowly. Other times it works great...
Is that due to heavy volume on the server?


 
Posted : December 12, 2005 8:38 am
(@flatlander)
Posts: 1108
Master Chief Registered
 

14 registered and 15 anonymous users are browsing this forum. Generated in 0.082 seconds in which 0.016 seconds were spent on a total of 6 queries. 8:34AM

Quote
I don't know what you guys are talking about

Timbo, Don't feel bad...I dont know either.


 
Posted : December 12, 2005 9:51 am
(@sparky)
Posts: 368
Mate Registered
 
Quote
Generated in 50.861 seconds in which 6.652 seconds were spent on a total of 13 queries. Zlib compression disabled.

A bit slow, 17 Registered and 20 Anonymous users!


 
Posted : December 12, 2005 10:01 am
(@Anonymous 13024)
Posts: 4319
 

Timbo: The numbers indicate that the server probably is overloaded at times. Some time it's the database backend that is slow, at other times it's the forum frontend that is slow.

E.g, my latest stats.

Generated in 12.99 seconds in which 0.013 seconds were spent on a total of 6 queries. Zlib compression disabled.

The database did its work fast, but the forum frontend which runs on the webserver (I suppose this forum runs on Apache and MySQL) used ~13 seconds to generate the page. Since it varies which subsystem is slow, I guess the server is bogged down doing something else. The question is what it is doing, as I dont see a influx of new users or increased activity.


 
Posted : December 12, 2005 10:04 am
(@Anonymous 38725)
Posts: 5859
 

Well where do you find these speed numbers and what's a Zlib? etc...?


 
Posted : December 12, 2005 10:16 am
(@Anonymous 13024)
Posts: 4319
 

You find them at the bottom of each page.

Zlib is just a software library for compression of e.g. data-streams from the web server to your browser. It's not in use on this server.


 
Posted : December 12, 2005 10:21 am
scooby_simon
(@simonJlongstaff)
Posts: 3496
Captain Registered
 

Generated in 31.768 seconds in which 30.974 seconds were spent on a total of 58 queries. Zlib compression


 
Posted : December 13, 2005 8:25 am
clarke
(@clarke)
Posts: 5
Member
 

It is a server load issue. I will discuss with Rick the options to speed things up. It is not any 1 particular subsystem, the site is just outgrowing the server.


 
Posted : December 13, 2005 10:24 am
(@edgarapoe)
Posts: 3222
Member
 

While we had the server down today, we added more ram to it. It now
has 1.25G of ram while before it only had 512Mb. This may help
mysql run more efficiently which may help the forum run better.
So far, it seems to be running with good speed again.
Enjoy,
Rick


 
Posted : December 16, 2005 9:36 am
(@sparky)
Posts: 368
Mate Registered
 

Thanks! The increased speed is DEEPLY appreciated!


 
Posted : December 16, 2005 9:40 am
scooby_simon
(@simonJlongstaff)
Posts: 3496
Captain Registered
 

Rick;

I don't think the problems were MySQL; I think it was UBB/PHP was the problem.

Quote
Generated in 5.982 seconds in [color] which 0.683 seconds were spent on a total of 14 queries . Zlib compression

So the query was taking 0.683 seconds but the processing of the results took the other 5.3 seconds.

So the extra ram will (maybe) helping in 2 ways

1, The resultset can be kept in Ram.
2, PHP results / arrays can also be lkept in ram.

Overall good (so far)


 
Posted : December 16, 2005 3:35 pm
scooby_simon
(@simonJlongstaff)
Posts: 3496
Captain Registered
 

just to add to the confusion, when logging this morning...

Quote
Generated in 68.282 seconds in which 66.965 seconds were spent on a total of 60 queries. Zlib compression disabled

Now (at the time) looked that MySQL was taking the time...


 
Posted : December 19, 2005 5:21 am
Tony_F18
(@Tony_FX1)
Posts: 2315
Captain Registered
 

Same here:

Quote
Generated in 20.559 seconds in which 19.61 seconds were spent on a total of 8 queries. Zlib compression disabled.

What are the specs for this server?


 
Posted : December 19, 2005 6:21 am
(@Anonymous 13024)
Posts: 4319
 

Generated in 9.441 seconds in which 0.67 seconds were spent on a total of 13 queries. Zlib compression disabled.

As it varies which subsystem are slow, there must be a lack of resources. Doubling the RAM to 1GB has improved the performance as I experience the forums. There are lots of things that can be done to tune a server and further improve it, but I think we should leave it to the sysadmin and Rick until they ask for ideas and tips (the linux geek factor is probably quite high on this forum).

What I have noticed, is that many of the anonymous users are reading quite old threads. I suppose they either find these threads trough search engines, or they perform searches locally on the server. Free text searches, as I suppose they are implemented in this forum, with mysql as a backend, can be quite resource intensive.
Personally, I found that turning off "View user's pictures with their posts?" under "Display" settings improved the performance.
I find the forums quite usable now, even if Simon posted a horrendous time yesterday.


 
Posted : December 19, 2005 6:52 am
scooby_simon
(@simonJlongstaff)
Posts: 3496
Captain Registered
 
Quote
Generated in 10.27 seconds in which 6.964 seconds were spent on a total of 14 queries. Zlib compression disabled.

Things are slowing down again!

It has been almost unusable this morning!


 
Posted : January 9, 2006 7:23 am
(@edgarapoe)
Posts: 3222
Member
 

I have had blazing speed lately, except once in a great while. Meanwhile, we are working on upgrading all of our boxes at the datacenter.
Whenever that happens you can expect very good speeds.
Rick


 
Posted : January 9, 2006 11:55 am
Page 3 / 3
Secret Link