Query Performance Profiling

Ghan_04

Active member
I've noticed lately that our board is pushing about 6,000 queries per second and the database is taking up around 50-60% of the CPU (there are 2 cores on this VM). We typically have somewhere between 500 and 1000 users online at a time so it's consistent traffic, but this seems high.
I've looked at the debug output and I'm seeing 10-15 queries per page around the main pages (forum index, forum thread display, inside a thread) so I assume all that is normal. We do have a number of addons, but I don't really know how to go about figuring out which ones might be causing additional query traffic other than to just disable them one at a time and see what happens. Are there any less disruptive ways to profile what the software is doing so I know where the hardware resources are being spent?

We don't have any performance impacts (at least not yet) but I'd like a better understanding of what's going on so I can make better decisions in the future. Any insight would be appreciated.

[AddonsLab] Thread Filter by AddonsLab
[AL] Core Package by AddonsLab
[bd] Medal by XFROCKS
[Liam W.] Post Macros by Xen-Soluce
[TH] Covers by ThemeHouse
[TH] Reactions Plus by ThemeHouse
Accordion by Lyrositor
Admin Log Search by Atelier Aphelion
Alert Improvements by Xon
Collaborative Threads by Atelier Aphelion
Conversation Essentials by Atelier Aphelion
Conversation Improvements by Atelier Aphelion
Conversation Sharing by Atelier Aphelion
CSS Image Proxying Utils by Lyrositor
Dice Roller by Xon
Discord Integration by NixFifty
ElasticSearch Essentials by Atelier Aphelion
Extra Cli tools by Xon
Font Awesome
Google Fonts by Lyrositor
Live Content by Xon
Multiple account report to Thread by Xon
Optimized List Queries by Xon
Redis backed Flood Checking by Xon
Redis backed Views Counters by Xon
Redis Cache by Xon
Search Improvements by Atelier Aphelion
Signup abuse detection and blocking by Xon
Standard Library by Atelier Aphelion
Tabs by Lyrositor
Threadmarks by Xon
User Activity by Xon
User Essentials by Atelier Aphelion
User Mentions Improvements by Xon
Vote Tally by Atelier Aphelion
Word Count Search by Xon
XenForo Enhanced Search by XenForo Ltd.
XenForo Media Gallery by XenForo Ltd.
 
Last edited:
Top