xF1 Slow query logger

[ven0m]

Heisenberg submitted a new resource:

You must be registered for see links

- Generate a stack trace on slow queries

Additional Requirements:
php 5.6+
License:
MIT Licence
Visible Branding:
No
Generates an error log entry when a slow query is detected. No configuration required.

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

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

You must be registered for see links

 

[ven0m]

Heisenberg updated

You must be registered for see links

with a new update entry:

You must be registered for see links

Feature update
Now reports slow transactions.

• May get confused with nested transactions.
• May not capture all transactions.
• May invalidate assumptions if using a non-default/custom profiler

You must be registered for see links

 

[ven0m]

Heisenberg updated

You must be registered for see links

with a new update entry:

You must be registered for see links

Please update or disable this add-on ASAP

• Prevent potential catastrophic data-loss due to re-using the database connection when reporting a slow individual query.
  • Slow transactions reporting is OK
  • When moving posts between threads, this can cause the permanent deleting of any source thread(s) if the slow query logging is triggered.

You must be registered for see links

 

[ven0m]

Heisenberg updated

You must be registered for see links

with a new update entry:

You must be registered for see links

• Fix error when reporting a slow query.

You must be registered for see links

 

[ven0m]

Heisenberg updated

You must be registered for see links

with a new update entry:

You must be registered for see links

Add "Track stack traces for queries" option (default disabled)

• On the debug output page, displays a stack trace under the explain table.

You must be registered for see links