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 :]

[kmike]

Index - 3 queries
forumdisplay - 9 queries (with "currently active users" enabled)
showthread - 7 queries

[Yellow Slider]

Originally Posted by mute

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.

Originally Posted by kmike

Index - 3 queries
forumdisplay - 9 queries (with "currently active users" enabled)
showthread - 7 queries

I've read both of yours posts on VB com , in Kron's (muts) thread "Some tuning tips from the MySQL experts" and i have to say that I'm really impressed , i don't have lot of SQL + PHP knowledge but my partner will try to do the things that you had said there , I've installed memcache (https://vborg.vbsupport.ru/showthread.php?t=150431) and i would really like to know how can i do that -

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.

looking forward to your replies, thanks lot.

p.s - this is my board http://www.atraf-f.net (running in Hebrew ) I just wanted you to have a look at the index look, in your opinion can i optimize the code that makes the index to look like that? I'll upload it if you think you can give me an hand with optimizing it .

thanks

[ThorstenA]

Originally Posted by mute

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.

Originally Posted by kmike

Index - 3 queries
forumdisplay - 9 queries (with "currently active users" enabled)
showthread - 7 queries

It would be so great to know more about your tuning!

[Yellow Slider]

It's killing me, I have 2 boards on my server one has a DB which weights 320 MB
the other one is 800~ MB, and im using memcache (and there isn't any improvement in the page generation time)
- first board - On index Executed 9 queries (0.1.. s')
inside a forum Executed 13 queries (0.2)
inside a thread Executed 9 queries(0.2)
DB 300 MB ( 1 modification installed )

- second board (3.6.7)
on index - Queries Executed 9 (0.66 s')
in a forum - Executed 14 (1.6 s' DAMT!!)
in a thread Queries Executed 24 (0.9 s') (24 que' What The Hell?!)
DB 800 MB (highly modified) - running memcache and it hadn't helped at all..
how can i decrease the page generation time?

i run debug mode, and i don't really know how to read this tool output..

I have to do somthing..

Thanks lot..

[ThorstenA]

You could ask on vbulletin.com -> Server Configuration Forum for more help!

[Yellow Slider]

It has nothing to do with the server, this is pure programming ..
I have optimized my server, most of the show users online are off , I really don't know what to do, maybe it has something to do with the MySql collection, because we had converted our DB to UTF8 and it had grown form 500 MB to 800..
but I don't think that it's relevant because the other board DB was coverted to UTF8 too and it is running pretty fast..

I'll be happy to get some tips \ help..

[mute]

Unfortunately I can't really help any more than I have in my many posts over at vBulletin.com (search for posts by username KrON).

I have outlined some of the steps we've taken, but I can't really provide actual directions or provide support for modifications made.

A lot of the steps we've taken are complicated or proprietary and not really something to be undertaken by anyone but people with a solid background in PHP and vBulletin.

[Yellow Slider]

I have a partner which have s a solid background in PHP and vBulletin,
I'm asking you for tips , how to know which queries are getting us the reason that we have high Page Generation time, i saw the tool you gave on VB.com but i can't compile MYSQL from source cous it can make problems with the DB cous my board is in Hebrew..

what can i do? i just want to get rid from 5-10 unuseful queries, that are delaying our page load time..

[mute]

Well that tool I gave you is very beneficial. You don't have to apply the microslow patch to use the query analyzer I don't think. Turn on your slowquery log. Log your queries for a while, then work backwards to see what queries are taking the most time, and figure out what functionality they relate to.

[BartS]

Index: 9
Forum: 16
Thread: 10

Happy with it (we have about 10-15 mods installed), but I will get worried about the 16 query forum display when our board gets more visitors.