# עומס הדיון שלנו בגלל פלאגין מותאם אישית. אנא עזרו לי
**URL:** https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696
**Category:** Self-hosting
**Tags:** hosting
**Created:** [20 באוגוסט, 2022, 9:49am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696 "2022-08-20T09:49:57Z")
**Posts on this page:** 20
**Page:** 2
### Author:  [@Alienazk](https://meta.discourse.org/u/Alienazk)
#### Post date: [22 באוגוסט, 2022, 7:36am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/21 "2022-08-22T07:36:20Z")
Oh Robert,
We migrate to a new vps with 4 core(Ryzen 9 5950x),
Cpu usage is still almost 100%. I really don’t know what is wrong.
---
### Author:  [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [22 באוגוסט, 2022, 7:48am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/22 "2022-08-22T07:48:06Z")
I thought you were going to move to an 8 core Scaleway server?
What is the claimed bandwidth of this server? I wonder if low bandwidth could cause slow connections/disconnections to become a bottleneck?
Scaleway have VPS with bandwidths of hundreds of megabits per second, not 30.
30 seems extremely low to me.
---
### Author:  [@Alienazk](https://meta.discourse.org/u/Alienazk)
#### Post date: [22 באוגוסט, 2022, 7:54am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/23 "2022-08-22T07:54:25Z")
This is the spec.
```plaintext
4096MB DDR3 ECC RAM
4 CPU vCores (3.4+ GHz E3-1231 v3/1241 v3/1240 v5)
200GB Raid 10 HDD Storage
5TB bandwidth @ 1Gb/s (speed limited to 5Mb/s after allocation used)
1 IPv4, /64 IPv6
20Gb/s TCP DDoS Protection, 200Gb/s upgrade available
Seattle, Washington, US
Virtualizor Control Panel
Unmanaged
```
Because of time delay, we finally chose this cloud service provider. They did the optimization of the network for visitors from our country.
By the way, output of htop is
100% CPU usage is abnormal. 😨
Everything is fine except load and cpu usage.
---
### Author:  [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [22 באוגוסט, 2022, 8:02am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/24 "2022-08-22T08:02:00Z")
Anything strange in access logs?
---
### Author:  [@Alienazk](https://meta.discourse.org/u/Alienazk)
#### Post date: [22 באוגוסט, 2022, 8:06am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/25 "2022-08-22T08:06:59Z")
Oh now it seems like it is calming down now.
We guess restoring from a backup causes a spike in cpu usage.
Anyway, thank you very much Robert!
---
### Author:  [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [22 באוגוסט, 2022, 8:10am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/26 "2022-08-22T08:10:53Z")
Oh yes that would do it!
---
### Author:  [@Benjamin\_D](https://meta.discourse.org/u/Benjamin_D)
#### Post date: [22 באוגוסט, 2022, 8:11am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/27 "2022-08-22T08:11:58Z")
> [@Alienazk](#):
>
> `200GB Raid 10 HDD Storage`
Hum, you should aim for ssd
---
### Author:  [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [22 באוגוסט, 2022, 8:13am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/28 "2022-08-22T08:13:13Z")
Good catch Benjamin!
Scaleway and others have NVMe SSDs. Much better!
CPU could be waiting on disk.
---
### Author:  [@Alienazk](https://meta.discourse.org/u/Alienazk)
#### Post date: [22 באוגוסט, 2022, 8:36am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/29 "2022-08-22T08:36:24Z")
oh sorry I just pasted a wrong spec.
The spec is
```plaintext
4096MB DDR4 ECC RAM
4 CPU vCores (3.4GHz AMD Ryzen 5950X)
100GB Raid NVMe SSD Storage
5TB bandwidth @ 10Gb/s (speed limited to 5Mb/s after allocation used)
1 IPv4, /64 IPv6
20Gb/s TCP DDoS Protection, 200Gb/s upgrade available
Seattle, Washington, US
Virtualizor Control Panel
Unmanaged
```
It is NVMe. 😳
---
### Author:  [@Alienazk](https://meta.discourse.org/u/Alienazk)
#### Post date: [22 באוגוסט, 2022, 8:44am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/30 "2022-08-22T08:44:07Z")
I think it is possible the plugins we installed have increased the load.
The plugin made such a change to the user model that when we go to discovery route, we always calculate the points of user model in topic model for many times
```plaintext
add_to_class(:user, :total_earned_points) do
self.user_points.sum(:reward_points)
end
add_to_class(:user, :available_points) do
self.total_earned_points - self.user_rewards.sum(:points)
end
add_to_class(:user, :rewards) do
DiscourseRewards::Reward.where(created_by_id: self.id)
end
add_to_serializer(:basic_user, :total_earned_points) do
user&.total_earned_points
end
add_to_serializer(:basic_user, :available_points) do
user&.available_points
end
add_to_serializer(:current_user, :total_earned_points) do
scope.user.total_earned_points
end
add_to_serializer(:current_user, :available_points) do
scope.user.available_points
end
add_to_serializer(:current_user, :user_rewards) do
scope.user.user_rewards
end
add_to_serializer(:current_user, :rewards) do
scope.user.rewards
end
```
---
### Author:  [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [22 באוגוסט, 2022, 8:45am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/31 "2022-08-22T08:45:42Z")
I thought you’d said you’d removed all plugins and it was behaving the same?
> [@Alienazk](#):
>
> `DiscourseRewards::Reward.where(created_by_id: self.id)`
Does this have an index?
> [@Alienazk](#):
>
> `self.total_earned_points - self.user_rewards.sum(:points)`
How many rows is user\_rewards table? Interesting it is not distinguishing by user … (but I assume it must be somehow beneath this level).
---
### Author:  [@Alienazk](https://meta.discourse.org/u/Alienazk)
#### Post date: [22 באוגוסט, 2022, 8:54am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/32 "2022-08-22T08:54:53Z")
Oh I am afraid it doesn’t set an index.
The model is shown below.
```plaintext
module DiscourseRewards
class Reward < ActiveRecord::Base
self.table_name = 'discourse_rewards_rewards'
has_many :user_rewards
belongs_to :created_by, class_name: 'User'
default_scope { where(deleted_at: nil) }
end
end
```
```plaintext
module DiscourseRewards
class UserPoint < ActiveRecord::Base
self.table_name = 'discourse_rewards_user_points'
belongs_to :user
belongs_to :user_badge
belongs_to :user_points_category
def self.user_total_points(user)
UserPoint.where(user_id: user.id).sum(:reward_points)
end
end
end
```
```plaintext
module DiscourseRewards
class UserReward < ActiveRecord::Base
self.table_name = 'discourse_rewards_user_rewards'
belongs_to :user
belongs_to :reward
enum status: [:applied, :granted]
end
end
```
I disable all plugin on [safe mode](https://meta.discourse.org/t/53504?silent=true). However you know, the database didn’t change. 🥲
---
### Author:  [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [22 באוגוסט, 2022, 8:56am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/33 "2022-08-22T08:56:15Z")
Something to take up with the author I suspect.
Looks like it might not be scaling for your high number of users?
---
### Author:  [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [22 באוגוסט, 2022, 8:57am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/34 "2022-08-22T08:57:40Z")
> [@Alienazk](#):
>
> I disable all plugin on [safe mode](https://meta.discourse.org/t/how-to-use-discourse-safe-mode/53504). However you know, the database didn’t change. 🥲
You may need to rebuild without the plugin. It would be a good comparison and maybe confirm if the issues are caused by the plugin or not.
The presence of tables won’t matter if the queries aren’t running.
---
### Author:  [@Alienazk](https://meta.discourse.org/u/Alienazk)
#### Post date: [22 באוגוסט, 2022, 9:04am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/35 "2022-08-22T09:04:32Z")
> [@merefield](#):
>
> How many rows is user\_rewards table? Interesting it is not distinguishing by user …
discourse\_rewards\_user\_points | 233525 | 27 MB | 5152 kB | 32 MB
discourse\_rewards\_user\_rewards | 61 | 16 kB | 16 kB | 32 kB
discourse\_rewards\_user\_points\_categories | 9 | 16 kB | 16 kB | 32 kB
discourse\_rewards\_rewards | 4 | 16 kB | 16 kB | 32 kB
discourse\_rewards\_user\_points table is huge.
---
### Author:  [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [22 באוגוסט, 2022, 9:05am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/36 "2022-08-22T09:05:25Z")
Completely remove it (from build, no need to destroy the tables), see what happens.
---
### Author:  [@Alienazk](https://meta.discourse.org/u/Alienazk)
#### Post date: [22 באוגוסט, 2022, 9:06am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/37 "2022-08-22T09:06:01Z")
Thank you, I 'll try it right now.
---
### Author:  [@Alienazk](https://meta.discourse.org/u/Alienazk)
#### Post date: [22 באוגוסט, 2022, 9:17am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/38 "2022-08-22T09:17:45Z")
Oh Robert, I rebuild without the plugin, response time for pages of discovery route is reduced to less than 200ms from 2-3s before. 😨
---
### Author:  [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [22 באוגוסט, 2022, 9:18am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/39 "2022-08-22T09:18:46Z")
Well there you have it. I would discuss optimisation with the author, or if you have the skills, PR?
---
### Author:  [@Alienazk](https://meta.discourse.org/u/Alienazk)
#### Post date: [22 באוגוסט, 2022, 9:22am UTC](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696/40 "2022-08-22T09:22:11Z")
I am asking for our friend who is familiar with database for help.
But he is working on JAVA. I think it will takes some time.
[Previous page](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696.md?page=1)
[Next page](https://meta.discourse.org/t/our-discourse-overload-because-of-a-custom-plugin-please-help-me/236696.md?page=3)