Mysql 优化存储1

franket

发布于 2022-03-21 18:27:49

5330

发布于 2022-03-21 18:27:49

文章被收录于专栏：技术杂记技术杂记

此工具要求用户 ptcheck 对所检查的库或表有读权限和对 ptcheck.checksum 有写权限，有在 ptcheck 库中创建表的权限

根据提示输入密码就会开始进行检查

Note: 此时指定的host要是master
Note: pt-table-checksum 需要 Term::ReadKey 的支持，如果缺少，会报下面的错误

12-15T14:22:37 Cannot read response; is Term::ReadKey installed? Can't locate Term/ReadKey.pm in @INC (@INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at /usr/bin/pt-table-checksum line 2612.

解决方法是安装这个包

[root@opti-master checkdb]# yum install perl-TermReadKey.x86_64  
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * epel: mirrors.ustc.edu.cn
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package perl-TermReadKey.x86_64 0:2.30-4.el5 set to be updated
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================================
 Package                            Arch                     Version                        Repository              Size
=========================================================================================================================
Installing:
 perl-TermReadKey                   x86_64                   2.30-4.el5                     epel                    32 k

Transaction Summary
=========================================================================================================================
Install       1 Package(s)
Upgrade       0 Package(s)

Total download size: 32 k
Is this ok [y/N]: y
Downloading Packages:
perl-TermReadKey-2.30-4.el5.x86_64.rpm                                                            |  32 kB     00:00     
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing     : perl-TermReadKey                                                                                  1/1 

Installed:
  perl-TermReadKey.x86_64 0:2.30-4.el5                                                                                   

Complete!
[root@opti-master checkdb]#

本文系转载，前往查看

如有侵权，请联系 cloudcommunity@tencent.com 删除。

checksum