Percona Server moved to https://jira.percona.com/projects/PS

[DOC] Examples of Slow Query Log should be updated

Bug #868002 reported by Rodrigo Gadea on 2011-10-05

6

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Percona Server moved to https://jira.percona.com/projects/PS	Fix Released	Low	Hrvoje Matijakovic
	5.1	Fix Released	Low	Hrvoje Matijakovic
	5.5	Fix Released	Low	Hrvoje Matijakovic

Bug Description

[In:5.5:Slow Query Log]

Tags:

Related branches

lp:~hrvojem/percona-server/bug868002-5.5

On hold for merging into lp:percona-server/5.5

Alexey Kopytov (community): Needs Fixing on 2012-09-05

Laurynas Biveinis (community): Approve on 2012-09-05

lp:~hrvojem/percona-server/bug1034305-5.5

Merged into lp:percona-server/5.5 at revision 302

Laurynas Biveinis (community): Approve on 2012-09-27

lp:~hrvojem/percona-server/rn-5.5.27-29.0

Merged into lp:percona-server/5.5 at revision 314

Laurynas Biveinis (community): Needs Fixing on 2012-10-10

Alexey Kopytov (community): Approve on 2012-10-09

Rodrigo Gadea (rodrigo-gadea-percona) on 2011-10-05

Changed in percona-server:
assignee:	nobody → Rodrigo Gadea (rodrigo-gadea-percona)

Stewart Smith (stewart) on 2011-10-17

Changed in percona-server:
assignee:	Rodrigo Gadea (rodrigo-gadea-percona) → nobody

Stewart Smith (stewart) on 2011-12-01

Changed in percona-server:
importance:	Undecided → Low
status:	New → Triaged

Laurynas Biveinis (laurynas-biveinis) on 2012-05-31

Changed in percona-server:
assignee:	nobody → Hrvoje Matijakovic (hrvojem)

Revision history for this message

Roman Vynar (roman-vynar) wrote on 2012-08-26:

#1

According to pt-query-digest bug https://bugs.launchpad.net/percona-toolkit/+bug/963225 the doc page http://www.percona.com/doc/percona-server/5.5/diagnostics/slow_extended_55.html should be updated this way:

1. qc_miss changed to qc_hit;

2. Outputs like:
# QC_Hit: No Full_scan: No Full_join: No Tmp_table: Yes Disk_tmp_table: No
# Filesort: Yes Disk_filesort: No Merge_passes: 0.

should list Tmp_table_on_disk, Filesort_on_disk rather than Disk_*

Revision history for this message

Alexey Kopytov (akopytov) wrote on 2012-09-05:

#2

The log_slow_filter value accepted by the server is qc_miss rather than qc_hit. Which is inconsistent with the "QC_Hit:" value printed in the slow log, but we have to live with that as we cannot change it in stable releases

Revision history for this message

Laurynas Biveinis (laurynas-biveinis) wrote on 2012-09-05:

#3

Perhaps we should target this bug to 5.6 then? To serve as a reminder to look into this when the feature is ported to 5.6?

Revision history for this message

Alexey Kopytov (akopytov) wrote on 2012-09-05: Re: [Bug 868002] Re: [DOC] Examples of Slow Query Log should be updated

#4

On 05.09.12 17:53, Laurynas Biveinis wrote:
> Perhaps we should target this bug to 5.6 then? To serve as a reminder to
> look into this when the feature is ported to 5.6?
>

I'd create a separate bug to rename the log_slow_filter value to
something less confusing in 5.6, but leave this bug as a request to fix
docs in 5.1/5.5.

Revision history for this message

Laurynas Biveinis (laurynas-biveinis) wrote on 2012-09-05:

#5

Done, bug 1046349, please edit its description if I missed something.

Revision history for this message

Shahriyar Rzayev (rzayev-sehriyar) wrote on 2018-01-25:

#6

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1890

Report a bug

This report contains Public information

Everyone can see this information.

You are

Subscribing...

Edit bug mail

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.