Shulou(Shulou.com)06/01 Report--

Pt-archiver is a tool in pt-toolkit for archiving and transferring data to offline databases or other databases

Examples

Archive all rows from oltp_server to olap_server and to a file:

Pt-archiver-- source hoboltpads, serverdictionDruntestGradittbl-- dest h=olap_server\

-- file'/ var/log/archive/%Y-%m-%d-%D.%t'\

-- where "1x 1"-- limit 1000-- commit-each

Purge (delete) orphan rows from child table:

Pt-archiver-- source hobby host.Dobb _ dwelling _ child-- purge\

-- where 'NOT EXISTS (SELECT * FROM parent WHERE col=child.col)'

Example:

Root@python-develpment:~# pt-archiver-- source hobbies 192.168.134.186 people 3306 people who use upright ptLicure ArchiveDiffect 123456 people log in-- where='logintime

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.