[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: doc Edit Tag help

Related branches

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
Changed in percona-server:
assignee: nobody → Hrvoje Matijakovic (hrvojem)
Roman Vynar (roman-vynar) wrote :

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_*

Alexey Kopytov (akopytov) wrote :

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

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?

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.

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

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

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers