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

pt-archiver - multitable delete or delete from with join

LoggerLogger EntrantCurrent User Role Beginner
Hi everybody.
Can we use pt-archiver for archiving or purging data from tables with FK using join. I did not find any examples or info in documentation about this.
Can you advice?

Example delete query.

delete testdb1.tbl1 from testdb1.tbl1
inner join testdb1.tbl2 on testdb1.tbl1.tbl1_id=testdb1.tbl2.tbl2_id
where testdb1.tbl2.updated=?
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.