xF2 Add-on Slow query logger 2.2.1

[ENXF NET]

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

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

 

[ENXF NET]

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

 

[ENXF NET]

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

 

[ENXF NET]

ENXF NET updated Slow query logger with a new update entry:

2.2.1 - Bugfix update

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