Slow query logger 2.2.1

[newimage]

newimage submitted a new resource:

Slow query logger 2.0.1 - logger

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

Read more about this resource...

 

[newimage]

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

 

[jessy]

thanks to dear member @jessy updated Slow query logger with a new update entry:

changelog

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

 

[jessy]

thanks to dear member @jessy updated Slow query logger with a new update entry:

changelog

• 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

Read the rest of this update entry...