sysbench-0.4.12 compile installation and CPU test example sharing _mysql

Source: Internet
Author: User
Tags benchmark

First, get the installation package

The most recent version is 0.4.12, download Address:

Ii. Compiling and installing

My environment for RHEL6.2 + MySQL 5.6.16, build reference on the two articles <<rhel6.2 compile install MySQL 5.6.16>><<mysql Benchmark install DBI component >>, The installation steps are as follows:

Copy Code code as follows:

[ROOT@BEANVM ~]# TAR-XVF sysbench-0.4.12.tar.gz
[ROOT@BEANVM ~]# CD sysbench-0.4.12
[ROOT@BEANVM sysbench-0.4.12]#./configure--with-mysql-includes=/usr/local/mysql/include--with-mysql-libs=/usr/ Local/mysql/lib && make && make install

Because my MySQL is compiled and installed, the above need to give the MySQL library file location (corresponding to the-with-mysql-includes and –with-mysql-libs options).

Common errors during installation are as follows:

Copy Code code as follows:

.. /libtool:line 841:x--tag=cc:command not found
.. /libtool:line 874:libtool:ignoring unknown Tag:command not found
.. /libtool:line 841:x--mode=link:command not found
.. /libtool:line 1007: * * * warning:inferring the mode of operation is deprecated.: Command not Found
.. /libtool:line 1008: * * * Future versions of Libtool'll require--mode=mode is specified.: Command not Found
.. /libtool:line 2234:x-g:command not found
.. /libtool:line 2234:x-o2:command not found
.. /libtool:line 1954:x-l/usr/local/mysql/lib:no such file or directory
.. /libtool:line 2403:xsysbench:command not found

In previous versions, we only needed to execute the script in the Sysbench extract directory before compiling the operation, but now we're going to make the same mistake because Sysbench has a problem with libtool, and we can compare it to/usr/ The difference between the Bin/libtool file is that it can be resolved by replacing the Libtool file, or by modifying the following contents of the Aclocal.m4 file

Copy Code code as follows:

# Always Use our own libtool.
Libtool= ' $ (SHELL) $ (top_builddir)/libtool '
Ac_subst (LIBTOOL) DNL

Modify the value of the Libtool variable to: ' $ (SHELL)/usr/bin/libtool ', even with the system's Libtool toolkit.

The modifications are performed before the make && make install can be successfully installed.

Install complete immediately test:

Copy Code code as follows:

[ROOT@BEANVM sysbench-0.4.12]# Sysbench
Sysbench:error while loading shared open Shared object file:no such file or dire Ctory

Said is missing file, the amount, this file is present, need to manually link:

Copy Code code as follows:

[ROOT@BEANVM ~]# ls-l/usr/local/mysql/lib/*
lrwxrwxrwx. 1 MySQL Feb 14:39/usr/local/mysql/lib/>
-rwxr-xr-x. 1 mysql mysql 7654927 Feb 14:30/usr/local/mysql/lib/
[ROOT@BEANVM ~]# ls-l/usr/lib/*
Ls:cannot access/usr/lib/*: No such file or directory
[ROOT@BEANVM ~]# Ln ln-s/usr/local/mysql/lib/

Deployment complete, run a CPU benchmark test:

Copy Code code as follows:

[ROOT@BEANVM ~]# sysbench--test=cpu--cpu-max-prime=20000 Run
Sysbench 0.4.12:multi-threaded System Evaluation Benchmark

Running the test with following options:
Number of Threads:1

Doing CPU Performance Benchmark

Threads started!

Maximum prime number checked in CPU test:20000

Test Execution Summary:
Total time:40.4541s
Total number of events:10000
Total time taken by event execution:40.4165
Per-request Statistics:
Approx. Percentile:5.20ms

Threads Fairness:
Events (Avg/stddev): 10000.0000/0.00
Execution Time (Avg/stddev): 40.4165/0.00

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.