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=?