mysql 删除重复索引pt-duplicate-key-checker

最新推荐文章于 2023-02-27 10:02:11 发布

胡萝卜的兔

最新推荐文章于 2023-02-27 10:02:11 发布

阅读量176

点赞数

分类专栏： mysql 文章标签： mysql 数据库 java

本文链接：https://blog.csdn.net/xxpxxpoo8/article/details/128325069

版权

mysql 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

官方文档

https://docs.percona.com/percona-toolkit/

操作

To remove this duplicate index, execute:
ALTER TABLE test.new_orders DROP INDEX idx6;
上面翻译：移除重复索引，执行[ALTER TABLE test.new_orders DROP INDEX idx6;]语句

[root@mxqmongodb2 bin]# ./pt-duplicate-key-checker --host=172.16.16.35 --port=3306 --user=root --password=123456 --database=test --tables=new_orders;
# ########################################################################
# test.new_orders
# ########################################################################
 
# idx6 is a duplicate of idx5
# Key definitions:
# KEY `idx6` (`no_o_id`,`no_d_id`,`no_w_id`)
# KEY `idx5` (`no_o_id`,`no_d_id`,`no_w_id`),
# Column types:
# `no_o_id` int(11) not null
# `no_d_id` tinyint(4) not null
# `no_w_id` smallint(6) not null
# To remove this duplicate index, execute:
ALTER TABLE `test`.`new_orders` DROP INDEX `idx6`;
 
# idx4 is a left-prefix of idx5
# Key definitions:
# KEY `idx4` (`no_o_id`,`no_d_id`),
# KEY `idx5` (`no_o_id`,`no_d_id`,`no_w_id`),
# Column types:
# `no_o_id` int(11) not null
# `no_d_id` tinyint(4) not null
# `no_w_id` smallint(6) not null
# To remove this duplicate index, execute:
ALTER TABLE `test`.`new_orders` DROP INDEX `idx4`;
 
# idx1 is a left-prefix of idx5
# Key definitions:
# KEY `idx1` (`no_o_id`),
# KEY `idx5` (`no_o_id`,`no_d_id`,`no_w_id`),
# Column types:
# `no_o_id` int(11) not null
# `no_d_id` tinyint(4) not null
# `no_w_id` smallint(6) not null
# To remove this duplicate index, execute:
ALTER TABLE `test`.`new_orders` DROP INDEX `idx1`;
 
# idx2 is a left-prefix of idx5
# Key definitions:
# KEY `idx2` (`no_o_id`),
# KEY `idx5` (`no_o_id`,`no_d_id`,`no_w_id`),
# Column types:
# `no_o_id` int(11) not null
# `no_d_id` tinyint(4) not null
# `no_w_id` smallint(6) not null
# To remove this duplicate index, execute:
ALTER TABLE `test`.`new_orders` DROP INDEX `idx2`;
 
# idx3 is a left-prefix of idx5
# Key definitions:
# KEY `idx3` (`no_o_id`),
# KEY `idx5` (`no_o_id`,`no_d_id`,`no_w_id`),
# Column types:
# `no_o_id` int(11) not null
# `no_d_id` tinyint(4) not null
# `no_w_id` smallint(6) not null
# To remove this duplicate index, execute:
ALTER TABLE `test`.`new_orders` DROP INDEX `idx3`;
 
# ########################################################################
# Summary of indexes
# ########################################################################
 
# Size Duplicate Indexes 196656
# Total Duplicate Indexes 5
# Total Indexes 7