The Arcive of Official vBulletin Modifications Site.

TheInsaneManiac · #1 08-30-2008, 04:36 AM

My host tells me I am running 600 queries right now which caused my database to crash. I am not sure how to view the queries running otherwise I would delete a bunch of modifications eating up my queries. I tried:
mysqladmin processlist

Along with other commands, but nothing...

SEOvB · #2 08-30-2008, 04:42 AM

remove any unnecessary modifications to begin with what all do you have installed.

It also may not even be the addons, if you have a high traffic site you could be getting alot of open connections to the DB from just loading vBulletin.

TheInsaneManiac · #3 08-30-2008, 05:30 PM

Quote:

Originally Posted by FRDS

It also may not even be the addons, if you have a high traffic site you could be getting alot of open connections to the DB from just loading vBulletin.

What can I do to reduce the load from all the open connections?

EDIT: Also what is the ssh command to see ALL of the queirs?

vBsquad · #4 08-31-2008, 12:57 PM

You should ensure that your attachments, avatars and custom profile images are moved to file based storage rather than the database. Additionally ensure AJAX is enabled and disable display of online users to non-members. These are just a few suggestions.

Have you tried mysqladmin -p processlist and logging in?

Marco van Herwaarden · #5 08-31-2008, 01:42 PM

Why would enabling AJAX reduce the number of queries?

TheInsaneManiac · #6 09-03-2008, 06:18 PM

Quote:

Originally Posted by vBsquad

You should ensure that your attachments, avatars and custom profile images are moved to file based storage rather than the database. Additionally ensure AJAX is enabled and disable display of online users to non-members. These are just a few suggestions.

Have you tried mysqladmin -p processlist and logging in?

How many queries would I reduce if I only showed online members to members? Like how many queries does online members use?

Also help me decide what should go:
https://vborg.vbsupport.ru/showthrea...85#post1613285

KHALIK · #7 09-07-2008, 02:22 AM

How many queries does a average "large" board tends to have ?

I have around 24 queries when I open a thread.

22 queries on my Forumhome page.

Dismounted · #8 09-07-2008, 05:57 AM

Queries on a page will be the same on any board, regardless of size, if running a default vBulletin with no modifications.

Lynne · #9 09-07-2008, 02:41 PM

It would be interesting to see a list of default queries per page. I realize for some pages it would be a range based on the options you have turned on, but it might help some users. (ie. if the normal amount of queries for a thread page is just 18 and some guy is getting 60, he may have a clue that perhaps his use of queries on the page aren't very efficient.)

TheInsaneManiac · #10 09-11-2008, 02:00 PM

Quote:

Originally Posted by Lynne

It would be interesting to see a list of default queries per page. I realize for some pages it would be a range based on the options you have turned on, but it might help some users. (ie. if the normal amount of queries for a thread page is just 18 and some guy is getting 60, he may have a clue that perhaps his use of queries on the page aren't very efficient.)

That's a wonderful idea.

Quote:

Originally Posted by KHALIK

How many queries does a average "large" board tends to have ?

I have around 24 queries when I open a thread.

22 queries on my Forumhome page.

I have 18 on my forumhome and 20 on posts. The forumhome amazes me considering I have a shoutbox.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04162 seconds Memory Usage 2,249KB Queries Executed 13 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!