09-07-2018, 09:53 AM
|
#1
|
That Crazy Guy at the Bus Stop
Join Date: Jun 2010
Location: Springfield Penitentiary
|
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.
|
|
|
09-07-2018, 11:57 AM
|
#2
|
The new goggles also do nothing.
Join Date: Oct 2001
Location: Calgary
|
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.
|
|
|
The Following 4 Users Say Thank You to photon For This Useful Post:
|
|
09-11-2018, 03:53 PM
|
#3
|
Franchise Player
Join Date: Feb 2006
Location: Calgary, AB
|
This has been getting really bad over the last couple of days.
__________________
Turn up the good, turn down the suck!
|
|
|
09-11-2018, 04:11 PM
|
#4
|
It's not easy being green!
Join Date: Oct 2001
Location: In the tubes to Vancouver Island
|
Tapatalk has been worse than web
__________________
Who is in charge of this product and why haven't they been fired yet?
|
|
|
09-11-2018, 05:21 PM
|
#5
|
Franchise Player
Join Date: Feb 2011
Location: Somewhere down the crazy river.
|
So for Tapatalk, not only horrendously slow at times, and maybe this is Tapatalk only, but missing some recent posts.
|
|
|
09-11-2018, 05:25 PM
|
#6
|
The new goggles also do nothing.
Join Date: Oct 2001
Location: Calgary
|
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.
|
|
|
The Following User Says Thank You to photon For This Useful Post:
|
|
09-11-2018, 05:52 PM
|
#7
|
The new goggles also do nothing.
Join Date: Oct 2001
Location: Calgary
|
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.
|
|
|
09-11-2018, 06:36 PM
|
#8
|
It's not easy being green!
Join Date: Oct 2001
Location: In the tubes to Vancouver Island
|
Tapatalk has been worse than web
__________________
Who is in charge of this product and why haven't they been fired yet?
|
|
|
09-11-2018, 08:11 PM
|
#9
|
The new goggles also do nothing.
Join Date: Oct 2001
Location: Calgary
|
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.
|
|
|
09-11-2018, 08:34 PM
|
#10
|
The new goggles also do nothing.
Join Date: Oct 2001
Location: Calgary
|
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.
|
|
|
09-11-2018, 08:56 PM
|
#11
|
The new goggles also do nothing.
Join Date: Oct 2001
Location: Calgary
|
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.
|
|
|
The Following 3 Users Say Thank You to photon For This Useful Post:
|
|
09-12-2018, 10:00 AM
|
#12
|
#1 Goaltender
|
Thanks for you hard work, photon.
|
|
|
The Following 4 Users Say Thank You to woob For This Useful Post:
|
|
09-12-2018, 10:11 AM
|
#13
|
The new goggles also do nothing.
Join Date: Oct 2001
Location: Calgary
|
Vox is looking into it as well.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
|
|
|
09-12-2018, 09:42 PM
|
#14
|
Scoring Winger
Join Date: Jul 2008
Location: Calgary, AB
|
Quote:
Originally Posted by photon
Vox is looking into it as well.
|
You're the smart one though.
Just sent you some reports from the morning.
|
|
|
09-13-2018, 09:51 AM
|
#15
|
The new goggles also do nothing.
Join Date: Oct 2001
Location: Calgary
|
Just rebooted the database server, we'll see if that changes anything.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
|
|
|
09-13-2018, 09:53 AM
|
#16
|
The new goggles also do nothing.
Join Date: Oct 2001
Location: Calgary
|
Lol I guess not.
__________________
Uncertainty is an uncomfortable position.
But certainty is an absurd one.
|
|
|
09-20-2018, 09:07 AM
|
#17
|
The new goggles also do nothing.
Join Date: Oct 2001
Location: Calgary
|
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.
|
|
|
The Following 4 Users Say Thank You to photon For This Useful Post:
|
|
The Following 2 Users Say Thank You to psyang For This Useful Post:
|
|
09-27-2018, 03:00 PM
|
#19
|
Franchise Player
Join Date: Mar 2006
Location: Victoria
|
So what's going on today?
|
|
|
09-27-2018, 03:52 PM
|
#20
|
The new goggles also do nothing.
Join Date: Oct 2001
Location: Calgary
|
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.
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -6. The time now is 12:31 AM.
|
|