Get the App
SLTechnology News&Howtos  ›  Database  › 

Pt-duplicate-key-checker checks the database for duplicate indexes

Shulou Source: shulou.com Published: 2022-06-01 05:19:07 10月03日 Update

Refer to this blog

http://blog.csdn.net/z1547840014/article/details/10198237

Check redundant indexes for all libraries

pt-duplicate-key-checker --user=root --password=cG3sBD9mazGI --host=192.168.27.21

native

pt-duplicate-key-checker --user=root --password=cG3sBD9mazGI --host=localhost

Check native redundant index and output to index.sql file

pt-duplicate-key-checker --user=root --password=cG3sBD9mazGI --host=localhost>index.sql

Tags: Index check redundancy native blog file reference output data database Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Redmi Shulou Technology MariaDB Shulou Information Apple