LP #1097692: Broken filtering out of InnoDB stats in mysqldumpslow

Description

**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//;

Environment

None

Smart Checklist

Activity

Done

Details

Assignee

Reporter

Priority

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