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

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

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.