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

Find duplicate indexes and foreign keys and generate statements to delete duplicate indexes

Pt-duplicate-key-checker-user=root-password=energy@db-port=3307

Interactive check system io tool

Pt-diskstats-interval 5-iterations 10

Run for 4 hours with an interval of 30s each time, and run in the background

Pt-deadlock-logger upright rootforpenergytraindb-daemonize-run-time=4-interval=30s

Pt-table-checksum detects mysql master-slave consistency

Pt-table-checksum-user=user--password=password-host=host1--port=port-databases=db_name-tables=tablename-recursion-method=processlist

Pt-table-sync repairs slave data

Pt-table-sync-- execute-- replicate percona.checksums-- sync-to-master hobbies host2, Prun3306, Upright userpagePlease password

Pt-find Lookup Table

Pt-find-- user=root-- password=energy@db-- tablesize + 5G

Pt-find-- user=root-- password=energy@db-- printf "% T\ t%D.%N\ n"-- tablesize + 5G | sort-rn

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.