Shulou(Shulou.com)05/31 Report--

This article mainly introduces "the reason why mysql executes pt-query-digest error". In daily operation, I believe many people have doubts about the reason why mysql executes pt-query-digest error. Xiaobian consulted all kinds of information and sorted out simple and easy operation methods. I hope to help you answer the doubts about "the reason why mysql executes pt-query-digest error"! Next, please follow the small series to learn together!

article directories

operating environment

problem

analyze problems

operating environment

operating system version

[root@three57 mysql57_dir]# more /etc/redhat-release Red Hat Enterprise Linux Server release 6.8 (Santiago)

pt-query-digest version

[root@three57 mysql57_dir]# pt-query-digest --versionpt-query-digest 3.1.0 Questions

Execute pt-query-digest error

[root@three57 percona-toolkit-3.1.0]# pt-query-digest --interval=2 --processlist -uroot -psystemReading from STDIN ... install_driver(mysql) failed: Attempt to reload DBD/mysql.pm aborted.Compilation failed in require at (eval 23) line 3. Analysis problem

After checking baidu and perl mysql.so library file correlation

[root@three57 percona-toolkit-3.1.0]# locate mysql.so/usr/lib64/perl5/auto/DBD/mysql/mysql.so

Analyze whether the dependency library of the mysql.so library file of perl is complete, and see the missing libmysqlclient.so.16

[root@three57 percona-toolkit-3.1.0]# ldd /usr/lib64/perl5/auto/DBD/mysql/mysql.so linux-vdso.so.1 => (0x00007ffcf6dd4000) libmysqlclient.so.16 => not found No mysql dynamic link library found. libz.so.1 => /lib64/libz.so.1 (0x00007f9b0e1cb000) libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f9b0df94000) libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f9b0dd7b000) libm.so.6 => /lib64/libm.so.6 (0x00007f9b0daf6000) libssl.so.10 => /usr/lib64/libssl.so.10 (0x00007f9b0d88a000) libcrypto.so.10 => /usr/lib64/libcrypto.so.10 (0x00007f9b0d4a6000) libc.so.6 => /lib64/libc.so.6 (0x00007f9b0d111000) libfreebl3.so => /lib64/libfreebl3.so (0x00007f9b0cf0e000) libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f9b0ccca000) libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f9b0c9e2000) libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f9b0c7de000) libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f9b0c5b2000) libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f9b0c397000) libdl.so.2 => /lib64/libdl.so.2 (0x00007f9b0c193000) /lib64/ld-linux-x86-64.so.2 (0x000000381da00000) libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f9b0bf88000) libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f9b0bd84000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f9b0bb67000) libselinux.so.1 => /lib64/libselinux.so.1 (0x00007f9b0b947000)

libmysqlclient.so This library file is derived from mysql installation media

Query installed mysql packages

[root@three57 mysql57_dir]# rpm -qa|grep -i --color mysqlmysql-community-common-5.7.21-1.el6.x86_64mysql-community-server-5.7.21-1.el6.x86_64perl-DBD-MySQL-4.013-3.el6.x86_64mysql-community-libs-5.7.21-1.el6.x86_64mysql-community-client-5.7.21-1.el6.x86_64

Query installed libmysqlclient library files

[root@three57 mysql57_dir]# locate /usr/lib64/mysql/libmysqlclient.so.20/usr/lib64/mysql/libmysqlclient.so.20/usr/lib64/mysql/libmysqlclient.so.20.3.8

To sum up, you should install mysql package mysql-community-libs-compat

(Note: This is a shared library file that provides older versions of mysql)

[root@three57 mysql57_dir]# rpm -ivh mysql-community-libs-compat-5.7.21-1.el6.x86_64.rpmwarning: mysql-community-libs-compat-5.7.21-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEYPreparing... ########################################### [100%] 1:mysql-community-libs-co########################################### [100%][root@three57 mysql57_dir]# locate libmysqlclient.so.16/usr/lib64/mysql/libmysqlclient.so.16/usr/lib64/mysql/libmysqlclient.so.16.0.0

The requested URL/usr/lib64/perl5/auto/DBD/mysql/mysql.so was not found on this server.

[root@three57 mysql57_dir]# ldd /usr/lib64/perl5/auto/DBD/mysql/mysql.so linux-vdso.so.1 => (0x00007ffd3fee9000) libmysqlclient.so.16 => /usr/lib64/mysql/libmysqlclient.so.16 (0x00007f346d4e3000) libz.so.1 => /lib64/libz.so.1 (0x00007f346d2cd000) libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007f346d095000) libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f346ce7c000) libm.so.6 => /lib64/libm.so.6 (0x00007f346cbf8000) libssl.so.10 => /usr/lib64/libssl.so.10 (0x00007f346c98b000) libcrypto.so.10 => /usr/lib64/libcrypto.so.10 (0x00007f346c5a7000) libc.so.6 => /lib64/libc.so.6 (0x00007f346c213000) libfreebl3.so => /lib64/libfreebl3.so (0x00007f346c00f000) libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007f346bdcb000) libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007f346bae4000) libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007f346b8df000) libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007f346b6b3000) libresolv.so.2 => /lib64/libresolv.so.2 (0x00007f346b499000) libdl.so.2 => /lib64/libdl.so.2 (0x00007f346b294000) /lib64/ld-linux-x86-64.so.2 (0x000000381da00000) libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007f346b089000) libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007f346ae86000) libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f346ac68000) libselinux.so.1 => /lib64/libselinux.so.1 (0x00007 f346aa49000) At this point, the study of "the reason why mysql executes pt-query-digest error" is over, hoping to solve everyone's doubts. Theory and practice can better match to help everyone learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.