安装sysbench报错：cannot find -lmysqlclient_r

参考《sysbench安装、使用、结果解读》，开始用命令

[root@localhost sysbench]#  ./configure --with-mysql-includes=/opt/sequoiasql/mysql/include  --with-mysql-libs=/opt/sequoiasql/mysql/lib  && make

编译安装sysbench时，报错:
/usr/bin/ld: cannot find -lmysqlclient_r collect2: error: ld returned 1 exit status make[2]: *** [sysbench] Error 1

查看是否安装了mysql_devel包：

[root@localhost sysbench]# rpm -qa | grep mysql
mysql-community-common-5.6.46-2.el6.x86_64
mysql-community-release-el6-5.noarch
mysql-community-libs-5.6.46-2.el6.x86_64
mysql-community-server-5.6.46-2.el6.x86_64
mysql-community-client-5.6.46-2.el6.x86_64

没有安装，那就安装就好：

[root@localhost sysbench]# yum install mysql-devel
[root@localhost sysbench]# rpm -qa | grep mysql
mysql-community-common-5.6.46-2.el6.x86_64
mysql-community-release-el6-5.noarch
mysql-community-libs-5.6.46-2.el6.x86_64
mysql-community-server-5.6.46-2.el6.x86_64
mysql-community-client-5.6.46-2.el6.x86_64
mysql-community-devel-5.6.47-2.el6.x86_64

首选安装mysql_devel包成功，继续测试还是一样报错；
应该将安装的做软链接到你在命令中声明的lib中；

[root@localhost sysbench-0.4.12-1.1]#  cd /opt/sequoiasql/mysql
[root@localhost mysql]# mv lib lib.bak              
[root@localhost mysql]# cd /usr/lib64/mysql/
[root@localhost mysql]# ln -s /usr/lib64/mysql /opt/sequoiasql/mysql/lib 

再次编译，正常，在 sysbench 目录下生成二进制命令行工具 sysbench。