Pages:
Author

Topic: Database errors when replying and general forum sluggishness. (Read 5051 times)

administrator
Activity: 5222
Merit: 13032
If the feature was written as:
-For every thread page of 20 posts that someone views:
 -for every user that posted:
  -look through every other user's ignore list and add up the times that user has been ignored

That's basically how it works because the ignore mod (which I didn't write) stupidly stores ignore info in a single column per user like "35,3,...". So each ignore button needs to scan through all established users. The cost of this used to be very little, but it has increased substantially as the number of users has increased. I added a lot of caching long ago to offset this, but the cost is too high now even for that. I need to mostly rewrite the ignore mod so it stores data more sanely. No too difficult, but it requires a somewhat large uninterrupted block of time, which I don't have right now.
legendary
Activity: 1092
Merit: 1000
nahtnam.com
Coloring the word "ignore" with a darker color when a user is ignored by many people.
I dont see how such a small error can make such a big difference.
If the feature was written as:
-For every thread page of 20 posts that someone views:
 -for every user that posted:
  -look through every other user's ignore list and add up the times that user has been ignored

it certainly could cause server load. If it comes back, it would probably not be a "live" statistic, but one that is compiled nightly per-user.

That totally makes sense. Why add this feature if it was soooo resource intensive?
I don't think it was actually that bad back in 2012 (resource wise) but as the forum has grown such a huge amount since then it's just been getting slower and slower, have a look through the stats on here https://bitcointalk.org/index.php?action=stats

Didint even know this page existed. 65.1 million views last month!!!
hero member
Activity: 927
Merit: 1000
฿itcoin ฿itcoin ฿itcoin
Coloring the word "ignore" with a darker color when a user is ignored by many people.
I dont see how such a small error can make such a big difference.
If the feature was written as:
-For every thread page of 20 posts that someone views:
 -for every user that posted:
  -look through every other user's ignore list and add up the times that user has been ignored

it certainly could cause server load. If it comes back, it would probably not be a "live" statistic, but one that is compiled nightly per-user.

That totally makes sense. Why add this feature if it was soooo resource intensive?
I don't think it was actually that bad back in 2012 (resource wise) but as the forum has grown such a huge amount since then it's just been getting slower and slower, have a look through the stats on here https://bitcointalk.org/index.php?action=stats
legendary
Activity: 1092
Merit: 1000
nahtnam.com
Coloring the word "ignore" with a darker color when a user is ignored by many people.
I dont see how such a small error can make such a big difference.
If the feature was written as:
-For every thread page of 20 posts that someone views:
 -for every user that posted:
  -look through every other user's ignore list and add up the times that user has been ignored

it certainly could cause server load. If it comes back, it would probably not be a "live" statistic, but one that is compiled nightly per-user.

That totally makes sense. Why add this feature if it was soooo resource intensive?
legendary
Activity: 1092
Merit: 1000
nahtnam.com
I guess it had something to do with this:
I've had to totally disable this feature. I will fix it in a few days.

Seems to be running a lot better right now either way.  Smiley

What is "THIS FEATURE"?
FYI: Clicking a quote title will take you to the appropriate thread where the post was quoted from (quotes can be edited so this may not always run true)

Ahhhh, that helps a lot. Thanks.
hero member
Activity: 927
Merit: 1000
฿itcoin ฿itcoin ฿itcoin
I guess it had something to do with this:
I've had to totally disable this feature. I will fix it in a few days.

Seems to be running a lot better right now either way.  Smiley

What is "THIS FEATURE"?
FYI: Clicking a quote title will take you to the appropriate thread where the post was quoted from (quotes can be edited so this may not always run true)
legendary
Activity: 1512
Merit: 1036
Coloring the word "ignore" with a darker color when a user is ignored by many people.
I dont see how such a small error can make such a big difference.
If the feature was written as:
-For every thread page of 20 posts that someone views:
 -for every user that posted:
  -look through every other user's ignore list and add up the times that user has been ignored

it certainly could cause server load. If it comes back, it would probably not be a "live" statistic, but one that is compiled nightly per-user.
legendary
Activity: 1302
Merit: 1007
I was getting it with a 50% frequency a few days ago. I am still getting it today, but not as much as before.
legendary
Activity: 1092
Merit: 1000
nahtnam.com
I guess it had something to do with this:
I've had to totally disable this feature. I will fix it in a few days.

Seems to be running a lot better right now either way.  Smiley

What is "THIS FEATURE"?
Coloring the word "ignore" with a darker color when a user is ignored by many people.

I dont see how such a small error can make such a big difference.
legendary
Activity: 1512
Merit: 1036
I guess it had something to do with this:
I've had to totally disable this feature. I will fix it in a few days.

Seems to be running a lot better right now either way.  Smiley

What is "THIS FEATURE"?
Coloring the word "ignore" with a darker color when a user is ignored by many people.
legendary
Activity: 1652
Merit: 1128
Ignore coloring.
legendary
Activity: 1092
Merit: 1000
nahtnam.com
I guess it had something to do with this:
I've had to totally disable this feature. I will fix it in a few days.

Seems to be running a lot better right now either way.  Smiley

What is "THIS FEATURE"?
hero member
Activity: 927
Merit: 1000
฿itcoin ฿itcoin ฿itcoin
I guess it had something to do with this:
I've had to totally disable this feature. I will fix it in a few days.

Seems to be running a lot better right now either way.  Smiley
legendary
Activity: 1540
Merit: 1000
This is what happened when they were attacked before, not much we can do on our end since it's just a forum, I'm getting it too.
legendary
Activity: 1512
Merit: 1036
Gar. 502 error ate my top post, and it took five minutes to navigate here to complain. Another DDoS?
legendary
Activity: 1092
Merit: 1000
nahtnam.com
So many 502s
It's getting worse and worse

Yes it is. Every other page gives me a 502. I guess if we wait it will go away.
legendary
Activity: 1176
Merit: 1280
May Bitcoin be touched by his Noodly Appendage
So many 502s
It's getting worse and worse
legendary
Activity: 1008
Merit: 1005
Still getting the error a lot...
newbie
Activity: 42
Merit: 0
Forum is growing rapidly with 31,775 new members in December and 65,132,393 page views per month so depends if admin is investing in HW upgrade to cope, seems not.

I would think there must be a way to cache some of the content to cope better with all the page refreshes everyone does.


legendary
Activity: 2156
Merit: 1393
You lead and I'll watch you walk away.
See this fellow a lot today.

502 Bad Gateway


In fact, as I posted that post I saw it.
So meta.

Maybe 502 Bad Gateway is the new name of the forum. Is there a new coin called "Bad Gateway"?
Pages:
Jump to: