vb.org Archive - vBMicrostats

Page 12 of 26

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - vBMicrostats (https://vborg.vbsupport.ru/showthread.php?t=116027)

TECK	05-24-2006 03:03 AM

No pain at all, it's a very good idea. :)
Btw, I'm counting on guys like you... that will post the actual code changes.
Go ahead and post them. Thank you for helping out.

EDIT: 26 queries on your front page.. aren't you affraid???

Boofo

05-24-2006 02:17 PM

Or you can do like I did and re-upload the 2 files and you won't have to remember the changes then. ;)

Snake

05-24-2006 06:56 PM

TECK, how do I change the class name from "page" to "tfoot"? And what's up with the debuge mod? It says it's currently off.

Take a look - http://www.bonethugsforums.com/

TECK	05-25-2006 12:36 AM

Edit this code, inside the vBMicroStats Global Hook:

Code:

        // regular users template

        $users_template  = '<tr align="' . $stylevar['right'] . '">' . "\n";

        $users_template .= '        <td class="tcat"' . iif($show['colspan'], ' colspan="' . $colspan . '"') . '>' . "\n";

        $users_template .= '                <span class="smallfont">Page generated in ' . $total_time . ' seconds (' . $php_percent . ' - ' . $sql_percent . ') with ' . $query_count . ' queries</span>' . "\n";

        $users_template .= '        </td>' . "\n";

        $users_template .= '</tr>' . "\n";



        // administrator template

        $admin_template  = '<tr align="' . $stylevar['right'] . '">' . "\n";

        $admin_template .= '        <td class="alt1"' . iif($show['colspan'], ' colspan="' . $colspan . '"') . '>' . "\n";

        $admin_template .= '                <span class="smallfont">' . $memory_status . $debug_status . $gzip_status . $server_status . $templates_status . '</span>' . "\n";

        $admin_template .= '        </td>' . "\n";

        $admin_template .= '</tr>' . "\n";

Debug mode is always OFF, unless you add this line into your config.php file:
$config['Misc']['debug'] = true;

This is more like a security feature, in case you forget about it...

Snake

05-25-2006 09:29 PM

Oh thanks for your support! :)

Boofo

05-25-2006 09:51 PM

Is it normal for this:

Quote:

(33.50% PHP - 66.50% MySQL)

to flucuate to this:

Quote:

(76.21% PHP - 23.79% MySQL)

constantly? That is the report bad post page (with 7 queries) and it seems to go back and forth with almost every page refresh, or two. Not complaining, Teck, just curious. ;)

EDIT: Well, I just had this one show up on the same page:

Quote:

(-10.93% PHP - 110.93% MySQL)

;)

Raptor

05-25-2006 11:10 PM

what are my numbers like re: performance

Page generated in 1.18516898 seconds (49.02% PHP - 50.98% MySQL) with 14 queries
4,182.56KB Used | DEBUG Mode OFF | GZIP ON (level 1) | NO Uncached Templates

TECK	05-26-2006 05:49 AM

Bob, do you have a cache installed? That's what it generates a SQL spike...
I actually opened a ticket for this matter to vBulletin, their own code generates the same results...
http://www.vbulletin.com/forum/bugs3...iew&bugid=2481

So far Scott and Freddie are looking for a solution, the bug was confirmed.
The issue we are dealing with is the following:
Once a query is cached, the SQL execution time (%) gets low, only the connection time and other non cached SQL processes are filtered by vBMicroStats. Then, once the queries are not in the cache anymore, BOOM, a heavy SQL demand is passed to the server.

That explains the high SQL % you get sometimes. I'm in the same boat, no fix possible in my eyes, that's the way caches work.
I hope vB Team will find a trick in their hat. read more in the bug thread I opened.

Boofo

05-26-2006 08:32 AM

No, sir, no cache installed at all. I didn't notice it on the earlier versions of this hack but then I didn't really check it that closely then. I'll wait to hear what you find out. ;)

TECK	05-26-2006 04:20 PM

Hmm. It should be stable then, except when the VB default query cache is performed.

Do this: Open a support ticket with vBulletin and ask why the query time and php time are not at all stable, all the time.
They will ask you to show them the exact probem...
Enable Debug Mode then let them see the explained queries. You will notice (at the end of the page in bold) that the query execution time at the end varies in a similar way, maybe a little higher then vBMicroStats.

Post the ticket results for all of us. IMO, it's someting related to the server? vBMicroStats actually reads what is fed into the script, that's all.

All times are GMT. The time now is 01:41 AM.

Page 12 of 26

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01222 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 (1)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)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
Messages: