Add-ons Slow query logger 2.2.2

[XenForo]

XenForo submitted a new resource:

Slow query logger - Generate a stack trace on slow queries

Generates an error log entry when a slow query is detected. No configuration required.

Read more about this resource...

 

[XenForo]

XenForo updated Slow query logger with a new update entry:

2.1.0 - Feature update

• Require php 7+
• Update add-on options to have their own additional input-group and to be better formatted
• Add "Too many queries threshold" option to help detect N+1 query behaviour. With various options to skip possible false positives.

Read the rest of this update entry...

 

[XenForo]

XenForo updated Slow query logger with a new update entry:

2.2.0 - Maintenance & bugfix update

• Require XenForo 2.2+
• Require php 7.2+
• Fix infinite recussion which could result in segfaults when the caching backend is empty and fetching XF options triggers a database query
• Prune stacktrace from sql query logs once >150 queries are collected, and be more aggressive about flipping LogSimpleOnly flag
• Only collect stack-traces if the _debug flag is present in the request

Read the rest of this update entry...

 

[Lenox]

Does it start automatically?
Where can I find the log file?

 

[Solar]

Does it start automatically?
Where can I find the log file?

• Works on a single query at a time, not all queries for a request.
• Only logs slow public queries.