添加索引
ALTER TABLE `FUND_PAY_TRADE_RECORD`
ADD INDEX `IDX_PAY_THIRD_ID` (`THIRD_ID`) USING BTREE ;
统计表大小5.6G
备份表:
mysqldump -uroot -p--master-data=2 --single-transaction -t xiaodai FUND_PAY_TRADE_RECORD > TRADE_RECORD0621.sql
用pt工具变更:
pt-online-schema-change --user=root --password= --alter="ADD INDEX IDX_PAY_THIRD_ID (THIRD_ID) USING BTREE" D=xiaodai,t=FUND_PAY_TRADE_RECORD--no-check-replication-filters --execute
报错