Database errors when replying and general forum sluggishness.

[smeagol]

Still getting the error a lot...

[1714093432]

1714093432

[1714093432]

1714093432

[jackjack]

So many 502s
It's getting worse and worse

[nahtnam]

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.

[deepceleron]

Gar. 502 error ate my top post, and it took five minutes to navigate here to complain. Another DDoS?

[Lethn]

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.

[MiningBuddy]

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. 

[nahtnam]

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. 

What is "THIS FEATURE"?

[BadBear]

Ignore coloring.

[deepceleron]

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. 

What is "THIS FEATURE"?

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

[nahtnam]

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. 

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.

[btcton]

I was getting it with a 50% frequency a few days ago. I am still getting it today, but not as much as before.

[deepceleron]

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.

[MiningBuddy]

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. 

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)

[nahtnam]

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. 

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.

[nahtnam]

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?

[MiningBuddy]

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

[nahtnam]

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!!!

[theymos]

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.