Slow query logger 2.2.1

newimage · Jul 10, 2020

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 · Sep 1, 2021

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.

Click to expand...

Read the rest of this update entry...

jessy · Apr 17, 2023

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 · Apr 29, 2023

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