vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Board Optimization - [DBTech] vB Optimise 2.0.1 (Lite) (https://vborg.vbsupport.ru/showthread.php?t=199207)

Deriel 12-20-2008 09:57 AM

Really nice Mod, nominated it already :)

I'm using vB 3.8rc2 and everything seems to be ok. Just one curiosity: using XCache with this mod seems faster than useing memcache (yeap, I have both installed)

logicuk 12-20-2008 10:10 AM

Running php5, memcache 3, vb 3.7

Before
* Page Generation 0.22566 seconds
* Memory Usage 16,396KB
* Queries Executed 33 (?)

After
* Page Generation 0.30642 seconds
* Memory Usage 16,407KB
* Queries Executed 54 (?)

So after i install this it it uses an extra 21 queries??? and also makes my pages load slower??

GreasySpoon 12-20-2008 10:13 AM

Quote:

Originally Posted by Deceptor (Post 1689277)
If anyone has any suggestions, be sure to let me know and I'll try get them in the next update :)

Maybe precaching the templates? So that the Add-On dont have to check if the Templates, Styles, ... are already cached or not?

Really nice work. Thumbs up :up:

veenuisthebest 12-20-2008 10:23 AM

Quote:

Originally Posted by logicuk (Post 1689459)
Running php5, memcache 3, vb 3.7

Before
* Page Generation 0.22566 seconds
* Memory Usage 16,396KB
* Queries Executed 33 (?)

After
* Page Generation 0.30642 seconds
* Memory Usage 16,407KB
* Queries Executed 54 (?)


So after i install this it it uses an extra 21 queries??? and also makes my pages load slower??


Is this the debug info for forum/index.php ?

First of all 33 queries by default is damn too much. Its just 15-16 quries on my index.php or any other forum.

And there's no way it can increase the number of queries.

Make sure you have have enabled all the settings of the mod (they are off by default) and selected Memcache in the mod.

If problem persists, you seriously need to optimize your site. Try disabling unnecessary addons/mods and see the effect.

logicuk 12-20-2008 10:49 AM

Quote:

Originally Posted by veenuisthebest (Post 1689464)
Is this the debug info for forum/index.php ?

First of all 33 queries by default is damn too much. Its just 15-16 quries on my index.php or any other forum.

And there's no way it can increase the number of queries.

Make sure you have have enabled all the settings of the mod (they are off by default) and selected Memcache in the mod.

If problem persists, you seriously need to optimize your site. Try disabling unnecessary addons/mods and see the effect.

Yes this is the debug info for forum/index.php

I have enabled the mod and selected memcahce

And i cant disable any mods, my site is very custom

tmc 12-20-2008 11:25 AM

Quote:

Originally Posted by logicuk (Post 1689459)
Running php5, memcache 3, vb 3.7

Before
* Page Generation 0.22566 seconds
* Memory Usage 16,396KB
* Queries Executed 33 (?)

After
* Page Generation 0.30642 seconds
* Memory Usage 16,407KB
* Queries Executed 54 (?)


So after i install this it it uses an extra 21 queries??? and also makes my pages load slower??

This is just plain wrong.. You don't even explain if it's on the EXACT same page. Seems to me like your website is adding extra queries per post or per thread, (I don't know what script you're taking this info from) and you happen to be comparing different pages.

It's not possible that this mod added 21 queries.

That being said, you really need to hire somebody to fix those query issues and the amount of memory being taken up. I don't quite get how the page you're loading is taking 16MB of memory...

Here's a SHOWTHREAD example:
Quote:

Page generated in 0.02043104 seconds (73.73% PHP - 26.27% MySQL) with 6 queries 2,085.35KB Used
and FORUMHOME:
Quote:

Page generated in 0.01459694 seconds (66.00% PHP - 34.00% MySQL) with 5 queries 1,470.00KB Used

tmc 12-20-2008 11:50 AM

Quote:

Originally Posted by logicuk (Post 1689485)
Well i did explain that the results are from the same page if you took time to read my post in full

and like i said my site is very very custom go take a look at http://www.thcfarmer.com/forums/

and you will see what i mean.

I wasn't even quoting your last post, and I didn't even read/see it. I "took the time" to see that both your before AND after results are ridiculous and therefore this mod is most likely not the problem. I would attribute it to a website running poorly coded mods.

I see 8-10 queries on your FORUMHOME, not 33-54. So chances are you should optimize your mods first and try again.

logicuk 12-20-2008 12:51 PM

Quote:

Originally Posted by tmc (Post 1689486)
I wasn't even quoting your last post, and I didn't even read/see it. I "took the time" to see that both your before AND after results are ridiculous and therefore this mod is most likely not the problem. I would attribute it to a website running poorly coded mods.

I see 8-10 queries on your FORUMHOME, not 33-54. So chances are you should optimize your mods first and try again.

And how are you seeing 8-10 queries??

* Page Generation 0.26787 seconds
* Memory Usage 16,049KB
* Queries Executed 51 (?)

Lizard King 12-20-2008 12:54 PM

Quote:

Originally Posted by logicuk (Post 1689485)
Well i did explain that the results are from the same page if you took time to read my post in full

and like i said my site is very very custom go take a look at http://www.thcfarmer.com/forums/

and you will see what i mean.

Yes you have a customized style but there is nothing extra on your forum index to run 33 queries

Edit : Sorry i just realized you are also using vbadvanced cmps. That explains everything

tmc 12-20-2008 01:23 PM

Quote:

Originally Posted by logicuk (Post 1689498)
And how are you seeing 8-10 queries??

* Page Generation 0.26787 seconds
* Memory Usage 16,049KB
* Queries Executed 51 (?)

As in: That's all it should be taking to pull this information onto FORUMHOME. Given it is properly coded.

It wasn't an actual observation, but my estimate of what your query count should really be. You should hire someone to optimize your queries, as they are probably destroying your server.

veenuisthebest 12-20-2008 02:19 PM

Deceptor, I have switched to xcache and I see much much better performace than filecache. Though I did not flushed the cache, just wanted to know why all is working fine for me without flushing the cache. I do have modifications, template edits etc.

Suggestion:

1. Can the forum titles be cached on index.php to reduce another query to extract all forums everytime.
2. Will the new feature of Forumhome WOL Cache, also cache the Statistics i.e. counts of threads, posts and members.

Thank you

Bounce 12-20-2008 04:01 PM

Installed...

Althou our forum is on a dedicated server there is a noticeable increase in speed :up:

veenuisthebest 12-20-2008 04:07 PM

1 Attachment(s)
1. I am facing a problem ONLY in 1.1.0 (this did not happened in 1.0.2)

Since enabling xcache, I am unable to edit any templates. Gives me a blank page on template saving.

There is no such problem using Filecache.

2. Another major problem I just found.

All member profiles look like as in attached pic, happens ONLY when viewed as guests. All phrases gone. It is happening only with vboptimise enabled, no matter what the cache type is.

thanks

ssslippy 12-20-2008 05:18 PM

Quote:

Originally Posted by veenuisthebest (Post 1689613)
1. I am facing a problem ONLY in 1.1.0 (this did not happened in 1.0.2)

Since enabling xcache, I am unable to edit any templates. Gives me a blank page on template saving.

There is no such problem using Filecache.

2. Another major problem I just found.

All member profiles look like as in attached pic, happens ONLY when viewed as guests. All phrases gone. It is happening only with vboptimise enabled, no matter what the cache type is.

thanks

I can confirm the profile bug.

nascartr 12-20-2008 05:26 PM

Profile problem here too...only when you're not logged in. Using Filecache method.

shlomot 12-20-2008 05:34 PM

Concur, using only file cache.

Quote:

Originally Posted by nascartr (Post 1689647)
Profile problem here too...only when you're not logged in. Using Filecache method.


veenuisthebest 12-20-2008 05:36 PM

Quote:

Originally Posted by ssslippy (Post 1689644)
I can confirm the profile bug.

Quote:

Originally Posted by nascartr (Post 1689647)
Profile problem here too...only when you're not logged in. Using Filecache method.

lol I am glad this is happening not just with me, so its a confirmed bug. Are you able to reproduce the first problem that I stated. Are you able to edit templates with vboptimise 1.1.0 using xcache?

Thanks

Deceptor 12-20-2008 05:58 PM

I'll get on fixing the bug right away. If you want a temporary fix for the profile issue, disabling phrase cache will resolve the issue.

Also, logicuk, the only possible way this mod adds queries is if it fails to cache the data, if you enable vBulletin debug mode you should see several vB Optimise messages explaining what it's doing, when first caching data it will execute more queries than vB does purely to cache the data, after that the query reduction begins. I'm assuming it keeps trying to cache the content but it's failing, if you're using filecache, ensure ./vboptimise has sufficient perms (read and write, usually chmod 0777).

Bounce 12-20-2008 06:17 PM

Deceptor,

I have eAccelerator installed on my server.
When I select this option I get this ...

Quote:

vB Optimise: You have selected a cache method that vB Optimise has detected you cannot use, this may be because the extension required is either not installed or active on your server
Been using the file system but as it says

Quote:

Additionally vB Optimise offers the ability to use alternative methods to caching if you have the extensions installed on your server, it is recommended you use one of these instead of File Cache. If you have multiple methods available it is advised you test each method and find the one that works and performs best for you.
I thought I'd try the eAccelerator option.

Thoughts?

tpearl5 12-20-2008 06:20 PM

I'm getting that phrase behavior when logged out as well. Disabled phrase caching and phrases are back.

Regardless I'm already seeing a performance increase. Nominated :)

Deceptor 12-20-2008 06:29 PM

hIBEES, if vB Optimise is reporting an error then the method must not be available, it will test you have the functions available that are part of the method you selected, this works in the same way vBulletin does, does your vBulletin datastore run off of eAccelerator?

As for the profile bug, it has been fixed, the issue is caused by caching phrases with guests, the vBulletin session object goes its own root of querying phrases/languages for guests that currently I can't find a way to stop. This bug fix doesn't impact performance as caching phrases for guests still means the query is being ran, if anything it slightly helps by not attempting to cache phrases as they are continually called from the database when viewing as a guest.

This said, I can tell you my current forumhome statistics with the upcoming release of vB Optimise, this is a unmodified forum, with only vB Optimise installed:

As a member:
Quote:

Page Generation 0.03050 seconds, Memory Usage 924KB, Queries Executed 4
As a guest:
Quote:

Page Generation 0.02649 seconds, Memory Usage 860KB, Queries Executed 3
If you're wondering why my memory usage is so low, look into getting XCache installed on your server, at the time of fetching those results vB Optimise was using XCache too, along with vB Datacache using Memcache.

I'll have the new version out in the next couple of hours or so which will patch the issue and bring forward new features I explained in an earlier post :)

veenuisthebest 12-20-2008 06:36 PM

Quote:

Page Generation 0.03050 seconds, Memory Usage 924KB, Queries Executed 4
Page Generation 0.02649 seconds, Memory Usage 860KB, Queries Executed 3
now that is a real cake. waiting for the next release. :)

btw deceptor, can you please take a look at my 1st problem as described here.

This started happening ONLY SINCE 1.1.0, and never happened with the last version 1.0.2

thanks

Deceptor 12-20-2008 06:40 PM

veeuisthebest,

Look at my above posts, the bug is fixed for the next release, to temporarily fix for now disable phrase caching, those won't add another query to your forum but will make more slightly bigger :)

fattony69 12-20-2008 06:42 PM

The only problem I had, which I searched the thread for was that my quotes, the name was only appearing as an underscore after installing this.

Deceptor 12-20-2008 06:44 PM

fattony, can you tell me if this occured as a guest or a logged in user?

Thanks.

veenuisthebest 12-20-2008 06:48 PM

Quote:

Originally Posted by Deceptor (Post 1689679)
veeuisthebest,

Look at my above posts, the bug is fixed for the next release, to temporarily fix for now disable phrase caching, those won't add another query to your forum but will make more slightly bigger :)

I know profile bug is fixed. I was referring to my 1st problem actually.

Since enabling xcache, I am unable to edit any templates. Gives me a blank page on template saving.

This problem is gone when i switch to Filecache. And this happened ONLY in 1.1.0 (did NOT happened in 1.0.2)

thanks

Deceptor 12-20-2008 06:54 PM

My apologies veenuisthebest, I missed that.

I know when updating templates vB Optimise kills current cache, my guess is your XCache requires authentification? It should silently carry on. That said, if you could enable php errors on your server we'd be able to specifically see what the problem is.

I'll re-enable admin auth on my XCache server and see if I can replicate the issue :)

logicuk 12-20-2008 06:56 PM

Quote:

Originally Posted by Deceptor (Post 1689663)
Also, logicuk, the only possible way this mod adds queries is if it fails to cache the data, if you enable vBulletin debug mode you should see several vB Optimise messages explaining what it's doing, when first caching data it will execute more queries than vB does purely to cache the data, after that the query reduction begins. I'm assuming it keeps trying to cache the content but it's failing, if you're using filecache, ensure ./vboptimise has sufficient perms (read and write, usually chmod 0777).

Im not using filecache, im using memcache..

veenuisthebest 12-20-2008 07:07 PM

Quote:

My apologies veenuisthebest, I missed that.
Its just fine deceptor, np :)

Quote:

I know when updating templates vB Optimise kills current cache, my guess is your XCache requires authentification?
ah I see! Yes, my xcache requires authentication but I cannot pass it as I am on shared hosting. I don't have rights to flush cache neither my host is turning it off as it is on a server level.

SO, the reason could probably be that whenever I edit a template, it stucks at flushing of cache, thus not saving the template, am I correct?

If that is the case, then I'll disable vboptimise (or switch to filecache for the moment) whenever I need to edit templates and switch it back ON when I would be done editing. Would that be fine?

I want to keep xcache only as its giving me far better performace than filecache and my host has installed xcache just for me lol :D

Deceptor 12-20-2008 07:13 PM

logicuk, could you turn on vBulletin debug mode, and take a look at the debug messages everytime you try to load a page and tell me what you see vB Optimise doing? As said, the only way it will keep adding queries is if it is failing to cache.

veenuisthebest, that solution would work, I assume you get a white page when attempting to flush the cache? Ideally I'd like to make it a little more solid, as in the future I'll probably be adding more places where the cache is killed to contend with new data, if your host could possibly turn on php errors so that you could tell me the error you're getting that'd be great :)

fattony69 12-20-2008 07:20 PM

Quote:

Originally Posted by Deceptor (Post 1689682)
fattony, can you tell me if this occured as a guest or a logged in user?

Thanks.

Seemed like it was for everyone from what I was told.

Deceptor 12-20-2008 07:25 PM

logicuk, I can't see any vB Optimise messages in the debug area, is it even turned on? If you could change the password to something more secure then PM me it, and grant me access to look at your vB Optimise settings I'll gladly take a look.

fattony, could you explain exactly how you encounter the issue? Sounds like a problem with phrases and it may be resolved as a similar bug has just been fixed.

veenuisthebest, I managed to replicate your issue, it seems that XCache haults the script on attempting to flush and the error cannot be silenced or stopped, so I've put a condition in that if the flush is meant to be silent (which it is when editing templates and such), and that your XCache requires authentification (specified by your vB Optimise settings), then the flush will simply skip and not attempt to clear the cache at all. Ofcourse a manual flush can still be achieved through the Flush Cache page, and this will only occur if your XCache requires authentification, for those lucky enough to turn it off the kill cache hooks will work fine with XCache :)

veenuisthebest 12-20-2008 07:28 PM

Quote:

Originally Posted by Deceptor
veenuisthebest, that solution would work, I assume you get a white page when attempting to flush the cache? Ideally I'd like to make it a little more solid, as in the future I'll probably be adding more places where the cache is killed to contend with new data, if your host could possibly turn on php errors so that you could tell me the error you're getting that'd be great

On attempting to flush the cache, I get the Xcache admin login window. No white pages anywhere.

In my phpinfo(), I have display_errors set to ON for local/master value under PHP Core. Let me know if that is what you were asking for.

I get no errors anywhere.

thanks

Deceptor 12-20-2008 07:29 PM

veenuisthebest, seems odd how a white page would occur. But not to worry, if you set your XCache Authentification setting to on, when you update to the next version it'll no longer occur when editing templates :)

logicuk 12-20-2008 07:39 PM

just sent you a pm deceptor :)

veenuisthebest 12-20-2008 07:43 PM

Quote:

in the future I'll probably be adding more places where the cache is killed to contend with new data
That would be pretty cool. All the limits of shared hosting would overcome then.

Quote:

veenuisthebest, seems odd how a white page would occur. But not to worry, if you set your XCache Authentification setting to on, when you update to the next version it'll no longer occur when editing templates
superb! :)

waiting for it badly. Was just wondering why this "Editing templates" problem occured in 1.1.0 as it was not in 1.0.2. Is this due to addition of xcache authentication setting?

Thanks

Deceptor 12-20-2008 07:46 PM

venuusisthebest,

The kill cache hooks were only introduced in the latest version, which is why it only occurs now :)

logic,

I took a look at your site, I believe one of many of your modifications is stopping vB Optimise debug messages, or other operations. I can see that file cache reduces one query on your forum, but Memcache is not doing anything. The problem there is something with your Memcache, do you have the correct settings filled in for your /includes/config.php?

To sum up though, vB Optimise isn't working right due to confliction, and since you have a -lot- of modifications installed it's very hard to tell where the problem occurs, you'd probably need to turn a product off one at a time, and keep checking your forums debug info each time (you need to look at the drop down menu, very bottom of the debug info). Once you start to see 'vB Optimise' messages in the drop down menu, we can start getting a clearer picture of what is going wrong. If turning off a product doesn't work, turn it back on and move to the next to continue.

Also, I have to ask if your vBulletin forum files have been modified? If so those too could be the root of the issue.

logicuk 12-20-2008 07:52 PM

Quote:

Originally Posted by Deceptor (Post 1689737)
logic,

I took a look at your site, I believe one of many of your modifications is stopping vB Optimise debug messages, or other operations. I can see that file cache reduces one query on your forum, but Memcache is not doing anything. The problem there is something with your Memcache, do you have the correct settings filled in for your /includes/config.php?

To sum up though, vB Optimise isn't working right due to confliction, and since you have a -lot- of modifications installed it's very hard to tell where the problem occurs, you'd probably need to turn a product off one at a time, and keep checking your forums debug info each time (you need to look at the drop down menu, very bottom of the debug info). Once you start to see 'vB Optimise' messages in the drop down menu, we can start getting a clearer picture of what is going wrong. If turning off a product doesn't work, turn it back on and move to the next to continue.

Also, I have to ask if your vBulletin forum files have been modified? If so those too could be the root of the issue.

ive sent you my config file via pm :)

Deceptor 12-20-2008 08:03 PM

Hi logic,

I checked out your config.php and found this part commented out:
Code:

$config['Misc']['memcacheserver'][$i]        = '127.0.0.1';
$config['Misc']['memcacheport'][$i]            = 11211;
$config['Misc']['memcachepersistent'][$i]    = true;
$config['Misc']['memcacheweight'][$i]        = 1;
$config['Misc']['memcachetimeout'][$i]        = 1;
$config['Misc']['memcacheretry_interval'][$i] = 15;

You need to uncomment this section of code, or just copy what I put up there and place it anywhere inside your config.php - additionally you need ensure your memcache server is running on 127.0.0.1 (localhost) and port 11211 (usually is). The rest of the settings don't need modifying, but ensure the IP and Port is correct otherwise you may get errors when using Memcache on vB Optimise.

veenuisthebest 12-20-2008 08:10 PM

I'll post my suggestions again in case you didn't notice them.

Suggestions:

1. Can the forum titles be cached on forumhome to reduce another query to extract all forums everytime.
2. Will the new feature of Forumhome WOL Cache, also cache the Statistics i.e. counts of threads, posts and members.

Thank you


All times are GMT. The time now is 11:11 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02014 seconds
  • Memory Usage 1,869KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (28)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete