Slow Query Log Analyzer

[sandhya.r]

Hi,

As per design MONyog will display only the top 200 records in the Query analyzer page.

Sorting the result causes the sort algorithm to be applied to the entire table but only the top 200 rows are displayed.

Regards,

Sandhya

[ratheesh kaniyala]

Hi Sandhya,

Is there any future plans to show all records (may be using pagination). Or at least to export all records into CSV. Because in a production environment where we want to generate a report of slow queries for a whole month, the top 200 records will just list for the ast 5 or 6 days.

This is a very good feature to have.

'sandhya.r' wrote on '30:

Hi,

As per design MONyog will display only the top 200 records in the Query analyzer page.

Sorting the result causes the sort algorithm to be applied to the entire table but only the top 200 rows are displayed.

Regards,

Sandhya

[sandhya.r]

Hi,

This request is added in our issue tracker. But priority is not set. We will update on this once this request is taken.

Thank you for your valuable requests.

Regards,

Sandhya

[ratheesh kaniyala]

The “Export As CSV” option eats up all the CPU and never finishes when we do a sort on any column (say count) and then click Export. And I cannot stop MonYog service too when this happens. It fails.

The slow query log analyzer is such a good and important feature in MonYog but cannot be used effectively because of its limitations mentioned in this thread.

I am attaching a screen shot of the cpu/memory usage by MonYog at the time of doing this operation for your reference. And the cpu usage never drops after this.

—

Ratheesh

[Sayan Chaliha]

Hi Ratheesh,

We'll get rid of this limitation with priority.

Also, I'm moving this discussion to our support system. Issues like these are more easily managed there.

http://webyog.com/support/ttx.cgi?cmd=ticket&key=9316Z1490036918618127238

[Author]

Posts