Slow query logger 1.3.1

[m1ne]

Browsing my Member List page generates slow query log also (1.4xx seconds to load :/ )
So I disable Member List Page .

Hmm, not for me. Maybe you have extra addons? We can make a list of addons mentioned in these logs to find common problems. I saw..

- AD Credits
- Lazy Image Loader
- BB Code Manager
- Siropu Chat
- Live Feed (by Milano)

Not a lot of times though.

 

[rdn]

Hmm, not for me.

I got 526,000 members.

Maybe you have extra addons?

I got 42 addons installed and enabled.
But no addon has been mention on my 1st slow query log.

 

[rdn]

Lazy Image Loader

Live Feed (by Milano)

I got this 2 addons installed also.

 

[m1ne]

I got 526,000 members.

But /members/ will load the same amount. Unless you mean a different page?

 

[rdn]

But /members/ will load the same amount. Unless you mean a different page?

I disable this page on my board.

 

[Xon]

No slow queries since disabling Lazy Image Loader which appeared frequently in logs. Strange.

Lazy Image Loader shouldn't be doing any queries, but it may be in the path for something which does if you have image proxy enabled.

If I want to change it to 0.5 seconds, code will be?

<?php

class SV_SlowQueryLogger_Profiler extends Zend_Db_Profiler
{
    protected $reportSlowQueries = false;
    protected $slowQuery = 0.5;

    public function __construct($reportSlowQueries = true, $slowQuery = 0.5, $enabled = false)

Line 6 and 8 should be modified?

Just line 8.

 

[rdn]

Running for 7 hours now and no slow query has been logged.
I'll change it to 0.5, lets see how it goes .

 

[Joeychgo]

where do I find the log?

 

[m1ne]

where do I find the log?

Merges with server error log.

 

[Joeychgo]

Merges with server error log.

thank you

 

[maxicep]

So, why marked as "unmaintained" this add-on ?

 

[Xon]

So, why marked as "unmaintained" this add-on ?

Because I can only offer next to no support and am not planning on updating it, nor will I take feature requests for it.

 

[Xon]

Xon updated Slow query logger with a new update entry:

Feature update release

• Allow slow query threshold to be configured from AdminCP

Thanks @NixFifty

Read the rest of this update entry...

 

[rdn]

But I can't input a value below 1 second?
Like 0.5.

 

[Xon]

Xon updated Slow query logger with a new update entry:

Maintenance update

• Allow slow query threshold to be less than 1 second

Read the rest of this update entry...

 

[Alpha1]

It would be really helpful if this would expose the slow queries in a slow request. It seems that after a slow query report its needed to open debug mode and to manually review all queries in the page request.

Also: I am encountering slow query reports which after inspection of debug output does not include any slow queries.

 

[Xon]

It would be really helpful if this would expose the slow queries in a slow request. It seems that after a slow query report its needed to open debug mode and to manually review all queries in the page request.

This was designed to help troubleshoot some add-ons which only did a few queries rather than a complete end-to-end request performance profiling/monitoring.

Do you anything like DataDog (metrics as a service, with a local collection agent. Rather pricy for more than 5 servers)? I could work this sort of reporting into a paid telemetry add-on if it had somewhere to push it to (such as a StatsD/CollectD server).

Also: I am encountering slow query reports which after inspection of debug output does not include any slow queries.

This add-on measures wall-time from start of the query to the end of the query execution (doesn't include data fetching), rather than the MySQL reported query time. So CPU scheduling latency may cause false(?) positives.

 

[Xon]

Xon updated Slow query logger with a new update entry:

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

Read the rest of this update entry...

 

[Alpha1]

Could you add IP & user-agent to the log? I am getting a lot of slow queries which may be caused by scrapers.

 

[Xon]

Could you add IP & user-agent to the log? I am getting a lot of slow queries which may be caused by scrapers.

At the moment this uses the standard XenForo error log to capture details. Logging any more information would likely require some additional admin-ui.