How To Exclude Queries Returned From mysqldumpslow Command
3
votes
2
answers
1047
views
I would like to ignore queries in the mysql-slow log that originate from running the command
mysqldumpslow
by using SQL_NO_CACHE
as the trigger word.
My experience using regex are limited at best and I'm unable to find any examples in the docs.
I've tried a few variations of the following:
mysqlslowdump -g '!(SQL_NO_CACHE)' /path/to/my/log
mysqlslowdump -g '^!(SQL_NO_CACHE)$' /path/to/my/log
... but always get back:
> Died at /usr/bin/mysqldumpslow line 162
What is wrong in my regex?
Asked by KDrewiske
(131 rep)
Feb 9, 2015, 08:21 PM
Last activity: Feb 19, 2021, 02:49 PM
Last activity: Feb 19, 2021, 02:49 PM