Issue: Big Forum Optimization Request

What's the average total users online? Posts per minute? Also tell me about the content of your wiki. What are some stats for this? What have you created so far?

Have you tried Settings > Options > VaultWiki: Server Settings > Enable Link Caching = No?
Make sure all Settings > Options > VaultWiki: Legacy Options are disabled.

How soon after enabling VaultWiki did it go up? Was this the peak or was it consistently this high?

Is MySQL reporting any slow queries since installing VaultWiki?
Are you using Sphinx search? Can you tell if vBulletin is using Sphinx when you try to search for wiki content?

Hi,

I've just installed it, there is no data in VaultWiki.
There are more than 100 posts was posted per minute.

Both these settings was set up but it has no difference.
If you need to check I can send you the admin account so you can check it.

Let's me know if you need further information.
Thank you.

Yes if you can PM me an admin account I can track down what plugin if any is causing a slowdown.

Okay, sorry for the hour of high loads on your server, but this is now solved. This is simply caused by the volume of requests per second at your forum activity level, when combined with a VaultWiki plugin that was designed to workaround some limitations in vBulletin's search system. I have disabled the problematic plugin. Since you are running 4.1.3, you can re-enable wiki search by editing packages/vaultwiki/search/result/vaultarticle.php. Find:
Replace with:

>> Since you are running 4.1.3, you can re-enable wiki search by editing packages/vaultwiki/search/result/vaultarticle.php.
If I do this, will high load return?

And what happen when I upgrade VaultWiki? Will I need to do it again?

This morning it still make server to very high load.
From 37/24 Load, turn it off then load down to 20/24

If you make that edit, the high load will not return. This is a bug fix so it will be in the next upgrade already.

Can you give a specific time this morning relative to UTC? In order to look into this further I'll need to work on your site during a period of higher load. Right now with VaultWiki enabled the load is 20/20. During what period is your server load normally highest?

From next 6 - 8 hours, the server load is normally highest.
If you can please login and try it.

I've just done this.

After watching your forum load for several hours with VaultWiki enabled and disabled, it is my opinion that VaultWiki now (at least since the aforementioned change) has a negligible impact on your forum load.

With VaultWiki disabled, I have seen the load range from 15/24 - 200/40. This figure varied depending on the total number of requests (new and processing, generally ranging from 100 - 300) and if your server was currently victim to a DDoS attack, and made it difficult to determine any kind of baseline during your busiest period. However, it eventually seemed that the load stayed below 40 unless an attack was in progress. Again this was all with VaultWiki disabled.

With VaultWiki enabled, the range stayed pretty much the same. I found that toggling VaultWiki did not seem to have any direct effect on the load. This figure seemed more correlated to the total number of requests, although whatever scripts were in the queue should each have a different efficacy.

Thanks for your support.