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

  • Post author:
  • Post category: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 版权协议,转载请附上原文出处链接和本声明。