Question vBCredits Doing High server load

[Nirjonadda]

vBCredits Doing High server load on my forum , Please can you fix high server load issue?

With vBCredits Server Load : 10.32 (6 CPUs) Always And Its up to more than server load : 100

Without vBCredits Server Load : 1.50 , 2.00 (6 CPUs) Max : 4

 

[Fillip H.]

This is not an issue that can be replicated on any testing forum I have access to.

Can you try disabling the RIchest User module via the vBOptions?

 

[Nirjonadda]

Where the RIchest User module Option ?

 

[Fillip H.]

"Number of Richest Users" to 0 in the vBCredits Global Options setting group

 

[Nirjonadda]

It's already set to 0 , Enabled vBCredits Than server load going up to 8 , without vBCredits my server load is normally 1 or 2.

Other issue if vBCredits Enabled, Page load take to long time , also posting time take to long Respond.

After Enabled vBCredits Geting email from CSF (IFD) about High 5 minute load average alert.

Time: Wed Jan 15 00:34:03 2014 +0600
1 Min Load Avg: 11.72
5 Min Load Avg: 6.30
15 Min Load Avg: 3.73

If you want replicated this issue, I will give you my site and server login details, So you can verify enable/disable vBCredits for checking server load conditions.

 

[Fillip H.]

Do you have "Process Transactions in Realtime" enabled? If so, try disabling it, and enabling the scheduled task as per the instructions in the setting above the Realtime setting.

 

[Nirjonadda]

Already all are done, Process Transactions in Realtime set to NO and Scheduled Transaction Processing is 10 but does not help and same condition.

 

[Fillip H.]

In that case you will need to enable your Slow Query Log and post a sample of the queries here. Contact your host if you don't know how to do this, as it varies on a system-by-system basis.

 

[Nirjonadda]

Enabled mysql slow query, Does we need enable vBCredits for Slow Query Log ? If i enable vBCredits my site going down with high server load.

 

[Fillip H.]

Yes, in order to detect any slow queries in vBCredits, vBCredits has to be enabled.

 

[Nirjonadda]

I have no Slow Query Log under var/log/mysql-slow.log

 

[Fillip H.]

In that case it's not really possible for me to debug this issue any further. Until a query shows up there, I have no way of knowing what queries need further optimisation to reduce the load on your server.

 

[Nirjonadda]

I have Enabled the slow query log with this post : Enable the slow query log - cPanel Forums

Does it look like Are OK ?

 

[Nirjonadda]

OK, I get mysql slow query log, Please check your PM inbox.

 

[Nirjonadda]

What's Going On? Please can i get any update ?

 

[Fillip H.]

I was unable to find any other queries that could be optimised further, sorry.

 

[Nirjonadda]

Is this any solution you are get ?

 

[Fillip H.]

There have been no further changes related to this, sorry.