Sample Header Ad - 728x90

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