Slow query logger 2.2.2

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

Once it has been running and reporting issues, I recommend disabling the add-on until you have pushed out fixes or understood why the previous logged queries are occurring.

It is not recommended to leave this add-on enabled.



The initial start of a search is known to take a while, this appears to be a design issue where all content needs to be loaded and then verified.

Limitations...

Click to expand...

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

Click to expand...

Click to expand...

• 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

Click to expand...

• Fix various numerical admincp options which did not step in the incremental values as intended, while allowing arbitrary values in the range to be entered

Click to expand...

[*]Confirm XF2.3 support
[*]Minor maintenance update

Click to expand...