lundi 9 février 2015

mysqlslow - excluding queries from mysqldump


I would like to ignore the queries in my mysql-slow log that originate from mysqldump using SQL_NO_CACHE as the trigger word.


My experiences 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, but always get back 'Died at /usr/bin/mysqldumpslow line 162'



mysqlslowdump -g '!(SQL_NO_CACHE)' /path/to/my/log
mysqlslowdump -g '^!(SQL_NO_CACHE)$' /path/to/my/log




Aucun commentaire:

Enregistrer un commentaire