[DOC] Examples of Slow Query Log should be updated
| 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]
Related branches
- Alexey Kopytov (community): Needs Fixing on 2012-09-05
- Laurynas Biveinis (community): Approve on 2012-09-05
-
Diff: 172 lines (+60/-35)4 files modifieddoc/source/diagnostics/slow_extended_55.rst (+43/-20)
doc/source/installation/apt_repo.rst (+7/-8)
doc/source/installation/yum_repo.rst (+9/-6)
doc/source/release-notes/Percona-Server-5.5.27-28.1.rst (+1/-1)
- Laurynas Biveinis (community): Approve on 2012-09-27
-
Diff: 428 lines (+4/-174)6 files modifieddoc/source/conf.py (+2/-0)
doc/source/index.rst (+1/-0)
doc/source/installation/apt_repo.rst (+0/-69)
doc/source/installation/yum_repo.rst (+0/-84)
doc/source/management/changed_page_tracking.rst (+1/-1)
doc/source/performance/innodb_thread_concurrency_timer_based.rst (+0/-20)
- Laurynas Biveinis (community): Needs Fixing on 2012-10-10
- Alexey Kopytov (community): Approve on 2012-10-09
-
Diff: 135 lines (+76/-5)5 files modifieddoc/source/diagnostics/slow_extended_55.rst (+3/-3)
doc/source/flexibility/max_binlog_files.rst (+30/-0)
doc/source/index.rst (+1/-0)
doc/source/performance/handlersocket.rst (+2/-2)
doc/source/release-notes/Percona-Server-5.5.27-29.0.rst (+40/-0)
| Changed in percona-server: | |
| assignee: | nobody → Rodrigo Gadea (rodrigo-gadea-percona) |
| Changed in percona-server: | |
| assignee: | Rodrigo Gadea (rodrigo-gadea-percona) → nobody |
| Changed in percona-server: | |
| importance: | Undecided → Low |
| status: | New → Triaged |
| Changed in percona-server: | |
| assignee: | nobody → Hrvoje Matijakovic (hrvojem) |
| Roman Vynar (roman-vynar) wrote : | #1 |
| Alexey Kopytov (akopytov) wrote : | #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
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?
| Alexey Kopytov (akopytov) wrote : 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.
Done, bug 1046349, please edit its description if I missed something.
| Shahriyar Rzayev (rzayev-sehriyar) wrote : | #6 |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/
According to pt-query-digest bug https:/
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_*