how much queries do you have running whan a...

Index page is loading? - 10 q'
forum page is loading? - 15 q'
thread page is loading?- 34-35 q' (something is wrong and it's killing the server..)

I have to find out why the hell i have 35 q' when a thread is loading, its killing my server, somthing like 400 users are entering a page in a sec, do the math :X

so i wanted to see what is the situation on other boards ?

thanks lot for cooperating :]

[dai-kun]

What mods do you have installed? Modifications tends to add queries, especially if you have iSHOP installed.

I'm guessing that you have a lot going on in your postbit.

[Eikinskjaldi]

It's not how many queries you do that matters, it's how long they take.

Run the board in debug mode, and have a look at the explain. It should show you which queries are causing the headache.

[Yellow Slider]

Eikinskjaldi i'm running debug mode, where should i find the explain?
also, how can i see the debug mode as a guest ? i know that it isn't really possible, but i have queries that are running just when guests are visiting the board,
thanks lot.

[mute]

Index: 4
Forum: 7
Thread: 9

We are highly modified however and making use of memcache, etc.

[ragtek]

index: 15
forumdisplay: 16 / in eventboard: 95 (omg i have to do something)
thread: 16 / 33 in eventboard

phu heavy

[Yellow Slider]

Originally Posted by mute

Index: 4
Forum: 7
Thread: 9

We are highly modified however and making use of memcache, etc.

can you explain how? how are you highly modified and don't have lot of queries at all?

here is the the debug info - in a thread..
vBulletin 3.6.7 Debug Information
Page Generation 1.05369 seconds Memory Usage 3,076KB Queries Executed 30 (?)
More Information
Template Usage:
(1)SHOWTHREAD
(1)editor_clientscript
(1)editor_jsoptions_font
(1)editor_jsoptions_size
(15)editor_smilie
(1)editor_smiliebox
(5)editor_smiliebox_row
(1)footer
(1)forumjump
(1)forumrules
(1)gobutton
(1)header
(1)headinclude
(2)im_aim
(5)im_icq
(1)im_msn
(1)im_yahoo
(1)navbar
(4)navbar_link
(1)newpost_disablesmiliesoption
(108)option
(1)pagenav
(1)pagenav_curpage
(1)pagenav_pagelink
(15)postbit_ip
(15)postbit_legacy
(15)postbit_onlinestatus
(15)postbit_wrapper
(1)quickreply_addon
(1)showthread_quickreply
(1)showthread_quickreply_manage
(1)sid_hide_head
(1)smilies_quickreply
(1)spacer_close
(1)spacer_open
(1)threadadmin_imod_menu_post
(1)welcome_headers
Included Files:
vbseo.php
includes/functions_vbseo.php
includes/config_vbseo.php
includes/config.php
showthread.php
global.php
includes/init.php
includes/class_core.php
includes/functions.php
includes/class_hook.php
plugins/vbplaza_fetch_foruminfo.php
plugins/vbplaza_cache_templates.php
ewt/core/functions_spidercheck.php
plugins/vbplaza_global_start.php
includes/functions_bigthree.php
includes/class_postbit.php
includes/class_bbcode.php
includes/functions_reputation.php
plugins/vbplaza_showthread_start.php
plugins/vbplaza_postbit_start.php
plugins/vbplaza_postbit_imicons.php
plugins/vbplaza_postbit_complete.php
includes/functions_editor.php
plugins/vbplaza_forumrules.php

Hooks Called:
init_startup
fetch_userinfo_query
fetch_musername
fetch_userinfo
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
bbcode_parse_start
postbit_imicons
bbcode_parse_complete
postbit_display_complete
pagenav_page
pagenav_complete
editor_wysiwyg_compatible
editor_toolbar_switch
editor_toolbar_start
editor_toolbar_end
forumrules
navbits
navbits_complete
showthread_complete

can some one help me please?
i have somthing like 7-8K uniques a day, 60K~ page views.. (45K reg' users, 1,100,000~ posts etc')

[Eikinskjaldi]

Some where in debug it will tell you how much of that second is php and how much mysql. What is the total mysql processing time?

My guess is your problem is php related. Have you got a memory acelerator installed?

[Yellow Slider]

Originally Posted by Eikinskjaldi

Some where in debug it will tell you how much of that second is php and how much mysql. What is the total mysql processing time?

My guess is your problem is php related. Have you got a memory acelerator installed?

i can't really find where, about the mysql \ php processing time , I got the latest version of eaccelerator (i think 0.9.5)

p.s there is another board on the server, with out any mods, it has a much better generation time, most of the pages have somthing likt 0.05-0.4 sec' but much less modified ( 3.5.8 ) ..

how can i find the queries that makes us an headache ?

in the debug mode there is a Messages:
and there i can choose from a scroll bar lot of things like "today info.. not in cache"
returning default icon / some thing icon id etc'

and if I'll pick one of those nothing will happened :\

what to do?

just realized that that message is the part that gives me the queries , but how do i know which query makes the problem?

[mute]

Originally Posted by Yellow Slider

can you explain how? how are you highly modified and don't have lot of queries at all?

here is the the debug info - in a thread..
vBulletin 3.6.7 Debug Information
Page Generation 1.05369 seconds Memory Usage 3,076KB Queries Executed 30 (?)

can some one help me please?
i have somthing like 7-8K uniques a day, 60K~ page views.. (45K reg' users, 1,100,000~ posts etc')

We're highly modified to REMOVE queries We actually make extensive use of memcache to cache things like templates, which reduces the amount of queries per page actually hitting our database server. There are queries, but they hit memcache, and don't count.