在线修改大表结构之pt-online-schema-change (alter-foreign-keys-method)

安装

sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
sudo yum install percona-toolkit

查看触发器：

方式一：

use information_schema;
select * from TRIGGERS;

方式二：

use database_name;
show triggers;

删除触发器：