XF 1.4 High queries on forum_list

[melbo]

It appears that I'm now making 1 query per node on forum_list.
Any idea what might cause something like this?

We haven't really changed anything lately except for our style. The XFMG blocks are only adding a few queries although that was the first thing we disabled.



There are 67 queries that looks like this (only the node ID changes):

 

[Paul B]

Which add-ons do you have installed?

 

[melbo]

1. "Stay Logged In" checked by default 1.1
2. Amazon Parser 2.1
3. Amazon Parser All 2.0
4. AVForums.com - Auto Link Titles 1.0.10
5. Change Thread Starter 1.0.2
6. Conversation Essentials 1.6.2
7. CTA Featured Threads 2.13.1
8. Daily Doodle 1.0.2
9. Digital Point Ad Positioning 1.3.0
10. Ebay Parser 1.4
11. Ebay Parser All 1.4
12. Inactive Members 2.9
13. Insert Attachment 1.3
14. Keyword Replace by Waindigo 1.0.3b
15. Link Check 1.5
16. New User Conversation 2.0
17. Nodes As Tabs 1.2.2
18. Resource Manager - Thread Reassign 1.0.1
19. sonnb - Stop Spam Here 1.3.0
20. sonnb - Stop Spam Here - Botscout API 1.0.0
21. sonnb - Stop Spam Here - FSpamlist API 1.0.1
22. sonnb - Stop Spam Here - SpamBusted API 1.0.0
23. sonnb - Stop Spam Here - Stop Forum Spam API 1.0.2
24. TaigaChat Pro 1.3.0
25. Tapatalk 2.3.8
26. XenForo Media Gallery 1.0.3
27. XenForo Resource Manager 1.1.6
28. [bd] Rotating Ads 2.0
29. [bd] Widget Framework 2.5.9
30. [FreddysHouse] Two-Factor Authentication 1.3.3
31. [ITD] Attachment Icons 1.3.5
32. [MODM] AJAX-Chat Integration for XenForo beta 2
33. [Tinhte] Attach Image Optimization 2.2.11
34. [Tinhte] HTML5 Uploader 1.0.2b
35. [Tinhte] XenTag 2.1.3c

 

[Paul B]

You're going to have to disable them all and re-enable them one at a time to see which queries are introduced for each one.

 

[melbo]

Will try tonight and see what I find.

 

[Paul B]

Post back with your findings.

I'm curious to know which add-on is causing it.

Unless it's mine, in which case just keep quiet

 

[melbo]

Will do. I've dabbled with disabling a few likely culprits with no change.

 

[melbo]

CTA FT&P (nulled of course)...
78-91 queries with CTA FT&P enabled
12 queries with CTA FT&P disabled

Timing: 0.1641 seconds Memory: 10.910 MB DB Queries: 78

 

[melbo]

just kidding @Brogan

Was XenTag

So, next question: if I'm querying against OpCache and memcached, what is the consequence of this?
@xfrocks

 

[xfrocks]

just kidding @Brogan

Was XenTag

So, next question: if I'm querying against OpCache and memcached, what is the consequence of this?
@xfrocks

You disabled XenTag and all 70+ queries go away? Strange because normally that add-on does not do anything on forum_list.

 

[melbo]

Yes and that was the only addon disabled.
I am running a tag cloud on forum_list

 

[xfrocks]

Yes and that was the only addon disabled.
I am running a tag cloud on forum_list

Can you try disabling the tag cloud (instead of disabling the add-on)?

 

[melbo]

Starting - 85 queries
Disabled tag cloud - 82 queries
Disabled XenTag - 19 queries

It's adding a query per node

 

[TPerry]

Are you by chance running with Debug on? It reports higher than what it actually is from what I remember if you have Debug on (and least that's what all the defenders of the high count claimed it did).

 

[melbo]

Thanks Tracy.
No. I keep debug off unless I'm specially needing it on.

I had actually enabled debug mode to remove the annoying code listener that comes back during every tapatalk update when I saw the high query stat.

With debug on I get the above high queries with XenTag enabled and fairly normal with XenTag disabled.

Edit: I've also seen other reports (after narrowing this down) in the XenTag thread that mention queries on forum_list of up to 290ish but haven't read any solutions.

 

[TPerry]

That's been the general consensus. You will see a high count with debug enabled, but in everyday use (where debug should not be on) it's lower. I didn't use the add-on so I can't tell you for sure, but you can monitor the queries with it off if you haven't already.

 

[melbo]

I suppose this can be closed and I'll take it to the proper resource discussion thread.

 

[melbo]

How can I best monitor outside of debug mode?

 

[TPerry]

If VPS/Dedi you can monitor via the mysql ability. I'm nowhere near a SQL guru but a site I frequent said you could do a simple process and they give a couple of different ways.
http://stackoverflow.com/questions/568564/how-can-i-view-live-mysql-queries

 

[melbo]

Will give that a try.
Dedi with MariaDB