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.

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

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