Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 30 Aug 2008, 05:36
TheInsaneManiac TheInsaneManiac is offline
 
Join Date: Feb 2008
A lot of queries!

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...
Reply With Quote
  #2  
Old 30 Aug 2008, 05:42
SEOvB's Avatar
SEOvB SEOvB is offline
 
Join Date: May 2007
Real name: Jarvis
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.
__________________
vBulletin Services and vBulletin Hosting
Reply With Quote
  #3  
Old 30 Aug 2008, 18:30
TheInsaneManiac TheInsaneManiac is offline
 
Join Date: Feb 2008
Originally Posted by FRDS View Post
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?

Last edited by TheInsaneManiac; 30 Aug 2008 at 23:23.
Reply With Quote
  #4  
Old 31 Aug 2008, 13:57
vBsquad vBsquad is offline
 
Join Date: Sep 2007
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?
Reply With Quote
  #5  
Old 31 Aug 2008, 14:42
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Why would enabling AJAX reduce the number of queries?
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #6  
Old 03 Sep 2008, 19:18
TheInsaneManiac TheInsaneManiac is offline
 
Join Date: Feb 2008
Originally Posted by vBsquad View Post
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:
http://www.vbulletin.org/forum/showt...85#post1613285
Reply With Quote
  #7  
Old 07 Sep 2008, 03:22
KHALIK KHALIK is offline
 
Join Date: May 2005
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.
Reply With Quote
  #8  
Old 07 Sep 2008, 06:57
Dismounted's Avatar
Dismounted Dismounted is offline
 
Join Date: Jun 2005
Real name: Hanson
Queries on a page will be the same on any board, regardless of size, if running a default vBulletin with no modifications.
__________________
Former vBulletin.org Staff Member

View My Modifications
29 Releases and Counting... Latest Modification: dmActivityStream - vBookie Integration (4.x)

Please do not PM me to ask for support - please use the relevant thread or forum.
Reply With Quote
  #9  
Old 07 Sep 2008, 15:41
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: 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.)
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #10  
Old 11 Sep 2008, 15:00
TheInsaneManiac TheInsaneManiac is offline
 
Join Date: Feb 2008
Originally Posted by Lynne View Post
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.

Originally Posted by KHALIK View Post
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.
Reply With Quote
  #11  
Old 12 Sep 2008, 18:04
TECK's Avatar
TECK TECK is offline
 
Join Date: Dec 2001
Real name: Floren Munteanu
Turn the debug mode ON, so you will be able to quickly see detailed information about your query execution. Remove all currently installed products and start adding one by one, while examining the number of queries executed.

Personally, I would recommend you to uninstall all products and leave the standard vBulletin software untouched (code related).
__________________
Floren Munteanu
Axivo Inc.
Axivo Community - Visit the forums to find out more about us
Why Queued - My personal blog
Reply With Quote
  #12  
Old 13 Sep 2008, 12:19
nexialys
Guest
 
Originally Posted by Lynne View Post
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.)
best way to do so is by having a default/clean vBulletin, with 100 threads, 10 replies in each, 10 users with avatars etc... open the debug mode, and visit your site...

usually, the number of queries for plain site is about 10 to 15 per page... vBulletin is built to spare on dB queries, but the number is not so important.. if the queries are well built, they are more efficient. a lot of modification use no structural queries, simply by "SELECT ALL FROM TABLE" which is stupid and can be slower than specific selects...
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 17:44.

Layout Options | Width: Wide Color: