SysBench on CentOS – HowTo

If you want to test server performance, you can think about SysBench. SysBench is a modular, cross-platform and multi-threaded benchmark tool for evaluating OS parameters that are important for a system running a database under intensive load. The idea of this benchmark suite is to quickly get an impression about system performance without setting up complex database benchmarks or even without installing a database at all.

Current features allow to test the following system parameters:

* file I/O performance
* scheduler performance
* memory allocation and transfer speed
* POSIX threads implementation performance
* database server performance (OLTP benchmark)
(Primarily written for MySQL server benchmarking, SysBench will be further extended to support multiple database backends, distributed benchmarks and third-party plug-in modules)

I couldn’t find CentOS RPM so here are few tips how to install it manually.

Download Sysbench (current version is 0.4.12)

# wget http://garr.dl.sourceforge.net/sourceforge/sysbench/sysbench-0.4.12.tar.gz

Then unpack it and install with

# tar -xvzf sysbench-0.4.12.tar.gz
# cd sysbench-0.4.12
# libtoolize --force --copy 
# ./autogen.sh
# ./configure
# make
# make install

To test CPU performance you can try

# sysbench --test=cpu --cpu-max-prime=20000 run

For MySQL test, you’ll need to prepare database for testing with

# sysbench --test=oltp --mysql-table-engine=innodb --oltp-table-size=500000 --mysql-user=test_database --mysql-password=test_database_password --mysql-socket=/var/lib/mysql/mysql.sock prepare

(replace test_database with valid username and test_database_password with valid password)

This command will create sample table inside test_database and it will have 500 000 rows (InnoDB engine).

sysbench 0.4.12:  multi-threaded system evaluation benchmark
 
No DB drivers specified, using mysql
Creating table 'test-database'...
Creating 500000 records in table 'test-database'...

Now to start read test

# sysbench --num-threads=16 --max-requests=100000 --test=oltp --oltp-table-size=500000 --mysql-socket=/var/lib/mysql/mysql.sock --oltp-read-only --mysql-user=test_database --mysql-password=test_database_password run

For read-write test you can try

# sysbench --num-threads=16 --max-requests=10000 --test=oltp --oltp-table-size=500000 --mysql-socket=/var/lib/mysql/mysql.sock --oltp-test-mode=complex --mysql-user=test_database --mysql-password=test_database_password run

More info about specific parameters can be found in official docs (http://sysbench.sourceforge.net/docs/)

20 thoughts on “SysBench on CentOS – HowTo”

  1. I did a yum install mysql.
    at the make step, I”m getting
    make[3]: Entering directory `/root/sysbench-0.4.12/sysbench/drivers/mysql’
    if gcc -DHAVE_CONFIG_H -I. -I. -I../../../config -I/usr/include/mysql -g -pipe -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector –param=ssp-buffer-size=4 -m64 -D_GNU_SOURCE -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE -fno-strict-aliasing -fwrapv -D_REENTRANT -D_XOPEN_SOURCE=500 -D_GNU_SOURCE -I../../../sysbench -pthread -g -O2 -MT libsbmysql_a-drv_mysql.o -MD -MP -MF “.deps/libsbmysql_a-drv_mysql.Tpo” -c -o libsbmysql_a-drv_mysql.o `test -f ‘drv_mysql.c’ || echo ‘./’`drv_mysql.c; \
    then mv -f “.deps/libsbmysql_a-drv_mysql.Tpo” “.deps/libsbmysql_a-drv_mysql.Po”; else rm -f “.deps/libsbmysql_a-drv_mysql.Tpo”; exit 1; fi
    drv_mysql.c:35:19: error: mysql.h: No such file or directory

    what’s wrong?

    Thanks,
    Dave

  2. I get following error, what can I do?
    Thank you!

    gcc -pthread -g -O2 -o sysbench sysbench.o sb_timer.o sb_options.o sb_logger.o db_driver.o tests/fileio/libsbfileio.a tests/threads/libsbthreads.a tests/memory/libsbmemory.a tests/cpu/libsbcpu.a tests/oltp/libsboltp.a tests/mutex/libsbmutex.a drivers/mysql/libsbmysql.a -L/usr/lib/mysql/ -lmysqlclient_r -lrt -lm
    /usr/lib/mysql//libmysqlclient_r.a(client.o): In function `mysql_close_free_options’:
    (.text+0xd8d): undefined reference to `SSL_CTX_free’
    /usr/lib/mysql//libmysqlclient_r.a(client.o): In function `mysql_get_ssl_cipher’:
    (.text+0x1091): undefined reference to `SSL_get_current_cipher’
    /usr/lib/mysql//libmysqlclient_r.a(client.o): In function `mysql_real_connect’:
    (.text+0x38f5): undefined reference to `SSL_get_peer_certificate’
    /usr/lib/mysql//libmysqlclient_r.a(client.o): In function `mysql_real_connect’:
    (.text+0x3909): undefined reference to `X509_get_subject_name’
    /usr/lib/mysql//libmysqlclient_r.a(client.o): In function `mysql_real_connect’:
    (.text+0x391d): undefined reference to `X509_NAME_oneline’
    /usr/lib/mysql//libmysqlclient_r.a(client.o): In function `mysql_real_connect’:
    (.text+0x3925): undefined reference to `X509_free’
    /usr/lib/mysql//libmysqlclient_r.a(client.o): In function `mysql_get_ssl_cipher’:
    (.text+0x109a): undefined reference to `SSL_CIPHER_get_name’
    /usr/lib/mysql//libmysqlclient_r.a(viossl.o): In function `report_errors’:
    (.text+0x45): undefined reference to `ERR_get_error_line_data’
    /usr/lib/mysql//libmysqlclient_r.a(viossl.o): In function `ssl_do’:
    (.text+0x8c): undefined reference to `SSL_new’
    /usr/lib/mysql//libmysqlclient_r.a(viossl.o): In function `ssl_do’:
    (.text+0x9a): undefined reference to `SSL_clear’
    /usr/lib/mysql//libmysqlclient_r.a(viossl.o): In function `ssl_do’:
    (.text+0xa2): undefined reference to `SSL_get_session’
    /usr/lib/mysql//libmysqlclient_r.a(viossl.o): In function `ssl_do’:
    (.text+0xae): undefined reference to `SSL_SESSION_set_timeout’
    /usr/lib/mysql//libmysqlclient_r.a(viossl.o): In function `ssl_do’:
    (.text+0xbc): undefined reference to `SSL_set_fd’
    /usr/lib/mysql//libmysqlclient_r.a(viossl.o): In function `ssl_do’:
    (.text+0xd1): undefined reference to `SSL_get_fd’
    /usr/lib/mysql//libmysqlclient_r.a(viossl.o): In function `ssl_do’:
    (.text+0x14b): undefined reference to `SSL_free’
    /usr/lib/mysql//libmysqlclient_r.a(viossl.o): In function `sslconnect’:
    (.text+0x16f): undefined reference to `SSL_connect’
    /usr/lib/mysql//libmysqlclient_r.a(viossl.o): In function `sslaccept’:
    (.text+0x18f): undefined reference to `SSL_accept’
    /usr/lib/mysql//libmysqlclient_r.a(viossl.o): In function `vio_ssl_close’:
    (.text+0x1c5): undefined reference to `SSL_set_quiet_shutdown’
    /usr/lib/mysql//libmysqlclient_r.a(viossl.o): In function `vio_ssl_close’:
    (.text+0x1cd): undefined reference to `SSL_shutdown’
    /usr/lib/mysql//libmysqlclient_r.a(viossl.o): In function `vio_ssl_delete’:
    (.text+0x212): undefined reference to `SSL_free’
    /usr/lib/mysql//libmysqlclient_r.a(viossl.o): In function `vio_ssl_write’:
    (.text+0x261): undefined reference to `SSL_write’
    /usr/lib/mysql//libmysqlclient_r.a(viossl.o): In function `vio_ssl_read’:
    (.text+0x281): undefined reference to `SSL_read’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `report_errors’:
    (.text+0x25): undefined reference to `ERR_get_error_line_data’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0x99): undefined reference to `SSL_CTX_new’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0xbc): undefined reference to `SSL_CTX_set_cipher_list’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0xd9): undefined reference to `SSL_CTX_load_verify_locations’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0xfb): undefined reference to `SSL_CTX_use_certificate_file’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0x125): undefined reference to `SSL_CTX_use_PrivateKey_file’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0x135): undefined reference to `SSL_CTX_check_private_key’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0x142): undefined reference to `DH_new’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0x166): undefined reference to `BN_bin2bn’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0x185): undefined reference to `BN_bin2bn’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0x1bb): undefined reference to `SSL_CTX_ctrl’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0x1c3): undefined reference to `DH_free’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0x1da): undefined reference to `SSL_load_error_strings’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0x1eb): undefined reference to `SSL_library_init’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0x1f0): undefined reference to `OPENSSL_add_all_algorithms_noconf’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0x206): undefined reference to `SSL_CTX_set_default_verify_paths’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0x21d): undefined reference to `SSL_CTX_free’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0x2bd): undefined reference to `DH_free’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLFd’:
    (.text+0x2d6): undefined reference to `SSL_CTX_free’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLAcceptorFd’:
    (.text+0x328): undefined reference to `TLSv1_server_method’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLAcceptorFd’:
    (.text+0x36f): undefined reference to `SSL_CTX_ctrl’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLAcceptorFd’:
    (.text+0x389): undefined reference to `SSL_CTX_set_verify’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLAcceptorFd’:
    (.text+0x39f): undefined reference to `SSL_CTX_set_session_id_context’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLConnectorFd’:
    (.text+0x3c6): undefined reference to `TLSv1_client_method’
    /usr/lib/mysql//libmysqlclient_r.a(viosslfactories.o): In function `new_VioSSLConnectorFd’:
    (.text+0x405): undefined reference to `SSL_CTX_set_verify’
    /usr/lib/mysql//libmysqlclient_r.a(my_compress.o): In function `my_uncompress’:
    (.text+0x60): undefined reference to `uncompress’
    /usr/lib/mysql//libmysqlclient_r.a(my_compress.o): In function `my_compress_alloc’:
    (.text+0x102): undefined reference to `compress’
    collect2: ld returned 1 exit status
    make[2]: *** [sysbench] Error 1
    make[2]: Leaving directory `/home/mac/sysbench-0.4.12/sysbench’
    make[1]: *** [all-recursive] Error 1
    make[1]: Leaving directory `/home/mac/sysbench-0.4.12/sysbench’
    make: *** [all-recursive] Error 1

  3. hi,i have a question
    could you help me.

    Making all in doc
    make[1]: Entering directory `/opt/sysbench-0.4.12/doc’
    Making all in xsl
    make[2]: Entering directory `/opt/sysbench-0.4.12/doc/xsl’
    make[2]: Nothing to be done for `all’.
    make[2]: Leaving directory `/opt/sysbench-0.4.12/doc/xsl’
    make[2]: Entering directory `/opt/sysbench-0.4.12/doc’
    make[2]: Nothing to be done for `all-am’.
    make[2]: Leaving directory `/opt/sysbench-0.4.12/doc’
    make[1]: Leaving directory `/opt/sysbench-0.4.12/doc’
    Making all in sysbench
    make[1]: Entering directory `/opt/sysbench-0.4.12/sysbench’
    Making all in drivers
    make[2]: Entering directory `/opt/sysbench-0.4.12/sysbench/drivers’
    Making all in mysql
    make[3]: Entering directory `/opt/sysbench-0.4.12/sysbench/drivers/mysql’
    gcc -DHAVE_CONFIG_H -I. -I../../../config -I/usr/local/mysql/include/ -D_REENTRANT -D_XOPEN_SOURCE=500 -D_GNU_SOURCE -I../../../sysbench -pthread -g -O2 -MT libsbmysql_a-drv_mysql.o -MD -MP -MF .deps/libsbmysql_a-drv_mysql.Tpo -c -o libsbmysql_a-drv_mysql.o `test -f ‘drv_mysql.c’ || echo ‘./’`drv_mysql.c
    drv_mysql.c:35:19: error: mysql.h: No such file or directory
    drv_mysql.c:36:26: error: mysqld_error.h: No such file or directory
    drv_mysql.c: In function ‘mysql_drv_describe’:
    drv_mysql.c:284: error: ‘MYSQL_RES’ undeclared (first use in this function)
    drv_mysql.c:284: error: (Each undeclared identifier is reported only once
    drv_mysql.c:284: error: for each function it appears in.)
    drv_mysql.c:284: error: ‘res’ undeclared (first use in this function)
    drv_mysql.c:285: error: ‘MYSQL_ROW’ undeclared (first use in this function)
    drv_mysql.c:285: error: expected ‘;’ before ‘row’
    drv_mysql.c:286: error: ‘MYSQL_FIELD’ undeclared (first use in this function)
    drv_mysql.c:286: error: ‘fields’ undeclared (first use in this function)
    drv_mysql.c:328: error: ‘row’ undeclared (first use in this function)
    drv_mysql.c: In function ‘mysql_drv_connect’:
    drv_mysql.c:360: error: ‘MYSQL’ undeclared (first use in this function)
    drv_mysql.c:360: error: ‘con’ undeclared (first use in this function)
    drv_mysql.c:366: error: expected expression before ‘)’ token
    drv_mysql.c:401: error: ‘MYSQL_VERSION_ID’ undeclared (first use in this function)
    drv_mysql.c: In function ‘mysql_drv_disconnect’:
    drv_mysql.c:441: error: ‘MYSQL’ undeclared (first use in this function)
    drv_mysql.c:441: error: ‘con’ undeclared (first use in this function)
    drv_mysql.c: In function ‘mysql_drv_bind_param’:
    drv_mysql.c:520: error: ‘MYSQL’ undeclared (first use in this function)
    drv_mysql.c:520: error: ‘con’ undeclared (first use in this function)
    drv_mysql.c:520: error: expected expression before ‘)’ token
    drv_mysql.c: In function ‘mysql_drv_query’:
    drv_mysql.c:729: error: ‘MYSQL’ undeclared (first use in this function)
    drv_mysql.c:729: error: ‘con’ undeclared (first use in this function)
    drv_mysql.c:739: error: ‘ER_LOCK_DEADLOCK’ undeclared (first use in this function)
    drv_mysql.c:739: error: ‘ER_LOCK_WAIT_TIMEOUT’ undeclared (first use in this function)
    drv_mysql.c:739: error: ‘ER_CHECKREAD’ undeclared (first use in this function)
    drv_mysql.c: In function ‘mysql_drv_store_results’:
    drv_mysql.c:789: error: ‘MYSQL’ undeclared (first use in this function)
    drv_mysql.c:789: error: ‘con’ undeclared (first use in this function)
    drv_mysql.c:790: error: ‘MYSQL_RES’ undeclared (first use in this function)
    drv_mysql.c:790: error: ‘res’ undeclared (first use in this function)
    drv_mysql.c:791: error: ‘MYSQL_ROW’ undeclared (first use in this function)
    drv_mysql.c:791: error: expected ‘;’ before ‘row’
    drv_mysql.c:839: error: ‘ER_LOCK_DEADLOCK’ undeclared (first use in this function)
    drv_mysql.c:839: error: ‘ER_LOCK_WAIT_TIMEOUT’ undeclared (first use in this function)
    drv_mysql.c:855: error: ‘row’ undeclared (first use in this function)
    drv_mysql.c: In function ‘mysql_drv_free_results’:
    drv_mysql.c:879: error: ‘MYSQL_RES’ undeclared (first use in this function)
    drv_mysql.c:879: error: expected expression before ‘)’ token
    make[3]: *** [libsbmysql_a-drv_mysql.o] Error 1
    make[3]: Leaving directory `/opt/sysbench-0.4.12/sysbench/drivers/mysql’
    make[2]: *** [all-recursive] Error 1
    make[2]: Leaving directory `/opt/sysbench-0.4.12/sysbench/drivers’
    make[1]: *** [all-recursive] Error 1
    make[1]: Leaving directory `/opt/sysbench-0.4.12/sysbench’
    make: *** [all-recursive] Error 1

  4. As you can see:
    drv_mysql.c:35:19: error: mysql.h: No such file or directory

    So, something is wrong with your mysql installation.
    Try
    “yum install mysql-devel” or appropriate command depending from your distro.

  5. I am getting this error when trying to install sysbench

    Making all in doc
    make[1]: Entering directory `/root/sysbench-0.4.12/doc’
    Making all in xsl
    make[2]: Entering directory `/root/sysbench-0.4.12/doc/xsl’
    make[2]: Nothing to be done for `all’.
    make[2]: Leaving directory `/root/sysbench-0.4.12/doc/xsl’
    make[2]: Entering directory `/root/sysbench-0.4.12/doc’
    make[2]: Nothing to be done for `all-am’.
    make[2]: Leaving directory `/root/sysbench-0.4.12/doc’
    make[1]: Leaving directory `/root/sysbench-0.4.12/doc’
    Making all in sysbench
    make[1]: Entering directory `/root/sysbench-0.4.12/sysbench’
    Making all in drivers
    make[2]: Entering directory `/root/sysbench-0.4.12/sysbench/drivers’
    Making all in mysql
    make[3]: Entering directory `/root/sysbench-0.4.12/sysbench/drivers/mysql’
    make[3]: Nothing to be done for `all’.
    make[3]: Leaving directory `/root/sysbench-0.4.12/sysbench/drivers/mysql’
    make[3]: Entering directory `/root/sysbench-0.4.12/sysbench/drivers’
    make[3]: Nothing to be done for `all-am’.
    make[3]: Leaving directory `/root/sysbench-0.4.12/sysbench/drivers’
    make[2]: Leaving directory `/root/sysbench-0.4.12/sysbench/drivers’
    Making all in tests
    make[2]: Entering directory `/root/sysbench-0.4.12/sysbench/tests’
    Making all in cpu
    make[3]: Entering directory `/root/sysbench-0.4.12/sysbench/tests/cpu’
    make[3]: Nothing to be done for `all’.
    make[3]: Leaving directory `/root/sysbench-0.4.12/sysbench/tests/cpu’
    Making all in fileio
    make[3]: Entering directory `/root/sysbench-0.4.12/sysbench/tests/fileio’
    make[3]: Nothing to be done for `all’.
    make[3]: Leaving directory `/root/sysbench-0.4.12/sysbench/tests/fileio’
    Making all in memory
    make[3]: Entering directory `/root/sysbench-0.4.12/sysbench/tests/memory’
    make[3]: Nothing to be done for `all’.
    make[3]: Leaving directory `/root/sysbench-0.4.12/sysbench/tests/memory’
    Making all in threads
    make[3]: Entering directory `/root/sysbench-0.4.12/sysbench/tests/threads’
    make[3]: Nothing to be done for `all’.
    make[3]: Leaving directory `/root/sysbench-0.4.12/sysbench/tests/threads’
    Making all in mutex
    make[3]: Entering directory `/root/sysbench-0.4.12/sysbench/tests/mutex’
    make[3]: Nothing to be done for `all’.
    make[3]: Leaving directory `/root/sysbench-0.4.12/sysbench/tests/mutex’
    Making all in oltp
    make[3]: Entering directory `/root/sysbench-0.4.12/sysbench/tests/oltp’
    make[3]: Nothing to be done for `all’.
    make[3]: Leaving directory `/root/sysbench-0.4.12/sysbench/tests/oltp’
    make[3]: Entering directory `/root/sysbench-0.4.12/sysbench/tests’
    make[3]: Nothing to be done for `all-am’.
    make[3]: Leaving directory `/root/sysbench-0.4.12/sysbench/tests’
    make[2]: Leaving directory `/root/sysbench-0.4.12/sysbench/tests’
    Making all in .
    make[2]: Entering directory `/root/sysbench-0.4.12/sysbench’
    /bin/sh ../libtool –tag=CC –mode=link gcc -pthread -g -O2 -o sysbench sysbench.o sb_timer.o sb_options.o sb_logger.o db_driver.o tests/fileio/libsbfileio.a tests/threads/libsbthreads.a tests/memory/libsbmemory.a tests/cpu/libsbcpu.a tests/oltp/libsboltp.a tests/mutex/libsbmutex.a drivers/mysql/libsbmysql.a -L/usr/lib64 -lmysqlclient_r -lpthread -lm -lrt -ldl -lrt -lm
    libtool: link: gcc -pthread -g -O2 -o sysbench sysbench.o sb_timer.o sb_options.o sb_logger.o db_driver.o tests/fileio/libsbfileio.a tests/threads/libsbthreads.a tests/memory/libsbmemory.a tests/cpu/libsbcpu.a tests/oltp/libsboltp.a tests/mutex/libsbmutex.a drivers/mysql/libsbmysql.a -L/usr/lib64 -lmysqlclient_r -lpthread -ldl -lrt -lm -pthread
    /usr/bin/ld: cannot find -lmysqlclient_r
    collect2: ld returned 1 exit status
    make[2]: *** [sysbench] Error 1
    make[2]: Leaving directory `/root/sysbench-0.4.12/sysbench’
    make[1]: *** [all-recursive] Error 1
    make[1]: Leaving directory `/root/sysbench-0.4.12/sysbench’
    make: *** [all-recursive] Error 1

  6. The problem is here:

    “cannot find -lmysqlclient_r”

    And you should install mysqlclient to solve this problem…

  7. I am getting these errors.
    make[2]: Entering directory `/root/sysbench/sysbench’
    /bin/sh ../libtool –tag=CC –mode=link gcc -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast -Wstrict-prototypes -Wnested-externs -Winline -funroll-loops -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align -pthread -O2 -ggdb3 -L/usr/local/lib -o sysbench sysbench.o sb_timer.o sb_options.o sb_logger.o db_driver.o sb_percentile.o tests/fileio/libsbfileio.a tests/threads/libsbthreads.a tests/memory/libsbmemory.a tests/cpu/libsbcpu.a tests/mutex/libsbmutex.a scripting/libsbscript.a drivers/mysql/libsbmysql.a -L/var/lib/mysql -lmysqlclient_r scripting/lua/src/liblua.a -lm -ldl -lrt -lm
    libtool: link: gcc -W -Wall -Wextra -Wpointer-arith -Wbad-function-cast -Wstrict-prototypes -Wnested-externs -Winline -funroll-loops -Wundef -Wstrict-prototypes -Wmissing-prototypes -Wmissing-declarations -Wredundant-decls -Wcast-align -pthread -O2 -ggdb3 -o sysbench sysbench.o sb_timer.o sb_options.o sb_logger.o db_driver.o sb_percentile.o -L/usr/local/lib tests/fileio/libsbfileio.a tests/threads/libsbthreads.a tests/memory/libsbmemory.a tests/cpu/libsbcpu.a tests/mutex/libsbmutex.a scripting/libsbscript.a drivers/mysql/libsbmysql.a -L/var/lib/mysql -lmysqlclient_r scripting/lua/src/liblua.a -ldl -lrt -lm -pthread
    /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(client.c.o): In function `mysql_get_ssl_cipher’:
    (.text+0x2159): undefined reference to `SSL_get_current_cipher’
    /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(client.c.o): In function `send_client_reply_packet’:
    (.text+0x2a68): undefined reference to `SSL_get_peer_certificate’
    /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(client.c.o): In function `send_client_reply_packet’:
    (.text+0x2a80): undefined reference to `X509_get_subject_name’
    /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(client.c.o): In function `send_client_reply_packet’:
    (.text+0x2a94): undefined reference to `X509_NAME_oneline’
    /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(client.c.o): In function `send_client_reply_packet’:
    (.text+0x2aa3): undefined reference to `X509_free’
    /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(client.c.o): In function `send_client_reply_packet’:
    (.text+0x2cbc): undefined reference to `ERR_error_string_n’
    /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(client.c.o): In function `mysql_close’:
    (.text+0x35f4): undefined reference to `SSL_CTX_free’
    /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(client.c.o): In function `mysql_get_ssl_cipher’:
    (.text+0x2162): undefined reference to `SSL_CIPHER_get_name’
    /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(mysql_async.c.o): In function `my_ssl_read_async’:
    (.text+0xcdf): undefined reference to `SSL_read’
    /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(mysql_async.c.o): In function `my_ssl_read_async’:
    (.text+0xd0e): undefined reference to `SSL_get_error’
    /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(mysql_async.c.o): In function `my_ssl_write_async’:
    (.text+0xd8f): undefined reference to `SSL_write’
    /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(mysql_async.c.o): In function `my_ssl_write_async’:
    (.text+0xdbe): undefined reference to `SSL_get_error’
    /usr/lib/gcc/x86_64-redhat-linux/4.4.7/../../../../lib64/libmysqlclient_r.a(vio.c.o): In function `vio_end’:
    (.text+0x5a7): undefined reference to `ERR_remove_state’

Leave a Reply

Your email address will not be published. Required fields are marked *