Not the answer you need?
Register and ask your own question!

pt-kill multiple --ignore-info possible?

andyshinnandyshinn EntrantInactive User Role Beginner
I'm trying to run pt-kill 2.2.5 with a configuration file like:

busy-time=60
print
kill
user=myuser
password=mypass
log=/var/log/pt-kill.log
ignore-info=INSERT INTO mynewtable \(id, title\)\W*SELECT id, title\W*FROM myoldtable
ignore-info=INSERT INTO mynewtable2 \(id, title\)\W*SELECT id, title\W*FROM myoldtable2

But it doesn't appear to work (my first query was killed after 60 seconds). Is it possible to specify multiple ignore-info lines like this in the config file or command line?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.