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/)
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
You probably don’t have mysql-devel installed.
Best regards
I found the problem, I needed to yum install mysql-devel
🙂 I hope this article was helpful to you…
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
HI… Do you have openssl and openssl-devel installed ?
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
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.
id do “yum install mysql-devel”
Still error
Installing mysqlclient15-5.0.67-1.el5.remi.x86_64.rpm provided the needed library
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
The problem is here:
“cannot find -lmysqlclient_r”
And you should install mysqlclient to solve this problem…
Thank you so much!
The libtoolize –force –copy and ./autogen.sh pieces were what I needed!
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’
I get
Resolving garr.dl.sourceforge.net (garr.dl.sourceforge.net)… failed: Name or service not known.
wget: unable to resolve host address âgarr.dl.sourceforge.netâ
–2015-08-27 15:20:44– http://sysbenc/
Resolving sysbenc (sysbenc)… failed: Name or service not known.
when executing
wget http://garr.dl.sourceforge.net/sourceforge/sysbench/ sysbenc
Seems like sourceforge URL doesn’t work
Download the archive from GitHub
https://github.com/akopytov/sysbench