Done
Details
Assignee
UnassignedUnassignedReporter
lpjirasynclpjirasync(Deactivated)Priority
Low
Details
Details
Assignee
Unassigned
UnassignedReporter
lpjirasync
lpjirasync(Deactivated)Priority
Smart Checklist
Smart Checklist
Smart Checklist
Created January 24, 2018 at 5:11 AM
Updated January 24, 2018 at 5:11 AM
Resolved January 24, 2018 at 5:11 AM
**Reported in Launchpad by Laurynas Biveinis last update 11-02-2013 09:25:21
The regexps that filter out the InnoDB stats do not handle the case of the waiting times happening to be integer values, resulting in sporadic extraneous lines in mysqldumpslow output.
Fix:
— Percona-Server/scripts/mysqldumpslow.sh 2012-01-30 04:30:33 +0000
+++ Percona-Server/scripts/mysqldumpslow.sh 2013-01-09 11:27:48 +0000
@@ -126,9 +126,9 @@
s/^# Filesort: \S+ Filesort_on_disk: \S+ Merge_passes: \S+\n//;
s/^# InnoDB_IO_r_ops: \d+ InnoDB_IO_r_bytes: \d+ InnoDB_IO_r_wait: \d+\.\d+\n//;
+ s/^# InnoDB_IO_r_ops: \d+ InnoDB_IO_r_bytes: \d+ InnoDB_IO_r_wait: \d+(\.\d+)?\n//;
s/^# InnoDB_rec_lock_wait: \d+\.\d+ InnoDB_queue_wait: \d+\.\d+\n//;
+ s/^# InnoDB_rec_lock_wait: \d+(\.\d+)? InnoDB_queue_wait: \d+(\.\d+)?\n//;
s/^# InnoDB_pages_distinct: \d+\n//;