IBM Power PC安装sysbench 执行mysql基准测试

第一步:下载Sysbench

http://dev.mysql.com/downloads/benchmarks.html


第二步:解压sysbench

第三步:执行安装步骤
1. ./autogen.sh
2. ./configure --with-mysql --with-mysql-includes=/usr/include/mysql --with-mysql-libs=/var/lib/mysql
此步最后报错如下:
configure: error: cannot guess build type; you must specify one

查看了sysbench 的README 和INSTALL, 在INSTALL中有如下提示:
Specifying the System Type
==========================

There may be some features `configure' cannot figure out
automatically, but needs to determine by the type of machine the package
will run on. Usually, assuming the package is built to be run on the
_same_ architectures, `configure' can figure that out, but if it prints
a message saying it cannot guess the machine type, give it the
`--build=TYPE' option. TYPE can either be a short name for the system
type, such as `sun4', or a canonical name which has the form:

CPU-COMPANY-SYSTEM

where SYSTEM can have one of these forms:

OS KERNEL-OS

See the file `config.sub' for the possible values of each field. If
`config.sub' isn't included in this package, then this package doesn't
need to know the machine type.

3. ./configure --build=ppc64le --with-mysql --with-mysql-includes=/usr/include/mysql --with-mysql-libs=/var/lib/mysql
能够成功执行

4. 继续执行make
出现如下错误:
/usr/bin/ld: cannot find -lmysqlclient_r

collect2: error: ld returned 1 exit status

尝试了很多方法,百度了很多文章,终于没有搞定,决定放弃!

解决方案 -- GOOGLE 放弃源码安装,寻找ppc64leCPU结构的RPM包

 https://www.rpmfind.net/linux/RPM/epel/7/ppc64le/s/sysbench-0.4.12-12.el7.ppc64le.html

[root@jtcrtvspa02 appuser]# yum install sysbench-0.4.12-12.el7.ppc64le.rpm 
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Examining sysbench-0.4.12-12.el7.ppc64le.rpm: sysbench-0.4.12-12.el7.ppc64le
Marking sysbench-0.4.12-12.el7.ppc64le.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package sysbench.ppc64le 0:0.4.12-12.el7 will be installed
--> Processing Dependency: libpq.so.5()(64bit) for package: sysbench-0.4.12-12.el7.ppc64le
--> Running transaction check
---> Package postgresql-libs.ppc64le 0:9.2.13-1.el7_1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

===============================================================================================================================================================================================
 Package                                     Arch                                Version                                     Repository                                                   Size
===============================================================================================================================================================================================
Installing:
 sysbench                                    ppc64le                             0.4.12-12.el7                               /sysbench-0.4.12-12.el7.ppc64le                             248 k
Installing for dependencies:
 postgresql-libs                             ppc64le                             9.2.13-1.el7_1                              rhel7.2                                                     242 k

Transaction Summary
===============================================================================================================================================================================================
Install  1 Package (+1 Dependent package)

Total size: 489 k
Total download size: 242 k
Installed size: 1.1 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
  Installing : postgresql-libs-9.2.13-1.el7_1.ppc64le                                                                                                                                      1/2 
  Installing : sysbench-0.4.12-12.el7.ppc64le                                                                                                                                              2/2 
  Verifying  : sysbench-0.4.12-12.el7.ppc64le                                                                                                                                              1/2 
  Verifying  : postgresql-libs-9.2.13-1.el7_1.ppc64le                                                                                                                                      2/2 

Installed:
  sysbench.ppc64le 0:0.4.12-12.el7                                                                                                                                                             

Dependency Installed:
  postgresql-libs.ppc64le 0:9.2.13-1.el7_1                                                                                                                                                     

Complete!

版权声明:本文为xxpr_ybgg原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。