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)

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 07:22 PM.

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.03009 seconds
  • Memory Usage 1,744KB
  • 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
  • (3)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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