percona-toolkit的工具使用笔记
5墨值下载
安装 percona-toolkit：
先依赖安装：
yum -y install perl-Digest-MD5
yum install perl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker cpan
yum install perl-DBI
yum install perl-DBD-MySQL
yum install perl-Time-HiRes
yum install perl-IO-Socket-SSL
##Install percona-toolkit
wget percona.com/get/percona-toolkit.tar.gz
tar -zxvf percona-toolkit.tar.gz
cd percona-toolkit-3.2.1
perl Makefile.PL
make
make install
一、在线 ddl 大表工具 pt-online-schema-change 的使用
/opt/percona-toolkit-3.2.1/bin/pt-online-schema-change -uroot -pAisino123+
--alter='MODIFY COLUMN invoice_date date ' --execute
D=etcloud,t=ivat_original_invoice
测试过程如下：
[root@localhost bin]# ./pt-online-schema-change -uroot -pAisino123+
--alter='MODIFY COLUMN kprq date ' --execute D=dzfp_zzs_kpfw_arm,t=invoice_info
No slaves found. See --recursion-method if host localhost.localdomain has
slaves.
Not checking slave lag because no slaves were found and --check-slave-lag was
not specified.
*******************************************************************
Using the default of SSL_verify_mode of SSL_VERIFY_NONE for client
is deprecated! Please set SSL_verify_mode to SSL_VERIFY_PEER
possibly with SSL_ca_file|SSL_ca_path for verification.
If you really don't want to verify the certificate and keep the
connection open to Man-In-The-Middle attacks please set
SSL_verify_mode explicitly to SSL_VERIFY_NONE in your application.
*******************************************************************
at ./pt-online-schema-change line 7118.
*******************************************************************
Using the default of SSL_verify_mode of SSL_VERIFY_NONE for client
is deprecated! Please set SSL_verify_mode to SSL_VERIFY_PEER
possibly with SSL_ca_file|SSL_ca_path for verification.
If you really don't want to verify the certificate and keep the
connection open to Man-In-The-Middle attacks please set
SSL_verify_mode explicitly to SSL_VERIFY_NONE in your application.
*******************************************************************
at ./pt-online-schema-change line 7118.
# A software update is available:
Operation, tries, wait:
analyze_table, 10, 1
copy_rows, 10, 0.25
create_triggers, 10, 1
drop_triggers, 10, 1
swap_tables, 10, 1
update_foreign_keys, 10, 1
Altering `dzfp_zzs_kpfw_arm`.`invoice_info`...
Creating new table...
Created new table dzfp_zzs_kpfw_arm._invoice_info_new OK.
Altering new table...
Altered `dzfp_zzs_kpfw_arm`.`_invoice_info_new` OK.
2020-11-24T09:48:22 Creating triggers...
2020-11-24T09:48:22 Created triggers OK.
2020-11-24T09:48:22 Copying approximately 28603099 rows...
Copying rows caused a MySQL error 1265: Data truncated for column 'kprq' at row
1
No more warnings about this MySQL error will be reported. If --statistics was
specified, mysql_warning_1265 will list the total count of this MySQL error.
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 1% 44:40 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 2% 44:13 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 3% 43:30 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 4% 43:09 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 5% 42:53 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 6% 42:17 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 7% 42:03 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 8% 41:30 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 9% 41:08 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 10% 40:41 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 12% 40:18 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 13% 39:50 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 14% 39:25 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 15% 38:57 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 16% 38:31 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 17% 38:01 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 18% 37:39 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 19% 37:14 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 20% 36:49 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 21% 36:22 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 22% 35:57 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 23% 35:30 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 24% 35:00 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 25% 34:32 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 26% 34:04 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 27% 33:41 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 28% 33:14 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 29% 32:45 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 30% 32:17 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 32% 31:48 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 33% 31:18 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 34% 30:48 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 35% 30:20 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 36% 29:52 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 37% 29:25 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 38% 28:57 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 39% 28:28 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 40% 27:59 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 41% 27:28 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 42% 26:58 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 43% 26:26 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 44% 25:57 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 45% 25:26 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 46% 24:56 remain
Copying `dzfp_zzs_kpfw_arm`.`invoice_info`: 47% 24:25 remain
of 6
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
文档被以下合辑收录
评论