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...

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.

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?

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?

Why would enabling AJAX reduce the number of queries?

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:
https://vborg.vbsupport.ru/showthrea...85#post1613285

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.

Queries on a page will be the same on any board, regardless of size, if running a default vBulletin with no modifications.

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.

I have 18 on my forumhome and 20 on posts. The forumhome amazes me considering I have a shoutbox.