vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)
-   -   need help understanding explain=1 information (https://vborg.vbsupport.ru/showthread.php?t=53798)

Harley D 06-03-2003 03:04 PM

need help understanding explain=1 information
 
I found that my queries average :

Server: 3.23.54
? Client: 3.23.52
? Protocol-Version: 10
? Uptime: 1714022
? Threads: 16
? Questions: 2076810
? Slow queries: 6
? Opens: 8275
? Flush tables: 1
? Open tables: 64 Queries per second avg : 1.212

here is the onfo I get
Quote:


I'm a nuub, ya probably guessed that by now :)
but what am I looking for exactly, and what changes do you suggest I make?

Thanks in advance.

filburt1 06-03-2003 03:37 PM

It shows:

1. What queries were executed
2. How long they took (after - before = elapsed, don't know why it wouldn't do that itself...)
3. How many queries were executed total
4. Total page generation time

It's dangerous because users can see the raw queries. How specifically that can be bad, I don't know (maybe some obscure XSS problem where you can steal hashes).

Harley D 06-03-2003 04:39 PM

Thank you.


All times are GMT. The time now is 03:55 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.01426 seconds
  • Memory Usage 1,709KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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