• 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!
  • 相关阅读:
    网络安全(黑客)自学
    大都会人寿线下培训第三天回顾(爱的书信)及线上课程笔记
    Python 三维姿态估计+Unity3d 实现 3D 虚拟现实交互游戏
    LeetCode 2578. 最小和分割:贪心(数学)
    从零到一掌握 Docker 的基本原理与实践操作
    恶补《操作系统》3_2——王道学习笔记
    CSS基础
    FineReport----报表模板入门
    深度解析Linux内核—中断
    vue3.0 ref的使用
  • 原文地址:https://blog.csdn.net/xxpr_ybgg/article/details/126831910