Hi ,
We run the Percona Script but it is running from last 4 hours and no records is Archiving from table and no error is showing also
Script is continuously running without archive any record . please help with the solution
Percon script
pt-archiver --source h=localhost,u=,p='',D=BidCplusN,t=bid_details --where “bd_bid_id in (select b_id from bids join bid_attributes on b_id = ba_bid_id where ba_created_on <= ‘2024-03-20 00:00:00’ and b_status=0)” --no-check-charset --limit=5000 --commit-each --file /db_archive/DraftArchive_before_20032024/%Y-%m-%d-%D.%t 2>> /db_archive/DraftArchive_before_20032024/arch.err
Do you see anything in file?
Or anything in processlist that the user is running?
You can also use dry run to check what query it would use to archive.
Hey @SumitKumar,
Try running like this PTDEBUG=1 pt-archiver ... to see what it is doing. That might give you a clue.