Forum hanging up

General forum information, announcements, news, questions and suggestions.
User avatar
rick752
Honorary Member
Honorary Member
Posts: 4508
Joined: Fri Dec 30, 2005 1:02 am
Location: New York, USA

Forum hanging up

Post by rick752 »

Is it something wrong on my end or is the forum hanging up or not responding lately?

ps: I waited 3 minutes for this post to go up and nothing! I hope it goes up eventually :cry:
"Experience is something you don't get until just after you need it"
User avatar
chewey
Emeritus Contributor
Emeritus Contributor
Posts: 276
Joined: Sun Dec 31, 2006 9:16 am

Post by chewey »

Yes, there's something strange going on. It's vereeeeeeey sluggish on my end too.
IceDogg
Contributor
Contributor
Posts: 580
Joined: Tue Mar 21, 2006 9:50 pm

Post by IceDogg »

Yep, same here for a few days now. 3rd..ed.
User avatar
orph4824
Emeritus Contributor
Emeritus Contributor
Posts: 25
Joined: Sun Sep 23, 2007 12:13 am
Location: Greeneville, TN

Post by orph4824 »

Trace/Ping seems to be fine believe something is wrong with the database serverside

Code: Select all

Tracing route to 65-254-250-101.yourhostingaccount.com [65.254.250.101]

1 <1 ms <1 ms <1 ms wrt55ag [xx.x.x.xxx]
2 1 ms <1 ms <1 ms eq-660r [xx.x.x.xxx]
3 8 ms 8 ms 7 ms gateway [xx.x.xxx.xxx]
4 7 ms 8 ms 8 ms tn-76-5-159-229.sta.embarqhsd.net [76.5.159.229]
5 39 ms 38 ms 39 ms sl-gw21-atl-6-2.sprintlink.net [160.81.212.29]
6 39 ms 38 ms 39 ms sl-bb20-atl-5-0.sprintlink.net [144.232.12.109]
7 43 ms 43 ms 43 ms sl-bb25-rly-3-0.sprintlink.net [144.232.20.175]
8 43 ms 43 ms 44 ms sl-bb24-rly-12-0.sprintlink.net [144.232.14.149]
9 45 ms 44 ms 53 ms sl-st22-ash-6-0.sprintlink.net [144.232.20.189]
10 45 ms 46 ms 49 ms te-4-2.car4.Washington1.Level3.net [4.68.111.169]
11 52 ms 54 ms 53 ms vlan89.csw3.Washington1.Level3.net [4.68.17.190]
12 53 ms 52 ms 54 ms ae-84-84.ebr4.Washington1.Level3.net [4.69.134.185]
13 59 ms 51 ms 53 ms ae-3.ebr4.NewYork1.Level3.net [4.69.132.94]
14 55 ms 54 ms 52 ms ae-94-94.csw4.NewYork1.Level3.net [4.69.134.126]
15 57 ms 53 ms 52 ms ae-91-91.ebr1.NewYork1.Level3.net [4.69.134.77]
16 54 ms * 54 ms ae-5-5.car2.Boston1.Level3.net [4.69.132.249]
17 59 ms 54 ms 55 ms RCN-CORPORA.car2.Boston1.Level3.net [4.79.2.94]
18 53 ms 58 ms 54 ms ge5-1.aggr2.sbo.ma.rcn.net [207.172.15.152]
19 55 ms 55 ms 55 ms 207.172.31.46
20 57 ms 58 ms 56 ms 3.225.148.207.static.yourhostingaccount.com [207.148.225.3]
21 55 ms 54 ms 54 ms 65-254-250-101.yourhostingaccount.com [65.254.250.101]

Trace complete.
Life's 3 rules: 1. Stuff happens 2. Stuff happens on a regular basis 3. Better get used to the first two... (not the actual saying but you get the drift)
User avatar
rick752
Honorary Member
Honorary Member
Posts: 4508
Joined: Fri Dec 30, 2005 1:02 am
Location: New York, USA

Post by rick752 »

I tried purging the cache a couple of times earlier but it took forever ... don't know if it worked correctly.

This time it did it much more normally .... and immediately the whole forum sped up to almost normal again here.

I wonder if it is a cache overload problem. Is there a way to limit the cache or auto-clear it at certain intervals?
"Experience is something you don't get until just after you need it"
User avatar
rick752
Honorary Member
Honorary Member
Posts: 4508
Joined: Fri Dec 30, 2005 1:02 am
Location: New York, USA

Post by rick752 »

It's still working a bit erratic but at least it doesn't seem to be totally non-resonsive like it's been the past couple of days. This definitely looks like a server-side hiccup.
"Experience is something you don't get until just after you need it"
User avatar
orph4824
Emeritus Contributor
Emeritus Contributor
Posts: 25
Joined: Sun Sep 23, 2007 12:13 am
Location: Greeneville, TN

Post by orph4824 »

I'm using pHpBB3 on my server dont have many users on it but ill look thru and see if I can find any cache settings
Life's 3 rules: 1. Stuff happens 2. Stuff happens on a regular basis 3. Better get used to the first two... (not the actual saying but you get the drift)
User avatar
rick752
Honorary Member
Honorary Member
Posts: 4508
Joined: Fri Dec 30, 2005 1:02 am
Location: New York, USA

Post by rick752 »

Never mind. It is an intermittent problem. Trying to get here from the email notification took a minute or so. This problem comes and goes. Clearing the cache might have helped, but it is not the problem.
"Experience is something you don't get until just after you need it"
User avatar
orph4824
Emeritus Contributor
Emeritus Contributor
Posts: 25
Joined: Sun Sep 23, 2007 12:13 am
Location: Greeneville, TN

Post by orph4824 »

Oh ok just trying to help if I can :P I ever set mine up to use a self-signed SSL.
Life's 3 rules: 1. Stuff happens 2. Stuff happens on a regular basis 3. Better get used to the first two... (not the actual saying but you get the drift)
User avatar
LanikSJ
Site Owner
Site Owner
Posts: 1806
Joined: Thu Feb 15, 2007 7:44 am
Location: /dev/null

Post by LanikSJ »

Thats Powweb for you they stink. :( Its worse for me since I gotta go across country to get there. I get quite a few time outs myself, unfortunately its related to their server I don't think there is anything I can do about it.
"If it ain't broke don't fix it."
User avatar
LanikSJ
Site Owner
Site Owner
Posts: 1806
Joined: Thu Feb 15, 2007 7:44 am
Location: /dev/null

Post by LanikSJ »

I logged into SQL and trimmed the fat sorta speak out of the DB. Before it was 20mb+ now its a little over 12mb so that might help speed things along. I can tell its a little bit faster already. I also upped the amount of memory the scripts can use to 40mb a script and increased the time outs.
"If it ain't broke don't fix it."
User avatar
rick752
Honorary Member
Honorary Member
Posts: 4508
Joined: Fri Dec 30, 2005 1:02 am
Location: New York, USA

Post by rick752 »

Wow Lanik.

That seemed to make a BIG difference so far :D
"Experience is something you don't get until just after you need it"
IceDogg
Contributor
Contributor
Posts: 580
Joined: Tue Mar 21, 2006 9:50 pm

Post by IceDogg »

I agree it's been much much better. Thanks!
User avatar
orph4824
Emeritus Contributor
Emeritus Contributor
Posts: 25
Joined: Sun Sep 23, 2007 12:13 am
Location: Greeneville, TN

Post by orph4824 »

Lanik, on mine back when we first had those inital install issues i bumped mine upto 64mb if memory serves default was set at 16mb or 20mb, 64mb out of 2gb aint much to miss :D
Life's 3 rules: 1. Stuff happens 2. Stuff happens on a regular basis 3. Better get used to the first two... (not the actual saying but you get the drift)
User avatar
LanikSJ
Site Owner
Site Owner
Posts: 1806
Joined: Thu Feb 15, 2007 7:44 am
Location: /dev/null

Post by LanikSJ »

If it was my server I would bump it to 64mb no problem I might just do that out of spite Powweb is starting to get on my nerves already.
"If it ain't broke don't fix it."
User avatar
chewey
Emeritus Contributor
Emeritus Contributor
Posts: 276
Joined: Sun Dec 31, 2006 9:16 am

Post by chewey »

Lanik wrote:If it was my server I would bump it to 64mb no problem I might just do that out of spite Powweb is starting to get on my nerves already.
heh :-)

Don't they limit that somewhere?
And if they do, going for the limit would be entirely OK, wouldn't it?

It might not be necessary though, it works fine again on my end too.
User avatar
LanikSJ
Site Owner
Site Owner
Posts: 1806
Joined: Thu Feb 15, 2007 7:44 am
Location: /dev/null

Post by LanikSJ »

Yes from what I can tell its limited in php.ini file, I can edit it and set the size to whatever I desire. I have no idea what the limit is and I'm afraid to set it too high and have something crash, so I guess we'll play it by ear and if it gets worse I'll up the memory limit per script to 64 the default is pitiful 16.
"If it ain't broke don't fix it."
User avatar
rick752
Honorary Member
Honorary Member
Posts: 4508
Joined: Fri Dec 30, 2005 1:02 am
Location: New York, USA

Post by rick752 »

I guess you found the problem, Lanik :D

The forum seems to be working FLAWLESSLY since you made that adjustment ... congrads! Good job :mrgreen:
"Experience is something you don't get until just after you need it"
User avatar
LanikSJ
Site Owner
Site Owner
Posts: 1806
Joined: Thu Feb 15, 2007 7:44 am
Location: /dev/null

Post by LanikSJ »

Thanks I've stumbled onto something interesting. Powweb uses phpMyAdmin 2.8.0 and its god damn slow POS. I was reading their forums and they are suggesting using MQA (MySQL Quick Admin) http://www.mysqlquickadmin.com I've installed it and it works very good so far I like it. Now I don't have to go through gazillion menus just to get the my DB. :)
"If it ain't broke don't fix it."
User avatar
rick752
Honorary Member
Honorary Member
Posts: 4508
Joined: Fri Dec 30, 2005 1:02 am
Location: New York, USA

Post by rick752 »

It's back to being "on or off" here again. It seems to be a database problem more than a connection problem.

The way it seems to happen is that it DOES connect to the host ok .... it just freezes up when the database is trying to be called. I'm not sure what the problem would be as I am not an expert in this field by any means. It seems to be an intermittent problem in calling the db though ... not the site itself.
"Experience is something you don't get until just after you need it"
User avatar
rbsterli
Senior Member
Senior Member
Posts: 63
Joined: Thu Dec 29, 2005 11:21 pm
Location: Selkirk, N.Y. USA

Post by rbsterli »

I used to run check, optimize and repair tables from right within phpMyAdmin. You can always give that a shot and see if it helps. For 2x I had the maintenance mod, I don't remember for sure but I thought phpBB3 has the maintenance mod built into the ACP.
User avatar
LanikSJ
Site Owner
Site Owner
Posts: 1806
Joined: Thu Feb 15, 2007 7:44 am
Location: /dev/null

Post by LanikSJ »

Thats what I usually do is login to phpMyAdmin and optimize all rows. That fixes things for a little while but it will be slow again later on.
"If it ain't broke don't fix it."
User avatar
chewey
Emeritus Contributor
Emeritus Contributor
Posts: 276
Joined: Sun Dec 31, 2006 9:16 am

Post by chewey »

Unrelated to the software changes, as this happens for a couple of days already:

Initial forum page loading times are very high for me, at around 20-30 seconds, sometimes even timeouting (is this even a word? ;-) ).
Subsequent pages come in a bit faster, but the whole forum still feels rather sluggish.
MonztA
EasyList Author
EasyList Author
Posts: 8121
Joined: Thu Jul 26, 2007 4:19 pm
Location: Germany

Post by MonztA »

*sry for offtopic stuff*

chewey, please check your PM inbox. ;)
User avatar
chewey
Emeritus Contributor
Emeritus Contributor
Posts: 276
Joined: Sun Dec 31, 2006 9:16 am

Post by chewey »

MonztA wrote:chewey, please check your PM inbox. ;)
Oh boy, I hardly ever use that. Say, there is a proper way to report
false positives directly to me via contact form or email... 8)

I'll look into it, thanks.
MonztA
EasyList Author
EasyList Author
Posts: 8121
Joined: Thu Jul 26, 2007 4:19 pm
Location: Germany

Post by MonztA »

Ah right, I totally forgot about it. :oops:
User avatar
rick752
Honorary Member
Honorary Member
Posts: 4508
Joined: Fri Dec 30, 2005 1:02 am
Location: New York, USA

Post by rick752 »

Wow! :shock:

@Lanik:
The forum was hanging up so bad lately that I did maintenance in the ACP index. I did the normal, but I also ran the one thing that hadn't been done .... "Resynchronise dotted topics".

After I ran that, the forum was flying faster than it EVER has. Go figure.

Hope it wasn't just a coincidence :( ... but I guess we will see.
"Experience is something you don't get until just after you need it"
User avatar
LanikSJ
Site Owner
Site Owner
Posts: 1806
Joined: Thu Feb 15, 2007 7:44 am
Location: /dev/null

Post by LanikSJ »

I narrowed it down with the slow database response. I have another database driven tool that access it and I see the same thing as well which leads me to believe something with the way they run their database server isn't right. I'm actually considering switching to another host. Not until some time in the first 2 months of next year and if I do decide to go that route I will take advantage of some of the free trials they have and play around with their tools and see how things are then. Probably going to put up another test board with a copy of what we have here and give it a go for a few weeks.

Off to pester Powweb support now. :?
"If it ain't broke don't fix it."
User avatar
rick752
Honorary Member
Honorary Member
Posts: 4508
Joined: Fri Dec 30, 2005 1:02 am
Location: New York, USA

Post by rick752 »

I don't get it though. It was running dog-slow UNTIL I ran that.

Like magic, it is now running VERY fast ... isn't it?
"Experience is something you don't get until just after you need it"
User avatar
LanikSJ
Site Owner
Site Owner
Posts: 1806
Joined: Thu Feb 15, 2007 7:44 am
Location: /dev/null

Post by LanikSJ »

What it does is changes the indexes in the database from what I'm able to gather. Every little thing we do on this site has an affect on the database. Some times there are bunch of stale entries that are no longer needed by doing that little bit of "maintenance" you're forcing the database to dump its garbage. Once its done everything can be located promptly since the database doesn't have to parse any data that's been removed by now.

Also I tracked down the error message you sent me earlier about he max connections and again it has to do with the same thing poor garbage collection. :cry:
"If it ain't broke don't fix it."
Locked