解压pt软件
# tar xfz percona-toolkit-3.0.2_x86_64.tar.gz
安装对应的perl依赖包
# yum install perl-DBI
# yum install perl-DBD-MySQL
执行pt-duplicate-key-checker命令
# tar xfz percona-toolkit-3.0.2_x86_64.tar.gz
安装对应的perl依赖包
# yum install perl-DBI
# yum install perl-DBD-MySQL
执行pt-duplicate-key-checker命令
- # ./bin/pt-duplicate-key-checker -uroot -pcnstrong#123454321 -S /data/mysql01/mysql.sock
- # ########################################################################
- # beike.ls_lesson
- # ########################################################################
-
- # index_lesson_classSubjId is a left-prefix of index_lesson_classSubjId_startTime
- # Key definitions:
- # KEY `index_lesson_classSubjId` (`classSubjId`),
- # KEY `index_lesson_classSubjId_startTime` (`classSubjId`,`startTime`)
- # Column types:
- # `classsubjid` bigint(20) default null comment '????id'
- # `starttime` timestamp null default null comment '????'
- # To remove this duplicate index, execute:
- ALTER TABLE `beike`.`ls_lesson` DROP INDEX `index_lesson_classSubjId`;
-
- # ########################################################################
- # course.QRTZ_BLOB_TRIGGERS
- # ########################################################################
-
- # SCHED_NAME is a duplicate of PRIMARY
- # Key definitions:
- # KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
- # PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
- # Column types:
- # `sched_name` varchar(120) not null
- # `trigger_name` varchar(200) not null
- # `trigger_group` varchar(200) not null
- # To remove this duplicate index, execute:
- ALTER TABLE `course`.`QRTZ_BLOB_TRIGGERS` DROP INDEX `SCHED_NAME`;
-
- # ########################################################################
- # course.QRTZ_FIRED_TRIGGERS
- # ########################################################################
-
- # IDX_QRTZ_FT_TRIG_INST_NAME is a left-prefix of IDX_QRTZ_FT_INST_JOB_REQ_RCVRY
- # Key definitions:
- # KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
- # KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
- # Column types:
- # `sched_name` varchar(120) not null
- # `instance_name` varchar(200) not null
- # `requests_recovery` varchar(1) default null
- # To remove this duplicate index, execute:
- ALTER TABLE `course`.`QRTZ_FIRED_TRIGGERS` DROP INDEX `IDX_QRTZ_FT_TRIG_INST_NAME`;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26506993/viewspace-2150853/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26506993/viewspace-2150853/