vb.org Archive - VPs Load

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

- Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)

- - VPs Load (https://vborg.vbsupport.ru/showthread.php?t=199511)

hello recently i have installed my old forum updated it and installed on selected hacks however i have installed this vbmicrostats to see my server loads and i am quite surprised without any user online my stats are this kindly see screenshot

can someone plz tell me if this normal ? i dun think so if its not how can optimize it however i have now installed vboptimize also but this is still the result

waitin for some good suggestions

if needed i can provide with the list of hacks i have installed on forum to

89 queries for any page is not "normal". Most likely, you have a lot of modifications installed, or a modification that does lots of queries.

89 queries my gudness it should really hang you up any moment, just try to list out the modifications you have made so that we could get an idea where you have such a heavy query load

ok here is the list of hacks installed on my forum

Code:

1.Quick Mod Tools

2.Atakan Marquee Text

3.Ban Thread User

4.Change Ports Owner

5.CYB - Advanced forum Statistics

6.Cyb- Advanced Permissions Based on Post Count

7.Cyb- ChatBox

8.cyb- Check if Already Posted

9.Cyb Top posters in Month

10.Fake users (disabled)

11.Force users to read a Thread

12.Gender Bit

13.Imageshack/Megaupload file uploader

14.Itrader

15. KPT signature limit

16.Members who have posted

17.Members Who visted

18.Miserable users

19.Multiple login Detector

20.Need x Posts to vote

21.Show profile Fiedls in postbit

22.Userlog on profile

23.Username HTML Markup

24.Vbexperiance

25.Vb Optimise

26.Vbexperiance level

27.VbFirewall

28.VBMicrostats

29.Via Postbit-Force User To Read A Thread

30.View Forum Leaders Based On Usergroup Permissions

31.Who Has Read a Thread.

32.ZH - Sticky Thread Mark-Up

33.Spam Decimater (disabled)

34.Inactive user reminder email (disabled)

Can u plz help me how can i reduce the query's ? as 2 times mysql died today

Btw how can we check tht wich hack or wich code is creating so much query's ? is their any mod wich can check and tell us wich hack is creating tht much load ? i think their shud be something like this in vb itself kindly help me

Disable the modifications 1by1 and check if the number of queries drops.

Thanks i have figured wich hack was creating this much querys it is "Username HTML Markup" ill not suggest this hack to anyone just by disabling it my 70 querys got reduced .....

Haha, let me guess: it created a query for each user online?

It was this hack, right?
https://vborg.vbsupport.ru/showthread.php?t=199109

It still has 30 installs lol, would go down as soon as people start noticing 80-100 queries.

Such mods should move to mod grave.

ya veenuisthebest its that one and right it shud be moved to mod grave

Marco wut it did was created a single query for every single username and category/forum displayed on the whole index page to show them in their color lol and today i figured out why last time 1 year back my forum was used to that slow bcz i had this hack on it to when i was using 3.6 lol m laughin on myself now

This again shows that it is not important how many modifications you have installed, but how well they are written.

X vBulletin 3.8.12 by vBS Debug 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 (1)footer (1)gobutton (1)header (1)headinclude (6)option (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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01084 seconds Memory Usage 1,727KB 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 (1)footer (1)gobutton (1)header (1)headinclude (6)option (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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: