Queries?????

[kolenoblata]

I installed pro version and I don't see any difference. When vboptimise is disabled I have 38 queries and when I enable it 35, so it reduced only 3 queries, not what I was reading it will do.
I did all setting, if that is your next question

 

[Cosmic]

Can you let us know which opcache operator you are using, and can you let us know what comes up when you hit system check?

 

[kolenoblata]

I am using xcache and everything is ok in system test.
I also noticed that load and CPU usage is higher than usual.
I was using lite version till yesterday but look what happening with pro.

 

[Cosmic]

Are you on a shared, VPS or dedicated server?

Also, are you running VBSEO?

It looks like you are load spikin at midnight - do you have any cron tasks which run then, or are there any other cron tasks run by anything else on the server?

vBO doesn't do anything that would cause load to spike periodically like that.

Quick Edit: You say you installed pro yesterday, but i see very little difference in yesterdays load compared to the days before? Not sure what makes you think VBO has affected that, unless i'm missing something?

 

[kolenoblata]

I am on dedicated server.
Yes I am using VBSEO but what difference does it make. I was using it before also. It is not midnight, it is from 20-23h, my peak hours of traffic.
Yes it is little difference ( 30% ) but it all happened when I installed pro version and removed lite. Point of pro version is to help me more, not to make it worst, unless i'm missing something?
Also queries are still there.....

 

[Cosmic]

Could you run a test disabling VBSEO overnight?

I recall in the past the way the VBSEO rules were setup on a board was causing it to cause a loa increase when using VBO (and interfere with VBO caching)

This will help us track down the issue - or at least rule VBSEO out =)

Thanks,

Cosmic

(Edit: Just went onto your site there and saw vBulletin Optimisation by vB Optimise (Reduced on this page: MySQL 75,86%) at the bottom, which suggests VBO is caching the queries as it is supposed to. Can you let me know what makes you think it wasn't? (Bear in mind most of the pro changes are to help with caching for guests, not users. Also, could you let us know which version of vBulletin you are running? Thanks.))

 

[Cosmic]

Addtional question: Do you have caching enabled in VBSEO?

 

[kolenoblata]

Yes, I do caching VBSEO ( xcache also ) but turning it off didn't make any big difference.
Yes it is written at the bottom about savings but even if it is 99% my load and CPU usage is higher after installing it than usual. So it was working better with lite version ( I was also using xcache ) than with pro.
I also checked page for guests and it also reduce only 3 queries, from 27 to 24.

 

[Cosmic]

Yes, I do caching VBSEO ( xcache also ) but turning it off didn't make any big difference.
Yes it is written at the bottom about savings but even if it is 99% my load and CPU usage is higher after installing it than usual. So it was working better with lite version ( I was also using xcache ) than with pro.
I also checked page for guests and it also reduce only 3 queries, from 27 to 24.

Maybe a silly question, but what is it that gives you the 3 queries as opposed to the savings displayed on the page?

Also, could you try running with vBSEO off for a full 24 hours so we can get a comparison between the load over a 24 hour period?

This is one of those things that'll likely take running a few tests to work out exactly what is causing the issue =)

Cosmic

 

[kolenoblata]

I am using micro DEBUG stats, you can see it at the bottom of the page.
If I disable VBSEO I will kill all my traffic as all my urls are saved with vbseo.
I don't understand why should I turn it off. Even if it has something with VBSEO you will tell me to change something what you already know from your experience, so why don't you tell me now what can cause problems instead of turning it off and losing tons of traffic plus indexing bad urls in that 24 hours without VBSEO.

 

[Cosmic]

I am using micro DEBUG stats, you can see it at the bottom of the page.
If I disable VBSEO I will kill all my traffic as all my urls are saved with vbseo.
I don't understand why should I turn it off. Even if it has something with VBSEO you will tell me to change something what you already know from your experience, so why don't you tell me now what can cause problems instead of turning it off and losing tons of traffic plus indexing bad urls in that 24 hours without VBSEO.

Because we need to debug what the issue is =)

From looking over old support, one person turned of VBSEO as it was conflicting with other modifiations anyway, and another turned of VBSEO caching and that seemed to help.

Feel free to give that a try and see if it helps.

If not theres not much we can do without diagnosing what the problem is/where it is coming from, sorry - there are hundreds of sites running vBOptimise perfectly well, which makes it impossible to diagnose why it would be behaving oddly for you without ttesting.

 

[Fillip H.]

To elaborate on the reason why we believe vBSEO may be affecting vBO is the fact that vBSEO uses some highly un-orthodox and very server intensive methods in order to generate its SEO URLs. It's also as a rule of thumb a bad idea to run 2 cache systems at the same time.

Also, your graphs indicate that the load isn't constant, it's in spikes, which leads me to believe that there's something running on your server in intervals that's taking a whole lot of time. Can you please try turning off this setting: vB Optimise: Resource Saving Statistics
You will lose the stats in the footer, but it's the only Pro-only feature that could in theory cause load.

Finally, the Microstats script is not an accurate representation of actual queries ran. It does not take into consideration the queries saved; if you view your page's source as a guest you will see this:
<!-- vB Optimise Guest Cached Page / Generated in 0,06137 seconds with 7 queries and 22 queries saved vs uncached -->
As you can see, Microstats is not telling the truth

 

[kolenoblata]

I never said VBO doesn't work. If I think so I would never buy it or any other product from you I bought. I am just trying to find out why doesn't it have positive effect on my server ( even worst ) but I am aware that problem is from my side, I just need your help.
I will let this few days because today is little better. I guess it takes some time to cache all pages.

I don't understand why are you surprised about my graphs. I is perfectly normal that load is less in 5:00 AM when I have 250 users online comparing to 21:00 PM when I have 1500 online.


So you want to say that using xcache to both VBO and VBSEO is not good idea?

 

[kolenoblata]

I turned off xcache for VBSEO, load drop down 50% and it is lower than it was before installing pro, so I guess problem is solved

VBO pro saved me yesterday 2.2 mil queries.......thanks.

 

[Cosmic]

^.^ awesome, glad it got sorted!

Cosmic

 

[hornstar]

I guess it came down to having 2 caches at the same time = bad.