vb.org Archive
Page 6 of 32 « First 45 6 7816 Last »
Show 40 post(s) from this thread on one page

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)

ssslippy 12-20-2008 08:17 PM
Please note when you install this mod the first view of any page will then put the item into the cache. That means those that just installed it and got more queries, vbulletin needs to put its data back into the cache after a clear.

Also on a side note if possible this should automatically use the pre built in data prefix that is in the config.php file.

Deceptor 12-20-2008 08:19 PM
ssslippy, I use a seperate data prefix just to ensure there's no collision with vBulletin :)

veenusisthebest,

Regarding #1, I'm looking into caching the forums now, it'd probably be a timed cache like the WOL will be, so the query can only be executed once every minute or hour if you like. Ofcourse the issue will be for those without auto flush cache due to XCache limitations like yourself may see stale data, since the last post info is updated regularly.

That said, if you put the timed cache for forums to 30 seconds, then the last post info data would ofcourse only have a maximum potential of being stale data for 30 seconds, and does reduce another query on several pages.

As for number 2, the statistics don't require a query as vBulletin already handles this with the datastore, assuming you have a decent datastore method (XCache/Memcache, etc..) setup with vBulletin then it's no problem, the only other query that might occur is when showing events from the calendar on the homepage, but these too are already cached by vBulletin.

Effectively the forum homepage only queries several things with the new version: Session, Userinfo, Forums and Moderators. This is only 4 queries, and ofcourse there are two other queries that execute as shutdown queries that occur on all vB pages (mostly, anyway).

If I can time cache the forums, and moderators part, the forumhome would go down to 2 queries (and the 2 hidden shutdown queries), which would be great :)

Bounce 12-20-2008 08:27 PM
Quote:
Originally Posted by Deceptor (Post 1689675)
does your vBulletin datastore run off of eAccelerator?
I have no idea lol (but judging from what you say I guess not),my host installed it,will ask them :up:

veenuisthebest 12-20-2008 08:45 PM
Quote:
Ofcourse the issue will be for those without auto flush cache due to XCache limitations like yourself may see stale data, since the last post info is updated regularly.
So is there a solution for this? The ones who do not have auto-flush cache, how would they be able to see new data ever ?

And if I edit a template, how would I be able to view the change when the cache is not being cleared.

Quote:
If I can time cache the forums, and moderators part, the forumhome would go down to 2 queries (and the 2 hidden shutdown queries), which would be great
oh man you are going to make all vbulletin sites run on cache completely haha.

Thanks

Deceptor 12-20-2008 08:49 PM
The solution would only be removing XCache authentification, or just going to Flush Cache each time you change anything with styles, phrases or templates. Ofcourse this still applies with other cache methods as vB Optimise does not always automatically refresh cache when data is updated, just currently on the common methods: edit templates, style variables, css information.

logicuk 12-20-2008 09:17 PM
Before
* Page Generation 0.22566 seconds
* Memory Usage 16,396KB
* Queries Executed 33 (?)

After
* Page Generation 0.19917 seconds
* Memory Usage 16,186KB
* Queries Executed 29 (?)

Great work Deceptor, nominated for MOTM :)

veenuisthebest 12-20-2008 09:27 PM
Quote:
Originally Posted by logicuk (Post 1689786)
Before
* Page Generation 0.22566 seconds
* Memory Usage 16,396KB
* Queries Executed 33 (?)

After
* Page Generation 0.19917 seconds
* Memory Usage 16,186KB
* Queries Executed 29 (?)

Great work Deceptor, nominated for MOTM :)
You have a wonderful looking site logicuk, but compromising it with 16mb of memory (5 times the normal) and 33 queries (more than 3 times the normal) is way too much.

Optimizing your forum to reduce it to a considerable number would help you more than this mod :)

logicuk 12-20-2008 09:29 PM
Quote:
Originally Posted by veenuisthebest (Post 1689796)
You have a wonderful looking site logicuk, but compromising it with 16mb of memory (5 times the normal) and 33 queries (more than 3 times the normal) is way too much.

Optimizing your forum to reduce it to a considerable number would help you more than this mod :)
I have a dedicated server with dual core cpu and 4gb ram, its all good :)

tmc 12-20-2008 09:32 PM
Quote:
Originally Posted by logicuk (Post 1689798)
I have a dedicated server with dual core cpu and 4gb ram, its all good :)
.... But then you're wasting loads of money a month on a server you shouldn't actually need.

Looking forward to the new release, Deceptor. :)

Deceptor 12-20-2008 09:32 PM
1.2.0 released :) Check the top post for details on bug fixes and additions :)

logicuk 12-20-2008 09:45 PM
i just installed 1.2.0 thanks for the new version

what setting do you recommend i use for Cache Forumhome WOL?

Deceptor 12-20-2008 09:47 PM
I personally would use between 30-60 seconds, ofcourse the higher the number the more stale the data becomes, but at a cost of better performance.

bashy 12-20-2008 09:53 PM
Hi

After upgrade i get this DB error now, its to do with the WOL part of your script

Code:
    Database error in vBulletin 3.7.4:
 
  Invalid SQL:
 
              SELECT
                    user.username, (user.options & 512) AS invisible, user.usergroupid,
                    session.userid, session.inforum, session.lastactivity, session.useragent,
                    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
              FROM session AS session
              LEFT JOIN user AS user ON(user.userid = session.userid)
              WHERE session.lastactivity >;
 
  MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7
  Error Number  : 1064
  Request Date  : Saturday, December 20th 2008 @ 11:51:47 PM
  Error Date    : Saturday, December 20th 2008 @ 11:51:48 PM
  Script        : http://www.bashys-place.com/forums/index.php
  Referrer      :
  IP Address    : *******
  Username      : ************
  Classname    : vB_Database
  MySQL Version : 5.0.67-

Deceptor 12-20-2008 09:54 PM
Bashy, are you using the homewol? Try disabling that to see if it works - be aware this is untested on vB 3.7, so I'm not sure if it will always work for that version.

veenuisthebest 12-20-2008 09:56 PM
just wow!

Loving the new Optimal settings check, I had all of them optimal already ;)

Profile bug down, can see another WOL query down. Cool

Template problem solved ONLY when XCache Authentification is ON.

Now, I tried to edit a template, the change did not show. Then I checked it again in a minute or two and it shows the edit fine. How did it show when I did/could not flush the cache ?

Thanks a lott.. You're one real php guy I had ever seen, this mod is going to beat the install counts of ibproarcade for sure. :)

logicuk 12-20-2008 09:56 PM
im using 1.2.0 and the WOL with vb 3.7 and its working fine :)

Deceptor 12-20-2008 09:58 PM
veenuisthebest,

The system maybe have found a corrupted template and pulled it again from the database to cache, which is part of the active sector of vB Optimise to ensure data is intact. Either that -or- your XCache has a low TTL (time to live) setting so cache is dropped every 5 minutes or so.

Glad you like the additions, I'll keep aiming to reduce the forum home queries as it's the biggest impact of performance being the most popular page visited on a forum, statistically speaking anyway :)

Bounce 12-20-2008 09:59 PM
ooooooooooooooooo nice update D...

WOL set for 60 secs :)

Had to optimize (or change)..
Store CSS Stylesheets as Files,Save Albums as Files,Save Avatars as Files..

Another 3 queries gone on forumhome:D..

Any faster and my forums will take-off LOL

Deceptor 12-20-2008 10:03 PM
Glad it's working great for you hibees :)

logicuk 12-20-2008 10:08 PM
My forum is so fast now its crazy! this has to be the best mod ever created!!

Bounce 12-20-2008 10:12 PM
Quote:
Originally Posted by Deceptor (Post 1689841)
Glad it's working great for you hibees :)
Thank you very much,voted for MOTM on version 1.1,this has to be MOTY :up:

Once I suss out eAccelerator then whoooffffffffff take off,not that my forums were slow as on a dedicated server with dual core cpu and 2gb ram but even at that this makes a difference..

I may not bother trying to get eAccelerator to work althou now i'm interested to see if it would improve it further..

Page Generation 0.19055 seconds on forumhome is just terrible :eek::cool::up:

Quote:
Originally Posted by logicuk (Post 1689844)
My forum is so fast now its crazy! this has to be the best mod ever created!!
wots your url mate if you don't mind me asking, brilliant this eh :):D

Deceptor 12-20-2008 10:14 PM
Personally I'd recommend using XCache over eAccelerator, easier to install and much better in my opinion :)

veenuisthebest 12-20-2008 10:15 PM
Quote:
Either that -or- your XCache has a low TTL (time to live) setting so cache is dropped every 5 minutes or so.
This is the reason, it has a low TTL.

Its fine if cache is dropped in few minutes. Infact, this solves out a big problem for me of not showing stale data now.

Loving vBulletin more from now on, just because of you and your vBoptimise. This is actually the BESTEST MODIFICATION EVER CREATED for vBulletin. I just can't stop thanking you deceptor, this has driven me crazyyy lol.

Thanks a lottt...

KevinL 12-20-2008 10:20 PM
Yup works no problem with 3.7. Excellent work.

Bounce 12-20-2008 10:20 PM
Quote:
Originally Posted by Deceptor (Post 1689848)
Personally I'd recommend using XCache over eAccelerator, easier to install and much better in my opinion :)
Thanks will look into it tomorrow(or later the day lol),better not mess with the server at this small hour (00:20GMT),plus had a few beers lol :up:

NolF 12-21-2008 12:39 AM
1 Attachment(s)
WoW incredible I jsut install it and I just cna feel the extra speed :) Could anyone tell me how to enable the Query number and execution time at the bottom of the page? I can't find the option. Would be cool to have quantitative data on how much this mod rocks :D

Installed and MOTD :DDDD

In 3.7.4 I found a curios bug which is not really a big deal. It you hace Store CSS as File disabled, and you try to enable it with this mod enabled only what is shown in the picture happens. Once disabled, you may enable Store as CSS and then enable the mod. Does this happen in 3.8?

Love it and thx mate :)

Vitaly 12-21-2008 12:49 AM
Quote:
Originally Posted by Deceptor (Post 1689834)
Bashy, are you using the homewol? Try disabling that to see if it works - be aware this is untested on vB 3.7, so I'm not sure if it will always work for that version.
I confirm. WOL doesn't work with 3.7.4, "database error". Must be disabled.

Deceptor 12-21-2008 12:50 AM
Nolf - I can confirm it works fine on my 3.8 install.

As for the debug info, it's this in your config.php:
Code:
$config['Misc']['debug'] = 1;
Vitaly - Some users have said it works on 3.7, others not, this is designed around 3.8 however. Could you tell me the db error that occured?

Thanks.

NolF 12-21-2008 01:03 AM
Vitaly I don't get a db error with WOL enabled :O (3.7.4)

Thx Deceptor :) just love the hack ^^

lazee 12-21-2008 01:20 AM
WOL .It work fine on my v3.7.2 board

Have anyone compare between the 1.0.2 and 1.2.0 version, my board used 1.0.2 it ran faster this morning and server load reduce from 0.67 to 0.45 , the 1.2.0 fast but the serverload reduce about half of the first one.

The only problem i got is every time i flush the cache it just never stop ( but it does clear the cache )

Deceptor: Thank a lot for this great plugin .

My spec: mysql 5.0.58 php 5.2.6 xcache v1.2.2

Deceptor 12-21-2008 01:22 AM
lazee, are you saying vB Optimise 1.2.0 made it slower than 1.0.2, or that 1.2.0 didn't make as much difference ontop of what 1.0.2 already did?

As for flush cache, what cache method are you using?

lazee 12-21-2008 01:39 AM
Quote:
Originally Posted by Deceptor (Post 1689960)
lazee, are you saying vB Optimise 1.2.0 made it slower than 1.0.2, or that 1.2.0 didn't make as much difference ontop of what 1.0.2 already did?

As for flush cache, what cache method are you using?
As i see on my board the 1.0.2 reduce server load more than the 1.2.0 does .

The 1.0.2 server load never over 0.85 when my board pass 600 user and guest
The 1.2.0 server load get to 0.95 sometime spike over 1.00 when it 530 user and guest

I used Xcache for cache method.

Deceptor 12-21-2008 01:48 AM
lazee - Are you using the new cache options available from 1.2.0? Like the ability to cache homepage wol and datastore methods?

I'm unable to confirm 1.2.0 adds more load than 1.0.2, especially given the impact that it reduces queries and page generation time further. In either case, if your forum is that active, a change in load from 0.85 to 0.95 is minimal, and given the number of background processes a server does it'd be hard to tell if vB Optimise caused the extra 0.1 server load, you're welcome to test however, I'd recommend watching load over the next few days and seeing if there are any changes.

Also check out your vB debug info, to verify cache is working correctly, and queries are being reduced :)

lazee 12-21-2008 02:02 AM
Quote:
Originally Posted by Deceptor (Post 1689960)
lazee, are you saying vB Optimise 1.2.0 made it slower than 1.0.2, or that 1.2.0 didn't make as much difference ontop of what 1.0.2 already did?

As for flush cache, what cache method are you using?
Quote:
Originally Posted by Deceptor (Post 1689971)
lazee - Are you using the new cache options available from 1.2.0? Like the ability to cache homepage wol and datastore methods?

I'm unable to confirm 1.2.0 adds more load than 1.0.2, especially given the impact that it reduces queries and page generation time further. In either case, if your forum is that active, a change in load from 0.85 to 0.95 is minimal, and given the number of background processes a server does it'd be hard to tell if vB Optimise caused the extra 0.1 server load, you're welcome to test however, I'd recommend watching load over the next few days and seeing if there are any changes.

Also check out your vB debug info, to verify cache is working correctly, and queries are being reduced :)
Yes, i do cache homepage wol and datastore methods.

I will watch couple day and see how the load difference and and turn on the debug.

Btw, it help a lot at server load compare to before i install this optimize, thank you!

Deceptor 12-21-2008 02:05 AM
Gotcha, and I'm glad to hear that overall it is helping you, certainly the direction I'm aiming for here :)

SBlueman 12-21-2008 02:17 AM
I went to activate this modification and got this error:

Quote:
Fatal error: Call to undefined method vb_activecache::connect() in /home/sblueman/public_html/forums/admincp/options.php(1027) : eval()'d code on line 93

Deceptor 12-21-2008 02:28 AM
SBlueman - Try this patch:

Open ./includes/class_activecache.php, Find:
Code:
        function set(){}
Underneath add:
Code:
        function connect()
        {
                return true;
        }
Save and upload, and try then. Overlooked this on my part, let me know if it works and I'll update the download :)

Vitaly 12-21-2008 02:33 AM
Quote:
Originally Posted by Deceptor (Post 1689945)
Vitaly - Some users have said it works on 3.7, others not, this is designed around 3.8 however. Could you tell me the db error that occured? Thanks.
Code:
Database error in vBulletin 3.7.4:

Invalid SQL:

        SELECT
            user.username, (user.options & 512) AS invisible, user.usergroupid,
            session.userid, session.inforum, session.lastactivity, session.useragent,
            IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
        FROM session AS session
        LEFT JOIN user AS user ON(user.userid = session.userid)
        WHERE session.lastactivity >;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 7
Error Number  : 1064
Request Date  : Sunday, December 21st 2008 @ 07:30:26 AM
Error Date    : Sunday, December 21st 2008 @ 07:30:27 AM
Script        : http://forum.rcdesign.ru/
Referrer      :
IP Address    : ****
Username      : ****
Classname    : vB_Database_MySQLi
MySQL Version : 5.0.51a
Have vb 3.7.4 + vbseo + memcached. Latest stable php + eaccelerator and so on...

Just enabled from admincp WOL=60 & refreshed main page. Other pages are ok.

Anyway, I'm not disapponted. WOL feature is not critical. Now vboptimise effect is not noticeable at my site, but will have to wait for middle of monday to compare.

Deceptor 12-21-2008 02:36 AM
Vitaly, if you disable vBSEO and enable the homepage WOL, does the error go away at all? :)

SBlueman 12-21-2008 02:36 AM
Looks like it saved....now.....what do I need to do to see if it's working properly? I am at http://gridironfans.com/


All times are GMT. The time now is 11:58 AM.
Page 6 of 32 « First 45 6 7816 Last »
Show 40 post(s) from this thread on one page

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.02098 seconds
  • Memory Usage 1,847KB
  • 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
  • (5)bbcode_code_printable
  • (16)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