Calgarypuck Forums - The Unofficial Calgary Flames Fan Community
Old 09-07-2018, 10:53 AM   #1
Cecil Terwilliger
That Crazy Guy at the Bus Stop
 
Cecil Terwilliger's Avatar
 
Join Date: Jun 2010
Location: Springfield Penitentiary
Exp:
Default CP Slow?

CP has been intermittently slow for me for the last week. About 70% of the time it is totally fine but it seems to get super slow every once and a while loading pages be it a new post, edit or just browsing. Seems to load for about 30s and then finally goes through. When I'm posting, sometimes it directs me to the "you need to wait 30s between posts" as if the same post is being processed twice.

Am I alone in this? I thought maybe my home internet was acting weird but I haven't noticed it on any other sites and I'm now noticing it when I browse CP even when I'm not at home.
Cecil Terwilliger is offline   Reply With Quote
Old 09-07-2018, 12:57 PM   #2
photon
The new goggles also do nothing.
 
photon's Avatar
 
Join Date: Oct 2001
Location: Calgary
Exp:
Default

Yeah I was wondering if anyone else has been seeing it too or if it was just me, whenever I try opening an incognito window to try viewing as a not-logged in user it seems to be fast, so I thought maybe it was just something with my being an admin or something.

I was going through and pruning some of the really big threads which can cause this, but I think there may be a few left to do. That's the most likely cause.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
photon is offline   Reply With Quote
The Following 4 Users Say Thank You to photon For This Useful Post:
Old 09-11-2018, 04:53 PM   #3
getbak
Franchise Player
 
getbak's Avatar
 
Join Date: Feb 2006
Location: Calgary, AB
Exp:
Default

This has been getting really bad over the last couple of days.
__________________
Turn up the good, turn down the suck!
getbak is online now   Reply With Quote
Old 09-11-2018, 05:11 PM   #4
kermitology
It's not easy being green!
 
kermitology's Avatar
 
Join Date: Oct 2001
Location: In the tubes
Exp:
Default

Tapatalk has been worse than web
__________________
Who are the people in charge of this product and why haven't they been fired?
kermitology is offline   Reply With Quote
Old 09-11-2018, 06:21 PM   #5
Wormius
Franchise Player
 
Wormius's Avatar
 
Join Date: Feb 2011
Location: Somewhere down the crazy river.
Exp:
Default

So for Tapatalk, not only horrendously slow at times, and maybe this is Tapatalk only, but missing some recent posts.
Wormius is offline   Reply With Quote
Old 09-11-2018, 06:25 PM   #6
photon
The new goggles also do nothing.
 
photon's Avatar
 
Join Date: Oct 2001
Location: Calgary
Exp:
Default

For the nerdy, it looks like the database server is spending most of its time waiting for disk I/O. Nothing else has really changed, so I'm going to ask Vox if there's been something changed where the IO throughput has gone down.

Will also continue to prune down threads that are too big.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
photon is offline   Reply With Quote
The Following User Says Thank You to photon For This Useful Post:
Old 09-11-2018, 06:52 PM   #7
photon
The new goggles also do nothing.
 
photon's Avatar
 
Join Date: Oct 2001
Location: Calgary
Exp:
Default

Ok asked Vox.

I'm also going to add something to the database that might help improve the performance of some of the slow queries, I'll probably have to put the forum offline to do that so I'll do that a bit later.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
photon is offline   Reply With Quote
Old 09-11-2018, 07:36 PM   #8
kermitology
It's not easy being green!
 
kermitology's Avatar
 
Join Date: Oct 2001
Location: In the tubes
Exp:
Default

Tapatalk has been worse than web
__________________
Who are the people in charge of this product and why haven't they been fired?
kermitology is offline   Reply With Quote
Old 09-11-2018, 09:11 PM   #9
photon
The new goggles also do nothing.
 
photon's Avatar
 
Join Date: Oct 2001
Location: Calgary
Exp:
Default

Ok until Vox gets back to me, let's see how much difference that made.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
photon is offline   Reply With Quote
Old 09-11-2018, 09:34 PM   #10
photon
The new goggles also do nothing.
 
photon's Avatar
 
Join Date: Oct 2001
Location: Calgary
Exp:
Default

Hm, until I run another process (analyze the table's statistics) it doesn't appear what I did will have a significant benefit. That process might take a really long time as well, I'll probably have to give that a try tomorrow evening, it's a bit late now as I don't want to take everything offline for the whole night in case it takes a long time to run.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
photon is offline   Reply With Quote
Old 09-11-2018, 09:56 PM   #11
photon
The new goggles also do nothing.
 
photon's Avatar
 
Join Date: Oct 2001
Location: Calgary
Exp:
Default

There'll also be intermittent lag spikes as I identify old large threads and move them to where they can't be seen so they don't cause undue load.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
photon is offline   Reply With Quote
The Following 3 Users Say Thank You to photon For This Useful Post:
Old 09-12-2018, 11:00 AM   #12
woob
First Line Centre
 
woob's Avatar
 
Join Date: Jan 2006
Exp:
Default

Thanks for you hard work, photon.
woob is offline   Reply With Quote
The Following 4 Users Say Thank You to woob For This Useful Post:
Old 09-12-2018, 11:11 AM   #13
photon
The new goggles also do nothing.
 
photon's Avatar
 
Join Date: Oct 2001
Location: Calgary
Exp:
Default



Vox is looking into it as well.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
photon is offline   Reply With Quote
Old 09-12-2018, 10:42 PM   #14
Vox
Scoring Winger
 
Vox's Avatar
 
Join Date: Jul 2008
Location: Calgary, AB
Exp:
Default

Quote:
Originally Posted by photon View Post


Vox is looking into it as well.
You're the smart one though.

Just sent you some reports from the morning.
Vox is offline   Reply With Quote
Old 09-13-2018, 10:51 AM   #15
photon
The new goggles also do nothing.
 
photon's Avatar
 
Join Date: Oct 2001
Location: Calgary
Exp:
Default

Just rebooted the database server, we'll see if that changes anything.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
photon is offline   Reply With Quote
Old 09-13-2018, 10:53 AM   #16
photon
The new goggles also do nothing.
 
photon's Avatar
 
Join Date: Oct 2001
Location: Calgary
Exp:
Default

Lol I guess not.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
photon is offline   Reply With Quote
Old 09-20-2018, 10:07 AM   #17
photon
The new goggles also do nothing.
 
photon's Avatar
 
Join Date: Oct 2001
Location: Calgary
Exp:
Default

In case anyone is curious, it seems it was the reboot of the database server that fixed the issue. After rebooting there was one more load spike but after that things have been back to normal.

__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
photon is offline   Reply With Quote
The Following 4 Users Say Thank You to photon For This Useful Post:
Old 09-21-2018, 09:27 AM   #18
psyang
Powerplay Quarterback
 
Join Date: Jan 2010
Exp:
Default

psyang is offline   Reply With Quote
The Following 2 Users Say Thank You to psyang For This Useful Post:
Old 09-27-2018, 04:00 PM   #19
rubecube
Franchise Player
 
rubecube's Avatar
 
Join Date: Mar 2006
Location: Victoria
Exp:
Default

So what's going on today?
rubecube is offline   Reply With Quote
Old 09-27-2018, 04:52 PM   #20
photon
The new goggles also do nothing.
 
photon's Avatar
 
Join Date: Oct 2001
Location: Calgary
Exp:
Default

Yeah I'm not sure.. it's not doing anything like it was previously, the monitoring all looks pretty normal except for an increase in load, but I can't really see anything specific causing it.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
photon is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -6. The time now is 02:33 AM.

Calgary Flames
2017-18




Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright Calgarypuck 2016