vb.org Archive - Finding out queries

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

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - Finding out queries (https://vborg.vbsupport.ru/showthread.php?t=156688)

djdonx

08-31-2007 08:46 AM

Finding out queries

Okay so I don't understand all this tech stuff ;p

I was just wondering, how do I find out how many server queries my forum is running and whats the ideal/maximum amount it should be?

Thanks in advance for any help :)

Antivirus

08-31-2007 09:19 AM

you need to turn on debug mode. After doing so, you'll see a message in the forum telling how many queries are being run, and the option to run explain on them which will give you info on how well they are optimized.

djdonx

08-31-2007 09:23 AM

How do I turn debug mode on? :S

Opserty

08-31-2007 09:26 AM

Quote:

How do I turn on debug mode?

Please note that you should not turn on debug mode in a live environment.

Open the config.php file.
At the top, on a new line below <?php
add: $config['Misc']['debug'] = true;

http://www.vbulletin.com/docs/html/t..._externalfiles

or you can add it at the very bottom of the config.php file.

djdonx

08-31-2007 09:29 AM

Oh I think I'll give it a miss. I don't like changing the code alot like that, last time I did I broke my forum for 3 days. Hehe.

Antivirus

08-31-2007 09:31 AM

You can also turn it on just for your ip so no-one sees it but you like follows:

PHP Code:


		
			
//    ****** DEBUG MODE ******

//    Turn on debug mode for any specific ip.

    $config['Misc']['debug'] = ($_SERVER['REMOTE_ADDR'] == 'xx.xxx.xxx.xx');

then simply replace xx.xxx.xxx.xx with your ip address. If you don't know your own ip, visit www.whatismyip.com

All times are GMT. The time now is 07:53 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01032 seconds Memory Usage 1,720KB 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_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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: